C_PurchaseContractLeakage1

Purchase Contract Leakage Cube | view: CMMCONTRLEAKAGE1 | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKKO, EKPO, TKA01, T001W, T161, T162, T000, LFA1
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Display Currency (DisplayCurrency):
PurchaseOrderNetAmount Purchase Order Net Amount
LeakageAmountInDisplayCrcy Leakage Amount in Display Currency
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchaseContract Purchasing Contract Header EBELN
PurchaseContractItem Item Number of Purchasing Contract EBELP
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
ProfitCenter Profit Center PRCTR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
CreatedByUser User of person who created a purchasing document USNAM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T001.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == TKA01.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Controlling Area
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == CSKS.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURCHASECONTRACTLEAKAGE1.COSTCENTER == CSKS.KOSTL
  • C_PURCHASECONTRACTLEAKAGE1.CONTROLLINGAREA == CSKS.KOKRS
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == SKA1.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PURCHASECONTRACTLEAKAGE1.GLACCOUNT == SKA1.SAKNR
Material Number
  • Client
  • Material Number
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == MARA.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T023.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T001W.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T163.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Type
  • Purchasing Document Category
  • Client
  • Purchase Order Type
  • C_PURCHASECONTRACTLEAKAGE1.PURCHASEORDERCATEGORY == T161.BSTYP
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T161.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T024.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T024E.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • C_PURCHASECONTRACTLEAKAGE1.SUPPLIER == LFA1.LIFNR
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == LFA1.MANDT
Supplier Country/Region
  • Client
  • Supplier Country/Region
  • C_PURCHASECONTRACTLEAKAGE1.MANDT == T005.MANDT
  • C_PURCHASECONTRACTLEAKAGE1.SUPPLIERCOUNTRY == T005.LAND1