C_CntrlPurContrHierHdrTP

Central Purchase Contract Hierarchy | view: CPCHIERHDR | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EREVEKPO_DISTREKKOTVZBTT161TLFA1USR21
Column Name Description
CentralPurchaseContract Central Purchase Contract
Column Name Description
💲 Currency Key (Currency):
PurchaseContractTargetAmount Target Value for Header Area per Distribution
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
QuotationSubmissionDate Quotation Submission Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurgDocChangeRequestStatus Change Request Status Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
CntrlPurContrOvrlDistrStsTxt Distribution Status Show values
CntrlPurContrStatusCriticality Central Purchase Contract Validity Status Criticality Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
TargetValueIsRelevantForVers Boolean Variable (X = True, - = False, Space = Unknown) Show values
ValdtyEndDateIsRelevantForVers Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
ActivePurchasingDocument Active Purchasing Document EBELN
PurchasingDocumentVersion Version number in Purchasing
ChangeRequestNote Short Text for Fixed Values DDTEXT
PurgDocIsChgVers Checkbox
PurchasingDocVersionReasonText Reason Description for Version Change MMPUR_VERS_RSNTEXT
PurgContractIsInPreparation Boolean Variable (X = True, - = False, Space = Unknown)
CntrlPurContrIsHierRoot Boolean Variable (X = True, - = False, Space = Unknown)
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
PaymentTermsName Description of terms of payment TEXT30
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
CreatedByUser User of person who created a purchasing document USNAM
UserDescription User Description
IsCancelled Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
SupplierAddressID Address Number AD_ADDRNUM
SupplierQuotation Quotation Number ANGNR
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
PurchasingDocumentName Name of Purchasing Document TEXT40
LastChangeDateTime Change Time Stamp TZNTSTMPL
DocumentStatusName Short Text for Fixed Values
PurchasingDocumentStatus Short Text for Fixed Values
StatusCriticality 2 Byte Signed Integer INT2
ItemDistributionStatusName Short Text for Fixed Values
PurchasingDocumentStatusName Short Text for Fixed Values
CntrlPurContrValdtyStatusText Short Text for Fixed Values
CntrlPurContrValidityStatus null
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
AccWorkflowApprover User Name in User Master Record XUBNAME
AccWorkflowApproverFirstName Full Name of Approver TEXT80
ApprovalStatusName Short Text for Fixed Values
ApproverUser Actual Agent of Work Item SYCHAR12
CntrlPurContrFlxblDistrIsAllwd Boolean Variable (X = True, - = False, Space = Unknown)
ContractConsumptionInPct null
NoteTypeListText null
NmbrOfSubordCntrlPurContracts null
CntrlPurContrHierarchyMaterial Material of External System
CntrlPurContrHierMaterialGroup Material Group
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.COMPANYCODE == T001.BUKRS
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.CURRENCY == TCURC.WAERS
  • C_CNTRLPURCONTRHIERHDRTP.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.CURRENCY == TCURC.WAERS
  • C_CNTRLPURCONTRHIERHDRTP.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.INCOTERMSVERSION == TINCV.INCOV
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.INVOICINGPARTY == LFA1.LIFNR
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == LFA1.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CNTRLPURCONTRHIERHDRTP.PURCHASECONTRACTTYPE == T161.BSART
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T161.MANDT
Reason for change
  • Reason for change
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.PURCHASINGDOCVERSIONREASONCODE == T16CC.RSCOD
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T16CC.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.PURCHASINGGROUP == T024.EKGRP
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.PURCHASINGORGANIZATION == T024E.EKORG
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.RELEASECODE == T16FB.FRGKE
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == T16FB.MANDT
Supplier
  • Supplier
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.SUPPLIER == LFA1.LIFNR
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == LFA1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • C_CNTRLPURCONTRHIERHDRTP.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_CNTRLPURCONTRHIERHDRTP.MANDT == LFA1.MANDT