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

本文详细介绍了SAP系统中客户、物料、供应商主数据以及对应的数据库表,包括客户模块的KNA1、KNB1等,物料模块的MARA、MARC等,供应商模块的LFA1、LFB1等,还涵盖了生产计划、库存管理、采购、销售和分销、财务管理等多个领域的关键数据表。通过对这些表的理解,有助于深入掌握SAP系统的运作机制。
摘要由CSDN通过智能技术生成

Customer Master

KNA1                         Customer Basic Data

KNB1                         Customer Company Level Data客户的公司数据

KNVV                        Customer Sales Level Data 客户的销售数据

KNVP                        Customer Partnering Data客户合作伙伴

KNKA                        Customer Credit Data - Centralized

KNKK                       Customer Credit Data - Control Area Level

KNBK                       Customer Bank Details

KNVH                       Customer Hierarchies

KNVL                        Customer Licenses

KNMT                       Customer - Material Info Record,客户-物料信息记录数据表

KNMTK                     Customer- Material Info Record - Header

KNVK                       联系人(供应商,客户)

Material Master

MARA                       Material Basic Data(物料类型,,,,,)

MARC                       Material MRP (Plant) Data(工厂的MRP视图)

MARD                       Material Storage Data (查看总库存)(物料的仓储位置数据)

MARDH                    Material Storege  Data His.查看库存的历史库存(月度的库存)

MARM                      物料计量单位

MBEW                      Material ValuationData(查看财务视图-)成本价格) 没有工厂字段,但有评估范围字段;

MKAL                       Material Production Version Data(生产版本)

MAKT                       Material Descriptions/Short Texts(物料描述)

MARM                      Material Units of Measure(物料主单位的转换数量)

MVKE                       Material Sales Level Data (销售视图)

MSKU                       Special Stocks with Customer ( ? )

MLGN                       Material Warehouse Data

MVKE                       Material Sales Data

MTXH                       Material Long Text

MCHA                       Batch management  table(批次管理)

MCHB                       批次库存

MSKA                        SalesOrder Stock(销售库存)

MAPL                        分配任务清单到物料,物料所建的工艺路线(Q类型为检验计划)

MAST                        分配BOM到物料

MVKE                        物料销售数据(查找销售单位)

MLAN                        物料的税分类

MDLV                        定制 MRP 运行区域(与MDLG是明细) MRP范围

MDLG                               

MDMA                       物料与MRP AREA的关联关系;

T023                           物料组

T023T                                 

 

Vendor Master 供应商

LFA1                         Vendor Master -- General Data

LFB1                         Vendor Master -- Company Code Data(公司,财务视图)

LFM1                        Vendor Master -- Purchasing Org. Data(采购组织)

LFB5                         Vendor Master -- Dunning Data

LFBK                        Vendor Master -- Bank Details((银行信息)-àBNKA银行表  

LFBW                       Vendor Master -- Withholding Tax Types

LBC1                         Vendor Master -- Transaction Figures

LFM2                        Vendor Master -- Purchasing Data

LFMC                        Vendor Master -- Condition Type Short Text

LFMH                       Vendor Hierarchy

KNVK                       联系人(供应商,客户)

WYT3                        合伙人信息;

 

PP MASTER DATA (cont.)

Factory Calendar

TFACD                      Factory Calendar Definition

TFACS                      Factory Calendar Display (days/month)

TFACT                      Factory Calendar Texts

TFAIN       

  • 1
    点赞
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值