C_PurOrdRefDocIR

Reference Documents for PO Creation - Inforecord Items | view: CPURORDREFDOCIR | Extraction: Not supported | Component: Purchase Orders
Tables used: MARAT023T023TMAKTT134T001WT024EINAEINELFA1T006A
Column Name Description
PurchasingInfoRecord FK Number of purchasing info record
PurchasingOrganization FK Purchasing organization
PurchasingInfoRecordCategory Purchasing info record category
Plant FK Plant
Column Name Description
💲 Currency Key (Currency):
PurchaseOrderNetPriceAmount Net Price in Purchasing Info Record
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty Standard Purchase Order Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate Price Valid Until
DeliveryDate null
PerformancePeriodStartDate null
PerformancePeriodEndDate null
Column Name Description
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
IsDeleted Purch. info: Purch. organization data flagged for deletion Show values
Column Name Description Domain name
PurchaseOrder null
PurchaseOrderItem null
AccountAssignmentNumber null
PlantName Plant Name TEXT30
PurchasingDocumentCategory null
IsAdvancedPurchaseOrder null
PurchasingDocumentDeletionCode null
StorageLocation null
MaterialName Material Description TEXT40
MaterialType Material type MTART
MaterialGroup Material Group MATKL
MaterialGroupName Product Group Description TEXT20
SupplierName Name of Supplier TEXT80
PurchasingDocumentType null
PurchasingDocumentSubtype null
PurchasingDocumentItemText Short Text for Purchasing Info Record TEXT40
PurchaseOrderNetPriceQuantity Price unit DEC5
PurchaseOrderPriceUnitName Unit of Measurement Text (Maximum 30 Characters) TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
CompanyCode null
CompanyCodeName null
PurchasingDocumentCondition null
PricingProcedure null
ContractConsumptionInPct null
GoodsReceiptIsExpected null
GoodsReceiptIsNonValuated null
InvoiceIsExpected null
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
PurchaseOrderItemCategory null
ServicePerformer null
ServicePerformerName null
ProductType null
RefPurchaseOutlineAgreement null
RefPurchOutlineAgrmtItem null
SupplierMaterialNumber Material Number Used by Supplier IDNEX
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
CustomerProjectName null
ProfitCenter null
WBSElementInternalID null
WBSElement null
FunctionalArea null
GLAccount null
GLAccountName null
CostCenter null
CostCenterName null
ControllingArea null
SalesOrder null
SalesOrderItem null
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_PURORDREFDOCIR.MANDT == TCURC.MANDT
  • C_PURORDREFDOCIR.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • Material Number
  • C_PURORDREFDOCIR.MANDT == MARA.MANDT
  • C_PURORDREFDOCIR.MATERIAL == MARA.MATNR
  • C_PURORDREFDOCIR.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • Material Number
  • C_PURORDREFDOCIR.MANDT == MARA.MANDT
  • C_PURORDREFDOCIR.MATERIAL == MARA.MATNR
  • C_PURORDREFDOCIR.MANUFACTURERMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_PURORDREFDOCIR.MANDT == T001W.MANDT
  • C_PURORDREFDOCIR.PLANT == T001W.WERKS
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • C_PURORDREFDOCIR.MANDT == T006.MANDT
  • C_PURORDREFDOCIR.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURORDREFDOCIR.MANDT == T006.MANDT
  • C_PURORDREFDOCIR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • Number of purchasing info record
  • C_PURORDREFDOCIR.MANDT == EINA.MANDT
  • C_PURORDREFDOCIR.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURORDREFDOCIR.PURCHASINGDOCUMENT == EINA.INFNR
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURORDREFDOCIR.MANDT == T024.MANDT
  • C_PURORDREFDOCIR.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • Number of purchasing info record
  • C_PURORDREFDOCIR.MANDT == EINA.MANDT
  • C_PURORDREFDOCIR.PURCHASINGINFORECORD == EINA.INFNR
  • C_PURORDREFDOCIR.PURCHASINGDOCUMENT == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURORDREFDOCIR.MANDT == T024E.MANDT
  • C_PURORDREFDOCIR.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • C_PURORDREFDOCIR.MANDT == LFA1.MANDT
  • C_PURORDREFDOCIR.SUPPLIER == LFA1.LIFNR