内容发布更新时间 : 2024/11/15 0:06:48星期一 下面是文章的全部内容请认真阅读。
T001L 库存地点
Purchasing PO EKKO Purchasing Document Header询报价(凭证类型=A);采购合同(凭证类型=K)
EKPO Purchasing Document Item Detail EKBE 采购订单历史
EBAN 采购申请(行项目) EBKN 采购申请
BAM 采购申请逻辑数据库
EKET 采购订单delivery schedule EKES 采购订单与内向交货单的关系; S011 LIS -- Purchasing Groups S012 LIS -- Purchasing S013 LIS -- Vendor Evaluation S080 LIS -- Purchasing - Movements S081 LIS -- Purchasing - Stock
S082 LIS -- Purchasing - Movements & Stock
EKBZ (发票校验和采购订单关联的表) 审批表
采购订单的审批 CEKKO 采购申请 CEBAN
Batch Management
MCHA Batches
S038 LIS -- Inventory Controlling - Batches
Inventory Management
MSLB Special Stocks with Vendor供应商特殊库存(外协,委外)
MSKU Special Stocks with Customer IKPF Physical Inventory Header(盘点凭证) ISEG Physical Inventory Document Item Detail S032 LIS -- Statistics Table - Current Stocks S039 LIS -- Inventory Controlling MSKA Sales Order Stock MCHA 批次库存
MCHB 批次库存
Material Documents
MKPF Material Document Header MSEG Material Document Item Detail
Warehouse Management
LTAK Transfer Order Header LTAP Transfer Order Item Detail LTBK Transfer Requirement Header LTBP Transfer Requirement Item Detail LAGP Storage Bin Master
Invoice verify BKPF BSEG
(SD) SALES AND DISTRIBUTION
Sales Documents
VBAK Sales Document - Header Data
VBAP Sales Document - Detail Data (保存了) VBEP 销售凭证:计划行数据
VBBE 销售需求(拖延订单或者断货)
VBUK 销售凭证:抬头状态和管理数据(也可以看到DN单的状态)
VBFA 销售凭证流,【先前的销售和分销凭证】VBELV字段就是在VA01里看到订单的最顶层;
VBPA 售达方、收货方->再根据【地址号码】ADRNR查找【ADRC】表找到相应的地址; VBAK-VBELN 关联VBPA-VBELN; 如何查找电子邮件地址?ADR6
KONV 销售订单价格表:Condition Procedures(含有内容比较多)(通过VBAK的KNUMV和KPOSN两个字段)
Delivery Documents
LIKP Delivery Document - Header Data
l (包含售达方,送达方内容),可以通过LIKP找到VBPA,然后再找ADRC l LIKP- LFART(交货单类型) l 也包含了内向交货单
LIPS Delivery Document - Detail Data ;
Billing Documents
VBRK Billing Document - Header Data VBRP Billing Document - Detail Data
Condition Tables(价格)
KONH Condition Header(通讯表) KONP Condition Detail
KONV Condition Procedures(是代表销售订单的价格数据)(通过VBAK的KNUMV和KPOSN两个字段)
KOTE* Rebate(回扣) Condition Tables – many *966 966是条件表,如果不会则前面加*查找一下; KOTN* 买赠(VBN1创建的)