SAP Tables

SAP TABLES: (¶×Á` )
AFKO    " ORDER HEADER DATA PP ORDERS
AFPO  " ORDER ITEM
AFRU    " ORDER COMPLETION CONFIRMATIONS
AUFM    " GOODS MOVEMENTS FOR ORDER
AFVV    " DB STRUCTURE OF THE QUANTITIES/DATES/VALUES IN THE OPER
MARA    " GENERAL MATERIAL DATA

BKPF            " Accounting Document Header
BSEG            " Accounting Document Segment
SKAT            " G/L Master record-Coa
GLT0            " G/L Master Transaction Figures
TCurt           " Currency Code Names
SKB1            " G/L Master Record-Cocd
USR03           " User Address Data
T001            " Company Code Text

MAKT /MARD /MCHD /MKOL/MSKA/MSKU/MSSA/MSPR/MSSQ/MBEW/EBEW/QBEW

===============================================================================
BSEG 和 BSIS / BSAS / BSID/ BSAD / BSIK  / BSAK 六个表之间的关系

 BSAS + BSIS + BSAK + BSIK + BSAD + BSID = BSEG
 
  CLEARED       |    OPENED
  -----------------------------------
   BSAS         |   BSIS  => ALL GL DOCUMENTS
   BSAK         |   BSIK  => ALL AP DOCUMENTS
   BSAD         |   BSID  => ALL AR DOCUMENTS
  
   BKPF 是财务凭证抬头, BSEG 是财务凭证行项目.
   在财务凭证记账时候 ,数据被插入BKPF和BSEG.
   如有必要数据同时插入以上六张表中的一个未清表。
   做清账时候，数据从六张表中的一个未清表删除.同时插入对应的已清表。
   
   BSAD :  应收明细(已清账)客户

   BSID :  应收明细(未清账)客户

   BSAS :  总账明细(已清账)总账

   BSIS :  总账明细(未清账)总账
   BSAK :  应付明细(已清账)客户
   BSIK :  应付明细(未清账)客户

   
   BSEG 主要通过 “凭证号”，“会计年度”，“行号”和这六张表关联
   BSEG 使用
    BUKRS (COMPANY CODE)
    BELNR (DOCUMENT NO)
    GJAHR (FISCAL YEAR)
    BUZEI (LINE ITEM)字段与其它表关联       
===============================================================================================   
T001: Company Codes .                           MANDT / BUKRS
MARA: General Material Data.                    MANDT / MATNR
MARC: Plant Data FOR Material.                  MANDT / MATNR / WERKS
MARD: Storage Location Data FOR Material.       MANDT / MATNR / WERKS / LGORT
MAKT : Material Descriptions                    MANDT / MATNR /SPRAS
MBEW : Material Valuation                       MANDT/ MATNR/ BWKEY / BWTAR
EINA : Purchasing Info Record : General Data.      MANDT/INFNR
EINE : Purchasing Info Record : Purchasing Organization Data.    MANDT / INFNR/ EKORG/ ESOKZ / WERKS

VBAK : Sales Document : Header Data      MANDT / BBELN
VBAP : Sales Document : Item Data        MANDT / BBELN / POSNR
VBRK : Billing Document :Header Data     MANDT / VBELN
VBRP : Billing Document :Item   Data     MANDT / VBELN / POSNR

VBKD : Sales Document: Business Data     MANDT /VBELN / POSNR

LFA1 : Vendor Master (General Section)    MANDT / LIFNR
LFB1 : Vendor Master (Company CODE).      MANDT / LIFNR /BUKRS

BSEG: Accounting Document Segment         MANDT / BUKRS / BELNR / GJAHR /BUZEI(NUMBER OF LINE ITEM WITHIN ACCOUNTING DOCUMENT)

BSIK BSAK  供应商的
BSID BSAD  按客户的

 

与MRP 有关联的表

MDKPDB / MDTB / MDKP /MDTC / T457T
MDKP   HEADER Data for MRP Document
MDKPDB
MDTB     MRP Table
MDTC     Aggregated MRP Table Items
T457T    Description of MRP Elements

======================================================================
MKPF          "Header: Material Document
MSEG          "Document Segment :Material
MAKT          "Material Descriptions
MARC          "Material Descriptions
MARA          "Material
EKKO ,AFKO , LFA1
USR03

====================================================================
MARA        "General Material Data
MAKT        "Material Descriptions
MBEW        "Material Valuation
SKAT        "G/L Account Master Record
T025T       "Valuation Class Descriptions
T030        "Standard  Accounts Table

MAST         Material BOM
STKO         BOM Header
STPO         BOM Positions (detail)
MAPL         Assignment for Task Lists to Materials
PLKO         Routing Group Header
PLSO         Routing Group Sequence
PLPO         Routing Group Operations
AFKO         Production Order Header
AFPO         Production Order Position(details)

================================================
T003T         'Document type texts
SKAT          'G/L Account Master Record
LFA1          'Vendor Master (General section)
ANLA          'Asset Master Record-segment
KNA1          'General data in Customer Master
CSKT          'Cost Center Texts

======================================================
MDKP        'HEADER Data for MRP DOCUMENT
MDTB        'MRP TABLE
MKPF        'Header: Material Document
MSEG        'Document Segment: Material
MARD        'Storage Location Data for Material
EKKO        'Purchasing Document Header
EKPO        'Purchasing Document Item
EKET        'Scheduling Agreement Schedule Lines
MARC        'Plant Data for Material
EINA        'Purchasing Info Record: General Data
MARA        'General Material Data
PBIM        'Independent Requirements for Material
PBED        'Independent Requirement Data