C_PurchaseContractLeakage

Purchase Contract Leakage | view: CMMCONTRLEAKAGE | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKKO, EKPO, TKA01, T005, T005T, MARA, T023, T023T, MAKT, T001W, T161, T161T, T024, T024E, T161, T162, T163, T163Y, 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):
LeakageAmountInDisplayCrcy Leakage Amount in Display Currency
PurchaseOrderNetAmount Purchase Order Net Amount
NonLeakageAmtInDisplayCrcy Non-Leakage Amount
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurgDocItemCategoryName Text for Item Category TEXT20
PurchaseContract Purchasing Contract Header EBELN
MaterialName Material Description TEXT40
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
MaterialGroupName Product Group Description TEXT20
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PlantName Plant Name TEXT30
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
ContractLeakageRatio null
ContractLeakageRateInPercent null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T001.MANDT
  • C_PURCHASECONTRACTLEAKAGE.COMPANYCODE == T001.BUKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • C_PURCHASECONTRACTLEAKAGE.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURCHASECONTRACTLEAKAGE.COSTCENTER == CSKS.KOSTL
  • C_PURCHASECONTRACTLEAKAGE.MANDT == CSKS.MANDT
  • C_PURCHASECONTRACTLEAKAGE.[column in domain "DATBI"] == CSKS.DATBI
Material Number
  • Material Number
  • Client
  • C_PURCHASECONTRACTLEAKAGE.MATERIAL == MARA.MATNR
  • C_PURCHASECONTRACTLEAKAGE.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T023.MANDT
  • C_PURCHASECONTRACTLEAKAGE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T001W.MANDT
  • C_PURCHASECONTRACTLEAKAGE.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T163.MANDT
  • C_PURCHASECONTRACTLEAKAGE.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • C_PURCHASECONTRACTLEAKAGE.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T161.MANDT
  • C_PURCHASECONTRACTLEAKAGE.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T024.MANDT
  • C_PURCHASECONTRACTLEAKAGE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASECONTRACTLEAKAGE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASECONTRACTLEAKAGE.SUPPLIER == LFA1.LIFNR
  • C_PURCHASECONTRACTLEAKAGE.MANDT == LFA1.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURCHASECONTRACTLEAKAGE.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURCHASECONTRACTLEAKAGE.MANDT == T005.MANDT