Wednesday 9 December 2015

SAP SD Tables list Overview

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,

http://www.technosap.com/sap-overview/sap-sd-tables-list-overview/

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 (creditlimits)
  • 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

1 comment:

  1. Hello sir,your article about SAP SD Tables list Overview is very good.Thanks for sharing useful information about General,SAP Sales Order Document,SAP Shipping & Delivery Document,SAP Billing Document and SAP Material Master Data Tables in your blog.Visit us at SAP SD Online Training in Hyderabad.

    ReplyDelete