P_Subcontrg3rdPtyDocsMntr

P view 3rd Party Purchasing Docs | view: PTHDPTYDOCMNTR | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKBE, EKPO, EKBEH, EKET, MMPO_SUPDLVPRED, EKKO, EKPO, 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
RequiredQuantity Next Shipping Quantity
ReleasedQuantity null
OpenPurchaseOrderQuantity Next Delivery 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
Assembly Assembly MATNR
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
DeliveryStatusDescription Next Delivery Status
MaterialName Material Description TEXT40
SupplierName Name of Supplier TEXT80
ShippingStatus Next Shipping Status
ShippingStatusText Next Shipping Status
DifferenceInDays null
DeliveryDateCriticality null
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T163K.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUBCONTRG3RDPTYDOCSMNTR.BASEUNIT == T006.MSEHI
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.COMPANYCODE == T001.BUKRS
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == TCURC.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.DOCUMENTCURRENCY == TCURC.WAERS
Component
  • Client
  • Component
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == MARA.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.MATERIALCOMPONENT == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.MATERIALGROUP == T023.MATKL
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T023.MANDT
MRP Area
  • Client
  • MRP Area
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == MDLV.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.MRPAREA == MDLV.BERID
Plant
  • Plant
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.PLANT == T001W.WERKS
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001W.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T163.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUBCONTRG3RDPTYDOCSMNTR.BASEUNIT == T006.MSEHI
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • Purchasing Document Category
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERTYPE == T161.BSART
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T024.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Client
  • Storage Location
  • P_SUBCONTRG3RDPTYDOCSMNTR.PLANT == T001L.WERKS
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001L.MANDT
  • P_SUBCONTRG3RDPTYDOCSMNTR.STORAGELOCATION == T001L.LGORT
Subcontractor
  • Subcontractor
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.SUBCONTRACTOR == LFA1.LIFNR
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == LFA1.MANDT
Third-Party Supplier
  • Third-Party Supplier
  • Client
  • P_SUBCONTRG3RDPTYDOCSMNTR.SUPPLIER == LFA1.LIFNR
  • P_SUBCONTRG3RDPTYDOCSMNTR.MANDT == LFA1.MANDT