SAP 采购订单进度跟踪表
- 格式:docx
- 大小:112.92 KB
- 文档页数:2
采购订单进度跟踪表
包含字段:订单日期TaxDate,采购员SipCode,供应商CardCode,物料组,物料编号TtemCode,物料描述Description,采购收货单号DocNum,交货日期DocDueDate,状态DocStatus,订单数量,未清数量,入库数量(单据:采购订单OPOR,采购收货单OPDN,物料组OITB,仓库物品列表OITW,未清'O', 已清'C')
查找某一个采购订单与其对应的采购收货单之间的联系
select T1.*from OPOR T0
join POR1T1on T1.DocEntry=T0.DocEntry
where T0.DocNum=427
select T3.*from OPDN T2
join PDN1T3on T2.DocEntry=T3.DocEntry
where T2.DocNum=422
对应关系:
确切代码:
select T0.[TaxDate],T6.[SlpCode],
T0.[CardCode],T4.[ItmsGrpNam],T1.[ItemCode],
T1.[Dscription],T2.[DocNum],T2.[TaxDate],T2.[DocStatus],
T1.[Quantity],
T3.[OpenQty],(T3.[Quantity]-T3.[OpenQty])入库数量
from OPOR T0
INNER JOIN POR1T1ON T0.DocEntry=T1.DocEntry
INNER JOIN PDN1T3ON T3.BaseEntry=T1.DocEntry AND T3.LINENUM=T1.LineNum INNER JOIN OPDN T2ON T2.DocEntry=T3.DocEntry
LEFT JOIN OITM T5ON T5.ItemCode=T1.ItemCode
INNER JOIN OITB T4ON T4.ItmsGrpCOD=T5.ItmsGrpCod
LEFT JOIN OSLP T6ON T6.[SlpCode]=T0.[SlpCode]