-->

Wednesday, March 14, 2012


SAP MM Tables

SAP Materials Management Tables


SAP MM Purchasing Tables:

EBAN     Purchase Requisition 
EBKN     Purchase Requisition Account Assignment 
EBUB     Index for Stock Transport Requisitions for Material
EINA      Purchasing Info Record: General Data 
EINE      Purchasing Info Record: Purchasing Organization D
EIPA      Order Price History: Info Record 
EKAB     Release Documentation 
EKAN     Vendor Address: Purchasing Document 
EKBE     History per Purchasing Document 
EKBEH   Removed PO History Records 
EKBZ      History per Purchasing Document: Delivery Costs 
EKBZH   History per Purchasing Document: Delivery Costs 
EKEH      Scheduling Agreement Release Documentation 
EKEK      Header Data for Scheduling Agreement Releases 
EKES      Vendor Confirmations 
EKET      Scheduling Agreement Schedule Lines 
EKETH    Scheduling Agreement Schedules: History Tables 
EKKI       Purchasing Condition Index 
EKKN     Account Assignment in Purchasing Document 
EKKO     Purchasing Document Header 
EKPA      Partner Roles in Purchasing 
EKPB      "Material Provided" Item in Purchasing Document 
EKPO      Purchasing Document Item 
EKPV      Shipping-Specific Data on Stock Tfr. for Purch. D 
EKRS      ERS Procedure: Goods (Merchandise) Movements to b 
EKUB      Index for Stock Transport Orders for Material 
EORD      Purchasing Source List 
EQUK      Quota File: Header 
EQUP      Quota File: Item 
T024        Purchasing Groups 
T024E      Purchasing Organizations 
T024W    Valid Purchasing Organizations for Plant 
T024Z      Purchasing Organizations 
T027A      Shipping Instructions, Purchasing 
T027B      Texts: Shipping Instructions 
T027C      Codes for Compliance with Shipping Instructions 
T027D      Compliance with Shipping Instructions: Texts 
T069         Certificate Categories 
T069Q      Control Data for Source Determination and Checkin 
T069T       Certificate Categories: Text Description  

Tuesday, March 13, 2012


SAP SD Tables

SAP Sales and Distribution Tables:
                
Customers    
    
                  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.
                  KNKK   Customer Master Credit Control Area Data (credit limits)
                  KNVV   Sales Area Data (terms, order probability)
                  KNVI    Customer Master Tax Indicator
                  KNVP   Partner Function key
                  KNVD   Output type
                  KNVS   Customer Master Ship Data
                  KLPA    Customer/Vendor Link
                                   
Sales Documents  

                  VBAKUK VBAK + VBUK

                  VBUK   Header Status and Administrative Data
                  VBAK   Sales Document - Header Data
                  VBKD   Sales Document - Business Data
                  VBUP   Item Status
                  VBAP   Sales Document - Item Data
                  VBPA   Partners
                  VBFA   Document Flow
                  VBEP   Sales Document Schedule Line
                  VBBE   Sales Requirements: Individual Records

Materials    

                  MARA    Material Master: General
                  MARC    Material Master: Plant
                  MAKT     Material Master: Short description
                  MARM    Material Master: Conversion factors
                  MVKE     Material Master: Sales
                  MLAN     Material Master: Sales
                  MAEX     Material Master: Export Licenses
                  MBEW    Material Master: Valuation
                  MLGN     Material Master: WM Inventory
                  MLGT     Material Master: WM Inventory type
                  MVER     Material Master: Consumption
                  DVER     Material Master: Consumption
                  MAPR     Material Master: Forecast
                  MARD     Material Master: Storage Location
                  MCH1     Material Master: X Plant Batches
                  MCHA     Material Master: Batches
                  MCHB     Material Master: Batch Stock
                  MARCH  Material Master C Segment: History
                  MARDH  Material Master Storage Location Segment: History
                  MBEWH  Material Valuation: History
                  MCHBH   Batch Stocks: History
                  MKOLH   Special Stocks from Vendor: History
                  MSCAH   Sales Order Stock at Vendor: History
                  MSKAH   Sales Order Stock: History
                  MSKUH   Special Stocks at Customer: History
                  MSLBH    Special Stocks at Vendor: History
                  MSPRH   Project Stock: History
                  MSSAH   Total Sales Order Stocks: History
                  MSSQH  Total Project Stocks: History