1.背景
以下是我在开发中用到的表,以下是开发中用到的表.
2.常用表
MKOL is the stock table for vendor consignment.
MKOl,与供应商委托的物料.
MSEG is the most important Transaction data table in MM. It stores data regarding all transactions in MM Module
MSEG是在MM中最重要的事物代码表,它存了所有MM模块事物相关的数据。
MARD is a standard SAP Table which is used to store Storage Location Data for Material data .
MARD是用来存物料数据位置的标准表(有寄售(不区分供应商),也有自有)。
RKWA is a standard SAP Table which is used to store Consignment Withdrawals data .
RKWA是用于存取寄售提款数据。
EKKO (Purchasing Document Header) is a standard table in SAP R\3 ERP systems.
A purchasing document has a header and one or more line items. The header is stored in table EKKO the line items are stored in table EKPO. The two tables can be linked together based on the purchasing document number (field EBELN).
EKKO是存采购表头的表;EKPO是存储表休的表。这两个表这间连接是通过EBELN这个字段来连接的。
EKBE is a standard SAP Table which is used to store History per Purchasing Document data and is available within R/3 SAP systems depending on the version and release level. … You can view further information about SAP EKBE Table and the data within it using relevant transactions such as SE11, SE80 or SE16.
EKBE是存采购文档数据历史的表。
3.总结
SELECT DISTINCT 可以查看我们有多少条没有重复的记录.