P_PurchaseContractExpiry1

Purchase Contract Expiry1 | view: PMMPURCONEXP1 | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
Column Name Description
💲 Display Currency (DisplayCurrency):
ContractNetPriceAmount Net Price in Purchasing Document (in Document Currency)
TargetAmount null
PurchaseContractTargetAmount null
ReleaseOrderItemNetAmount null
Column Name Description
TargetQuantity Target Quantity
Column Name Description
CreationDate Creation Date of Purchasing Document
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type 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_PURCHASECONTRACTEXPIRY1.MANDT == T001.MANDT
  • P_PURCHASECONTRACTEXPIRY1.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PURCHASECONTRACTEXPIRY1.MANDT == TCURC.MANDT
  • P_PURCHASECONTRACTEXPIRY1.DOCUMENTCURRENCY == TCURC.WAERS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • P_PURCHASECONTRACTEXPIRY1.PURCHASECONTRACTTYPE == T161.BSART
  • P_PURCHASECONTRACTEXPIRY1.MANDT == T161.MANDT
  • P_PURCHASECONTRACTEXPIRY1.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_PURCHASECONTRACTEXPIRY1.MANDT == T163.MANDT
  • P_PURCHASECONTRACTEXPIRY1.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASECONTRACTEXPIRY1.MANDT == T024.MANDT
  • P_PURCHASECONTRACTEXPIRY1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASECONTRACTEXPIRY1.MANDT == T024E.MANDT
  • P_PURCHASECONTRACTEXPIRY1.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PURCHASECONTRACTEXPIRY1.MANDT == LFA1.MANDT
  • P_PURCHASECONTRACTEXPIRY1.SUPPLIER == LFA1.LIFNR