P_MaterialOverdueSITPredBasic

Basic View of Prediction Model | view: PMATOVERDUESITPB | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements
Tables used: LIKPLIPSMATDOCEKKOEKPOEKETT001W
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 Quantity (PO)
GoodsIssueQuantity Goods Issue Quantity
GoodsReceiptQuantity Goods Receipt Quantity
Column Name Description
CreationDate Purchasing Document Date
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
LastPostingDateOfMaterialDoc null
ScheduleLineDeliveryDate Item delivery date
CREATIONDATE_2 Purchasing Document Date
GoodsIssuePostingDate_2 Posting Date of Goods Issue
GoodsReceiptPostingDate_2 Posting Date of Goods Receipt
ScheduleLineDeliveryDate_2 Item delivery date
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 Material Document of Goods Issue BELNR
GoodsIssueMaterialDocumentItem Material Document Item of Goods Issue MBLPO
GoodsIssueMaterialDocumentYear Material Document Year of Goods Issue GJAHR
GoodsReceiptMaterialDocument Material Document of Goods Receipt BELNR
GoodsReceiptMaterialDocItem Material Document Item of Goods Receipt MBLPO
GoodsReceiptMaterialDocYear Material Document Year of Goods Receipt GJAHR
IssuingPlantName Issuing Plant Name TEXT30
CreatedByUser Purchase Order Created by User XUBNAME
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
MaterialName Material Description TEXT40
NumbersOfDaysSincePurOrdPostg Days since Posting Date
DifferenceOfGRAndGIDate Duration between GI and GR posting date
UnitOfMeasure 3-Byte field CHAR3
GoodsIssueMovementType Movement Type of Goods Issue BWART
ReceivingPlantName Plant Name TEXT30
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
StorageLocation Storage location LGORT
Batch Batch Number CHARG
ScheduleLine Delivery Schedule Line Counter EETEN
target null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.BASEUNIT == T006.MSEHI
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.DOCUMENTCURRENCY == TCURC.WAERS
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == TCURC.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T148.MANDT
  • P_MATERIALOVERDUESITPREDBASIC.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Issuing Company Code
  • Issuing Company Code
  • Receiving Company Code
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDBASIC.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T001.MANDT
Issuing Plant
  • Issuing Plant
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.ISSUINGPLANT == T001W.WERKS
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == MARA.MANDT
  • P_MATERIALOVERDUESITPREDBASIC.MATERIAL == MARA.MATNR
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_MATERIALOVERDUESITPREDBASIC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T161.MANDT
Receiving Company Code
  • Issuing Company Code
  • Receiving Company Code
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDBASIC.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T001.MANDT
Receiving Plant
  • Receiving Plant
  • Client
  • P_MATERIALOVERDUESITPREDBASIC.RECEIVINGPLANT == T001W.WERKS
  • P_MATERIALOVERDUESITPREDBASIC.MANDT == T001W.MANDT