C_PurchaseOrderValue

Purchase Order Value | view: CMMPURORDVALUE | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, /CPD/D_PFP_PH, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, MMPUR_ANA_EKET, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, MARA, TKA01, T005, T005T, T001W, MARA, T023, T023T, MAKT, PROJ, T024, T024E, MMPUR_ANA_CONF, T000, LFA1, PRPS, PRPS, PROJ
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
Column Name Description
PurchaseOrderDate Purchasing Document Date
Column Name Description
PurgDocMigrtnIsCmpltdForAnlyts Indicator for Data Migration of Schedule Line Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
Column Name Description Domain name
PurgCatUUID Purchasing Category UUID /BOBF/CONF_KEY
Supplier Account Number of Supplier LIFNR
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
PostingMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
YearQuarter Year Quarter NUM5
PurchasingOrganization Purchasing organization EKORG
PurchasingOrganizationName Purchasing Organization Name TEXT20
CompanyCode Company Code BUKRS
PurchasingGroup Purchasing Group EKGRP
PurchasingGroupName Purchasing Group Name TEXT18
Material Material Number MATNR
MaterialName Product Description TEXT40
MaterialGroup Material Group MATKL
MaterialGroupName Product Group Description TEXT20
Plant Plant WERKS
PlantName Plant Name TEXT30
ProductTypeCode Product Type Group CHAR2
ProductType Product Type MTART
ServicePerformer Service Performer BU_PARTNER
PurchasingCategory Purchasing Category ID
PurgCatRelatedToMaterialGroup null
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
CustProjWorkPackageName Plan Item Description /CPD/PLAN_ITEM_NAME
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
NumberOfPurchaseOrders null
NmbrOfCmpltlyDlvrdPurOrdItms null
Master Data Relations Join Conditions
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • C_PURCHASEORDERVALUE.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURCHASEORDERVALUE.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURCHASEORDERVALUE.COSTCENTER == CSKS.KOSTL
  • C_PURCHASEORDERVALUE.MANDT == CSKS.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURCHASEORDERVALUE.COUNTRY == T005.LAND1
  • C_PURCHASEORDERVALUE.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURCHASEORDERVALUE.MANDT == T005.MANDT
Region (State, Province, County)
  • Supplier Country/Region
  • Supplier Country/Region
  • Region (State, Province, County)
  • Client
  • C_PURCHASEORDERVALUE.COUNTRY == T005S.LAND1
  • C_PURCHASEORDERVALUE.SUPPLIERCOUNTRY == T005S.LAND1
  • C_PURCHASEORDERVALUE.REGION == T005S.BLAND
  • C_PURCHASEORDERVALUE.MANDT == T005S.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURCHASEORDERVALUE.COUNTRY == T005.LAND1
  • C_PURCHASEORDERVALUE.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURCHASEORDERVALUE.MANDT == T005.MANDT