P_ProductOverdueSITBasic2

Material Overdue SIT Basic 2 | view: POVERDUESITBAS2 | TRAN | Extraction: Not supported | Component: Basis

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

🔑 Keys
💰 Amounts (1)
∑ Quantities (4)
📅 Dates (12)
☰ Categorical (3)
Other (24)
🔗 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
creationdate_2	Creation Date of Purchasing Document
GoodsIssuePostingDate_2	Posting Date in the Document
GoodsReceiptPostingDate_2	Posting Date in the Document
ScheduleLineDeliveryDate_2	Item delivery date
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

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
target	null
both_plant	null
LowLevelCode	Low-Level Code	DISST

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