SAP SD tables

SAP SD Tables list Overview

/0 Comments/in , , /by

SAP Training Tutorials gives to know more on the SAP SD tables which using frequently in SAP SD sales and distribution module. The list of important SP SD tables as below,

General Tables

  • KNA1 : General Data
  • KNB1 : Customer Master – Co. Code Data (payment method, reconciliation acct)
  • KNB4 : Customer Payment History
  • KNB5 : Customer Master – Dunning info
  • KNBK : Customer Master Bank Data
  • KNKA : Customer Master Credit Mgmt.
  • KNVP : Partner Function key
  • KNVD : Output type
  • KNVS : Customer Master Ship Data
  • KNKK : Customer Master Credit Control Area Data (credit limits)
  • KNVV : Sales Area Data (terms, order probability)
  • KNVI : Customer Master Tax Indicator
  • KLPA : Customer/Vendor Link
  • VBUK : Header Status and Administrative Data

SAP Sales Order Document Tables


  • VBAK : Sales Document – Header Data
  • VBKD : Sales Document – Business Data
  • VBUP : Item Status
  • VBAP : Sales Document – Item Data
  • LIPS : Delivery Document item data, includes referencing PO
  • LIKP : Delivery Document Header data
  • VBPA : Partners
  • VBFA : Document Flow
  • VBEP : Sales Document Schedule Line
  • VBBE : Sales Requirements: Individual Records
  • VBRK : Billing Document Header
  • VBRP : Billing Document Item
  • VEKP : Shipping Unit Item (Content)
  • VEPO : Shipping Unit Header

SAP Shipping & Delivery Document Tables

  • LIKP : SD Document: Delivery Header Data
  • LIPS : SD document: Delivery: Item data
  • VEPO : Packing: Handling Unit Item (Contents)
  • VEKP : Handling Unit – Header Table
  • VTTP : Shipment Item
  • VTTK: Shipment Header
  • VBLK : SD Document: Delivery Note Header

SAP Billing Document Tables

  • VBRK : Billing Document: Header Data
  • VBRP : Billing Document: Item Data
  • VBSS : Collective Processing: Sales Documents
  • VKDFS: SD Index: Billing Initiator
  • NAST : Message Status
  • VBSK : Collective Processing for a Sales Document Header
  • VRPMA: SD Index: Billing Items per Material
  • VRKPA : Sales Index: Bills by Partner Functions

SAP Material Master Data Tables

  • MARA : General Material Data
  • MAKT : Material Descriptions
  • MARM : Units of Measure for Material
  • STXH : STXD SAPscript text file header
  • STXL : STXD SAPscript text file lines
  • MARC : Plant Data for Material
  • MVKE : Sales Data for Material
  • T179 : Materials: Product Hierarchies
  • MLAN : Tax Classification for Material

Online Training Tutorials

  • How to Copy GL Master from One Company Code to another Company CodeYou can use OBY2 to copy the GL accounts from one company code to the other company code. 2 nd option. You can go through IMG-Financial acc- G/L A/c- Master data- G/L A/c creation […]
  • SAP SD Interview Questions and AnswersSAP SD (Sales and Distribution) Module -How to Start Learn?SAP SD (Sales and Distribution) is one of the core and most-used modules of SAP R/3 products beside Financial (FI),Controlling(CO), Material Management (MM), and Production Planning (PP) […]
  • sap sd training tutorialsSAP SD (Sales & Distribution) Tutorial for BeginnersSAP SD Tutorial (Sales and Distribution) by the real time functional consultant and experts . The SAP SD module handles all the processes starting from an Order to delivery. The main […]
  • System MonitoringSD Sales and Distribution Transaction CodesSAP SD Transaction Codes SAP SD (Sales and Distribution) using some short-cut codes are provided to save time of the each transaction. These are known as transaction codes (tcodes). SAP […]
  • Copy Control in SAP SDHow to Configuring Copy Control in SAP SD?We can define control data for a flow of documents. You can specify, for a particular sales document type, which document type is to be assigned to copied reference documents, and which […]
  • Availability Check in SAP SDAvailability Check in SAP SD: MD04  -Takes us to the Stock Requirement list [Updation in the stock requirement list is the mainly depends upon checking group of MRP3 screen] When all […]
  • Functions of Goods issue PostingThe Functions of Goods issue Posting in APFunctions of Goods issue Posting:  Updating Stock Quantities : The warehouse stock of the material is reduced by the delivery quantity. You will find information on inventory management in […]
  • Role of Functional consultantRole of Functional consultant in CINRole of Functional consultant: Installation, customization and configuration related to CIN needs to be carried out for the following applications (components) in SAP R/3. This should be a […]