SAP各模块字段与表的对应关系

内容发布更新时间 : 2024/5/19 20:51:07星期一 下面是文章的全部内容请认真阅读。

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创建的)

联系客服:779662525#qq.com(#替换为@) 苏ICP备20003344号-4 ceshi