P_UnusedPurCentralContract

Unused Central Purchase Contracts | view: PMMUNUSEDCNTLPC | Extraction: Not supported | Component: Reporting
Column Name Description
CentralPurchaseContract FK Central Purchase Contract
CentralPurchaseContractItem Central Purchase Contract Item
DistributionKey Distribution Number of Central Purchasing Document
Column Name Description
TargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
Column Name Description
ReleaseOrderItemOrderQuantity null
TargetQuantity Target Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
CreationDate Creation Date of Purchasing Document
ReleaseOrderDate null
ReleaseOrderItemLastChgDate null
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T001.MANDT
  • P_UNUSEDPURCENTRALCONTRACT.COMPANYCODE == T001.BUKRS
Material Number
  • Material Number
  • Client
  • P_UNUSEDPURCENTRALCONTRACT.MATERIAL == MARA.MATNR
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T023.MANDT
  • P_UNUSEDPURCENTRALCONTRACT.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T001W.MANDT
  • P_UNUSEDPURCENTRALCONTRACT.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_UNUSEDPURCENTRALCONTRACT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T161.MANDT
  • P_UNUSEDPURCENTRALCONTRACT.PURCHASECONTRACTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • P_UNUSEDPURCENTRALCONTRACT.PURCHASINGGROUP == T024.EKGRP
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_UNUSEDPURCENTRALCONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • P_UNUSEDPURCENTRALCONTRACT.MANDT == LFA1.MANDT
  • P_UNUSEDPURCENTRALCONTRACT.SUPPLIER == LFA1.LIFNR