C_PurchaseContractExpiry

Purchase Contract Expiry | view: CMMPURCONEXP | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract FK Purchasing Contract Header
Column Name Description
💲 Display Currency (DisplayCurrency):
ReleaseOrderItemNetAmount Release Net Amount
TargetAmount Target Amount
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
Column Name Description Domain name
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierName Name of Supplier TEXT80
PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurchasingDocumentSubtype Control indicator for purchasing document type
PurchasingDocumentSubTypeName Purchasing Document Category Name DDTEXT
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
CreatedByUser User of person who created a purchasing document USNAM
NmbrOfExpiringContracts Number Of Expiring Contracts
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURCHASECONTRACTEXPIRY.COMPANYCODE == T001.BUKRS
  • C_PURCHASECONTRACTEXPIRY.MANDT == T001.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_PURCHASECONTRACTEXPIRY.PURCHASECONTRACTTYPE == T161.BSART
  • C_PURCHASECONTRACTEXPIRY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_PURCHASECONTRACTEXPIRY.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASECONTRACTEXPIRY.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASECONTRACTEXPIRY.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_PURCHASECONTRACTEXPIRY.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASECONTRACTEXPIRY.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASECONTRACTEXPIRY.SUPPLIER == LFA1.LIFNR
  • C_PURCHASECONTRACTEXPIRY.MANDT == LFA1.MANDT