P_ProductOverdueSITBasic1

Material Overdue SIT Basic | view: POVERDUESITBAS | Extraction: Not supported | Component: Basis

Tables used: MATDOC, EKKO, EKPO, EKET, MARA, MARC, T001W

🔑 Keys
💰 Amounts (1)
∑ Quantities (4)
📅 Dates (9)
☰ Categorical (5)
Other (23)
🔗 Relations (17)

Column Name	Description

Column Name	Description
💲 Currency Key (DocumentCurrency):
NetAmount	Net Order Value in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (BaseUnit):
PurchaseOrderItemQuantity	Purchase Order Quantity
GoodsIssueQuantity	Goods Issue Quantity
GoodsReceiptQuantity	Goods Receipt Quantity
📏 Volume unit (VolumeUnit):
MaterialVolume	Volume

Column Name	Description
CreationDate	Creation Date of Purchasing Document
GoodsIssuePostingDate	Posting Date in the Document
GoodsReceiptPostingDate	Posting Date in the Document
LastPostingDateOfMaterialDoc	null
ScheduleLineDeliveryDate	Item delivery date
RealOrExpectedMaterialPostgDte	null
ProductCreationDate	Created On
CrossPlantStatusValidityDate	Date from which the cross-plant material status is valid
SalesStatusValidityDate	Date from which the X-distr.-chain material status is valid

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
StockInTransitProcessType	SIT Process Type	Show values
GoodsReceiptIsCanceled	Item has been Cancelled	Show values
GoodsIssueIsCanceled	Item has been Cancelled	Show values

Column Name	Description	Domain name
PurchaseOrderItem	Item Number of Purchase Order	EBELP
GoodsIssueMaterialDocument	Number of Material Document	BELNR
GoodsIssueMaterialDocumentItem	Item in Material Document	MBLPO
GoodsIssueMaterialDocumentYear	Fiscal Year	GJAHR
GoodsReceiptMaterialDocument	Number of Material Document	BELNR
GoodsReceiptMaterialDocItem	Item in Material Document	MBLPO
GoodsReceiptMaterialDocYear	Fiscal Year	GJAHR
IssuingPlantName	Name	TEXT30
CreatedByUser	User of person who created a purchasing document	USNAM
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
MaterialName	Material Description	TEXT40
DifferenceOfGRAndGIDate	Delta of GR Date and GI Date
UnitOfMeasure	3-Byte field	CHAR3
GoodsIssueMovementType	Movement Type of Goods Issue	BWART
ReceivingPlant	Receiving Plant	WERKS
ReceivingPlantName	Receiving Plant Name	TEXT30
GoodsReceiptMovementType	Movement Type of Goods Receipt	BWART
ReceivingCompanyCode	Receiving Company Code	BUKRS
StorageLocation	Storage location	LGORT
Batch	Batch Number	CHARG
ScheduleLine	Delivery Schedule Line Counter	EETEN
DaysInTransit	Number of Days a Stock has been in Transit
LowLevelCode	Low-Level Code	DISST

