P_PurchaseContractleakage1

Purchase Contract Leakage 1 | view: PMMCONTRLEAKAGE1 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKKO, EKPO
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
Column Name Description
OrderQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
CalendarYear Calendar Year NUM4
YearQuarter Year Quarter NUM5
YearMonth Year Month NUM6
YearWeek Year Week NUM6
PurchaseOrderNetAmount null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.COMPANYCODE == T001.BUKRS
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.MATERIAL == MARA.MATNR
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.MATERIALGROUP == T023.MATKL
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.ORDERPRICEUNIT == T006.MSEHI
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.PLANT == T001W.WERKS
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T001W.MANDT
Profit Center
  • Purchase Order Date
  • Profit Center
  • ?
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.PURCHASEORDERDATE == CEPC.DATBI
  • P_PURCHASECONTRACTLEAKAGE1.PROFITCENTER == CEPC.PRCTR
  • P_PURCHASECONTRACTLEAKAGE1.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == CEPC.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.PURCHASEORDERTYPE == T161.BSART
  • P_PURCHASECONTRACTLEAKAGE1.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASECONTRACTLEAKAGE1.SUPPLIER == LFA1.LIFNR
  • P_PURCHASECONTRACTLEAKAGE1.MANDT == LFA1.MANDT