SAP SD Tables

Spread the love

Today’s tutorials cover SAP SD tables used in distribution and sales. List of essential and regular tables used in SAP sales and distribution module ( SD ). This is Just a ready reference can be used to write FS or to analyses the data. SAP reserve some naming convention for all table, E,g all sales table start with V, Most database-related tables start with D or T, The initial characters “Y” and “Z” are reserved for customers

SAP SD Tables
SAP SD Tables

Customer Master Table

  • KNA1 General Data Customers
  • KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)
  • KNB4 Customer Payment History
  • KNB5 Customer Master – Dunning info                                                                                
  • KNBK Customer Master Bank Data
  • KNVV – SALES AREA DATA
  • KNVP – PARTNER FUNCTION
  • KNVI – Tax classification
  • ADRC – Address data
  • ADR6 – Email ID

Material Master table

  • MARA – General data
  • MAKT – Material description
  • MARC – Plant Data
  • MVKE – Sales data for material master
  • MBEW – Material master accounting data
  • MARD – Storage location data in Material master
  • MARM – Used for Unit of measure for material master

 Sales Document Table

  • VBAK – Sales docment header data.
  • VBAP – Sales document Item data.
  • VBEP – Scheduling data.
  • VBKD – Business data.
  • VBPA – Sales document Partner Function.
  • VBUK – Sales document header STATUS.
  • VBUP – Sales Document item Status.
  • VBFA – Document flow.

 Delivery Document Table

  • LIKP – Delivery document header data.
  • LIPS – Delivery document item data.
  • VBUK – Delivery document header status.
  • VBUP – Delivery document item status.
  • VBBE – Sales requirement indivisual records.

Billing Document Table

  • VBRK – Billing document header data.
  • VBRP – Billing document item data.
  • VBUK – Billing document header status.
  • VBUP – Billing document item status.

Output Determination table

  • NAST – Output determination.

Pricing Table

  • KONV – Pricing table.
  • KONP – Condition Item.
  • KONH – Conditions Header.
  • A+Condition Table -Condition records ,E,g A352

Credit Management

  • KNKK – Customer master credit control area.
  • KNKA – Customer master credit management.

Rebate Management

  • KONA – Rebate Management.

SD Shipping Unit 

  • VEKP   Shipping Unit Item (Content)
  • VEPO   Shipping Unit Header

Happy Learning ..!!

Now follow these tutorial links to learn more about 

Leave a Reply

error

Enjoy this blog? Please spread the word :)

%d bloggers like this: