C_UnusedPurchaseContractQ

Unused Purchase Contract | view: CMMUNUSEDPC | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseContract Purchasing Contract Header
Column Name Description
💲 Display Currency (DisplayCurrency):
ReleaseOrderItemNetAmount Release Net Amount
PurchaseContractTargetAmount Target Amount
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
CalendarDate Calendar Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
NumberOfContracts Number of Unused Contracts
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_UNUSEDPURCHASECONTRACTQ.COMPANYCODE == T001.BUKRS
  • C_UNUSEDPURCHASECONTRACTQ.MANDT == T001.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • C_UNUSEDPURCHASECONTRACTQ.PURCHASECONTRACTTYPE == T161.BSART
  • C_UNUSEDPURCHASECONTRACTQ.MANDT == T161.MANDT
  • C_UNUSEDPURCHASECONTRACTQ.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • C_UNUSEDPURCHASECONTRACTQ.PURCHASINGGROUP == T024.EKGRP
  • C_UNUSEDPURCHASECONTRACTQ.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_UNUSEDPURCHASECONTRACTQ.PURCHASINGORGANIZATION == T024E.EKORG
  • C_UNUSEDPURCHASECONTRACTQ.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_UNUSEDPURCHASECONTRACTQ.SUPPLIER == LFA1.LIFNR
  • C_UNUSEDPURCHASECONTRACTQ.MANDT == LFA1.MANDT