C_Subcontrg3rdPtyDocsMntr

3rd Party Purchasing Docs | view: CTHDPTYDOCMNTR | TRAN | Extraction: Not supported | Component: Purchase Orders
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
TargetAmount Target Value for Header Area per Distribution
ReleasedAmount Released Value
GoodsReceiptAmountInCoCodeCrcy Delivered Value
StillToBeDeliveredValue Value to be Delivered
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
ReleasedQuantity null
GoodsReceiptQty Delivered Quantity
StillToBeDeliveredQuantity Quantity to be Delivered
OpenPurchaseOrderQuantity Next Delivery Quantity
📏 Purchase Order Unit of Measure (BaseUnit):
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
SupplierIsSubcontractor Subcontracting Supplier Show values
Column Name Description Domain name
FormattedPurchasingDocItem Purchasing Document Item
PurchasingDocumentItemText Item Description
Assembly Assembly MATNR
AssemblyName Material Description TEXT40
PlantName Plant Name TEXT30
SubcontractorName Name of Supplier TEXT80
MaterialGroupName Material Group Description TEXT20
AcctAssignmentCategoryName Account Assignment Category 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
PurchasingCategory Purchasing Category ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
RequirementTracking Requirement Tracking Number CHAR10
PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurchasingDocumentType Order Type (Purchasing)
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
Status null
StatusDescription null
PurchaseOrderTypeName Short Description of Purchasing Document Type TEXT20
DeliveryStatus Next Delivery Status
DeliveryStatusDescription Next Delivery Status
ShippingStatus Next Shipping Status
ShippingStatusText Next Shipping Status
MaterialName Material Description TEXT40
SupplierName Name of Supplier TEXT80
DeliveryDateCriticality null
DifferenceInDays null
MRPAreaText MRP Area Text BERTX
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T163K.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T006.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_SUBCONTRG3RDPTYDOCSMNTR.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.DOCUMENTCURRENCY == TCURC.WAERS
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == TCURC.MANDT
Component
  • Client
  • Component
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == MARA.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T023.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.MATERIALGROUP == T023.MATKL
MRP Area
  • MRP Area
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.MRPAREA == MDLV.BERID
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == MDLV.MANDT
Plant
  • Plant
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.PLANT == T001W.WERKS
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T006.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_SUBCONTRG3RDPTYDOCSMNTR.BASEUNIT == T006.MSEHI
Purchase Order Type
  • Purchasing Document Category
  • Purchase Order Type
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASEORDERTYPE == T161.BSART
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T024.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T024E.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Plant
  • Client
  • Storage Location
  • C_SUBCONTRG3RDPTYDOCSMNTR.PLANT == T001L.WERKS
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == T001L.MANDT
  • C_SUBCONTRG3RDPTYDOCSMNTR.STORAGELOCATION == T001L.LGORT
Subcontractor
  • Subcontractor
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.SUBCONTRACTOR == LFA1.LIFNR
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == LFA1.MANDT
Third-Party Supplier
  • Third-Party Supplier
  • Client
  • C_SUBCONTRG3RDPTYDOCSMNTR.SUPPLIER == LFA1.LIFNR
  • C_SUBCONTRG3RDPTYDOCSMNTR.MANDT == LFA1.MANDT