P_SubcontrgOrdItemMntr

P view for Monitor Subcontracting Orders | view: PSUBCONTRORDMNTR | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKBE, EKPO, EKBEH, EKET, MMPO_SUPDLVPRED, T001, TKA02, MARA, T023, T023T, MAKT, T001W, T161, T161T, T024, T024E, T001L, LFA1, USR21
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
GoodsReceiptAmountInCoCodeCrcy Delivered Value
StillToBeDeliveredValue Value to be Delivered
TargetAmount Target Value for Header Area per Distribution
ReleasedAmount Released Value
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
GoodsReceiptQty Delivered Quantity
StillToBeDeliveredQuantity Quantity to be Delivered
OpenPurchaseOrderQuantity Next Delivery Quantity
ReleasedQuantity null
RequiredQuantity Next Shipping Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ScheduleLineDeliveryDate Next Delivery Date
RequirementDate Next Shipping Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
SupplierIsSubcontractor Subcontracting Supplier Show values
Column Name Description Domain name
FormattedPurchasingDocItem Purchasing Document Item
PurchasingDocumentItemText Item Description TEXT50
AssemblyName Material Description TEXT40
PlantName Plant Name TEXT30
SubcontractorName Name of Supplier TEXT80
MaterialGroupName Material Group Description TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
StorageLocationName Storage Location Name TEXT16
RequirementTracking Requirement Tracking Number CHAR10
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurchasingDocumentType Order Type (Purchasing) BSART
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
SchedAgrmtValidityStatus null
StatusDescription null
PurchaseOrderTypeName Short Description of Purchasing Document Type TEXT20
DeliveryStatus Next Delivery Status
MaterialComponent Component MATNR
MaterialName Material Description TEXT40
Supplier Third-Party Supplier LIFNR
SupplierName Supplier Name TEXT80
ShippingStatus Next Shipping Status
ShippingStatusText Next Shipping Status
DifferenceInDays null
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_SUBCONTRGORDITEMMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_SUBCONTRGORDITEMMNTR.MANDT == T163K.MANDT
Assembly
  • Assembly
  • Client
  • P_SUBCONTRGORDITEMMNTR.ASSEMBLY == MARA.MATNR
  • P_SUBCONTRGORDITEMMNTR.MANDT == MARA.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUBCONTRGORDITEMMNTR.BASEUNIT == T006.MSEHI
  • P_SUBCONTRGORDITEMMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUBCONTRGORDITEMMNTR.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • P_SUBCONTRGORDITEMMNTR.COMPANYCODE == T001.BUKRS
  • P_SUBCONTRGORDITEMMNTR.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_SUBCONTRGORDITEMMNTR.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SUBCONTRGORDITEMMNTR.MANDT == TCURC.MANDT
Material Group
  • Material Group
  • Client
  • P_SUBCONTRGORDITEMMNTR.MATERIALGROUP == T023.MATKL
  • P_SUBCONTRGORDITEMMNTR.MANDT == T023.MANDT
MRP Area
  • MRP Area
  • Client
  • P_SUBCONTRGORDITEMMNTR.MRPAREA == MDLV.BERID
  • P_SUBCONTRGORDITEMMNTR.MANDT == MDLV.MANDT
Plant
  • Plant
  • Client
  • P_SUBCONTRGORDITEMMNTR.PLANT == T001W.WERKS
  • P_SUBCONTRGORDITEMMNTR.MANDT == T001W.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_SUBCONTRGORDITEMMNTR.PURCHASEORDERITEMCATEGORY == T163.PSTYP
  • P_SUBCONTRGORDITEMMNTR.MANDT == T163.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUBCONTRGORDITEMMNTR.BASEUNIT == T006.MSEHI
  • P_SUBCONTRGORDITEMMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUBCONTRGORDITEMMNTR.MANDT == T006.MANDT
Purchase Order Type
  • Purchasing Document Category
  • Purchase Order Type
  • Client
  • P_SUBCONTRGORDITEMMNTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_SUBCONTRGORDITEMMNTR.PURCHASEORDERTYPE == T161.BSART
  • P_SUBCONTRGORDITEMMNTR.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SUBCONTRGORDITEMMNTR.PURCHASINGGROUP == T024.EKGRP
  • P_SUBCONTRGORDITEMMNTR.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_SUBCONTRGORDITEMMNTR.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUBCONTRGORDITEMMNTR.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • P_SUBCONTRGORDITEMMNTR.PLANT == T001L.WERKS
  • P_SUBCONTRGORDITEMMNTR.STORAGELOCATION == T001L.LGORT
  • P_SUBCONTRGORDITEMMNTR.MANDT == T001L.MANDT
Subcontractor
  • Subcontractor
  • Client
  • P_SUBCONTRGORDITEMMNTR.SUBCONTRACTOR == LFA1.LIFNR
  • P_SUBCONTRGORDITEMMNTR.MANDT == LFA1.MANDT