Sap基本表关系

KNMT(Customer-MaterialInfo Record DataTable)makt-matnr = knmt-matnr andmakt-spras = sy-languMAKT(MaterialDescription)EKKO(Purchasing DocHeader)EKPO-EBELN =EKKO-EBELNEKPO(Purchasing DocItem)MDKP(MRP Header)MDKP-DTNUM =MDTB-DTNUMMDTB(MRP Detail)

SAP MM - PurchasingPurchasing RequisitionSTXH(STXD SAPscript text file header)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)EBAN(Purchase Requisition)Purchasing Req (BANFN)Item (BNFPO)EBKN(Purchase RequisitioAssignment)Purchasing Req (BANFItem (BNFPO)Preg Account Assignm

STXL(STXD SAPscript text file lines))(RELID)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)(SRTF2)SAP MM - PurchasingPurchase OrdersS011(PURCH: Purch. Group Statistics)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week (SPWOC)Posting Period (SPBUP)Purchasing Org (EKORG)Purchasing Group (EKGRP)Vendor No (LIFNR)S012(PURCHIS: Purchasing Statistics)Statistics (SSOUR)Version (VRSIO)Month (SPMON)Day (SPTAG)Week (SPWOC)Posting Period (SPBUP)Purchasing Org (EKORG)Purchasing Group (EKGRP)Material No (MATNR)Plant (WERKS)Info Record Category (ESOKZ)Material Group (MATKL)Info Record (INFNR)Country (LAND1)EINE(PurchOrganInfo RePurchaInfo RePlant (WEKET(Delivery Schedules)Purchasing Doc (EBELN)Item (EBELP)Delivery Schedule (ETENR)EKPO(Purchasing Document Item)Purchasing Doc (EBELN)Item (EBELP)EINA(PurchInfo Re

EKKN(Account Assignment in PurchasingDocument)SAP MM - PurchasingGoods ReceiptMKPF(Header: Material Document)Document No (MBLNR)Fiscal Year (MJAHR)MSEG(Document Segment: Material)Document No (MBLNR)Fiscal Year (MJAHR)Line Item (ZEILE) S031(Statistics: Movements for currentstocks)EKBE(History of Purchasing Document)MVER(Material consumption)