Master Data Relations	Join Conditions
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`P_PRODUCTOVERDUESITBASIC1.BASEUNIT == T006.MSEHI` `P_PRODUCTOVERDUESITBASIC1.MANDT == T006.MANDT`
Currency Key Client Currency Key	`P_PRODUCTOVERDUESITBASIC1.MANDT == TCURC.MANDT` `P_PRODUCTOVERDUESITBASIC1.DOCUMENTCURRENCY == TCURC.WAERS`
Special Stock Indicator Client Special Stock Indicator	`P_PRODUCTOVERDUESITBASIC1.MANDT == T148.MANDT` `P_PRODUCTOVERDUESITBASIC1.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ`
Default storage location for external procurement Default storage location for external procurement Default storage location for external procurement Client Receiving Plant	`P_PRODUCTOVERDUESITBASIC1.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT` `P_PRODUCTOVERDUESITBASIC1.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT` `P_PRODUCTOVERDUESITBASIC1.MANDT == T001L.MANDT` `P_PRODUCTOVERDUESITBASIC1.RECEIVINGPLANT == T001L.WERKS`
MRP controller MRP Controller MRP Controller Client Receiving Plant	`P_PRODUCTOVERDUESITBASIC1.ISSPMRPCONTROLLER == T024D.DISPO` `P_PRODUCTOVERDUESITBASIC1.RECPMRPCONTROLLER == T024D.DISPO` `P_PRODUCTOVERDUESITBASIC1.MANDT == T024D.MANDT` `P_PRODUCTOVERDUESITBASIC1.RECEIVINGPLANT == T024D.WERKS`
Company Code Client Receiving Company Code Company Code	`P_PRODUCTOVERDUESITBASIC1.MANDT == T001.MANDT` `P_PRODUCTOVERDUESITBASIC1.RECEIVINGCOMPANYCODE == T001.BUKRS` `P_PRODUCTOVERDUESITBASIC1.ISSUINGCOMPANYCODE == T001.BUKRS`
Plant Client Plant	`P_PRODUCTOVERDUESITBASIC1.MANDT == T001W.MANDT` `P_PRODUCTOVERDUESITBASIC1.ISSUINGPLANT == T001W.WERKS`
Material Number Material Number Client	`P_PRODUCTOVERDUESITBASIC1.MATERIAL == MARA.MATNR` `P_PRODUCTOVERDUESITBASIC1.MANDT == MARA.MANDT`
MRP Area Client MRP Area	`P_PRODUCTOVERDUESITBASIC1.MANDT == MDLV.MANDT` `P_PRODUCTOVERDUESITBASIC1.MRPAREA == MDLV.BERID`
Material Group Client Product Group	`P_PRODUCTOVERDUESITBASIC1.MANDT == T023.MANDT` `P_PRODUCTOVERDUESITBASIC1.PRODUCTGROUP == T023.MATKL`
Product Hierarchy Client Product hierarchy	`P_PRODUCTOVERDUESITBASIC1.MANDT == T179.MANDT` `P_PRODUCTOVERDUESITBASIC1.PRODUCTHIERARCHY == T179.PRODH`
Unit of Measure Client Purchase Order Unit of Measure	`P_PRODUCTOVERDUESITBASIC1.MANDT == T006.MANDT` `P_PRODUCTOVERDUESITBASIC1.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchasing Document Type Purchasing Document Type Client Purchasing Document Category	`P_PRODUCTOVERDUESITBASIC1.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_PRODUCTOVERDUESITBASIC1.MANDT == T161.MANDT` `P_PRODUCTOVERDUESITBASIC1.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP`
Default storage location for external procurement Default storage location for external procurement Default storage location for external procurement Client Receiving Plant	`P_PRODUCTOVERDUESITBASIC1.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT` `P_PRODUCTOVERDUESITBASIC1.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT` `P_PRODUCTOVERDUESITBASIC1.MANDT == T001L.MANDT` `P_PRODUCTOVERDUESITBASIC1.RECEIVINGPLANT == T001L.WERKS`
MRP controller MRP Controller MRP Controller Client Receiving Plant	`P_PRODUCTOVERDUESITBASIC1.ISSPMRPCONTROLLER == T024D.DISPO` `P_PRODUCTOVERDUESITBASIC1.RECPMRPCONTROLLER == T024D.DISPO` `P_PRODUCTOVERDUESITBASIC1.MANDT == T024D.MANDT` `P_PRODUCTOVERDUESITBASIC1.RECEIVINGPLANT == T024D.WERKS`
Volume Unit Volume unit Client	`P_PRODUCTOVERDUESITBASIC1.VOLUMEUNIT == T006.MSEHI` `P_PRODUCTOVERDUESITBASIC1.MANDT == T006.MANDT`