I_CentralContractItemSel

Central Purchase Contract Item Selection | view: ICCTRITEMSEL | Extraction: Not supported | Component: Central RFQ/Central Quotations
Tables used: EREV, EKPO_DISTR, EKKO, EKPO, LFA1
Column Name Description
CentralPurchaseContract Central Purchase Contract
CentralPurchaseContractItem Central Purchase Contract Item
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Outline Agreement in Document Currency
ContractNetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingProcessingStatus Purchasing document processing state Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
PurgDocChangeRequestStatus Change Request Status Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PurgDocItemRenegotiationStatus Renegotiation Status Show values
Column Name Description Domain name
FormattedPurchasingDocItem null
PurchasingDocumentName Name of Purchasing Document TEXT40
Material Material Number MATNR
PurchaseContractItemText Short Text TEXT40
PurchasingDocumentItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
ProductTypeCode Product Type Group CHAR2
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
PurchasingContractDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_CENTRALCONTRACTITEMSEL.COMPANYCODE == T001.BUKRS
  • I_CENTRALCONTRACTITEMSEL.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_CENTRALCONTRACTITEMSEL.DOCUMENTCURRENCY == TCURC.WAERS
  • I_CENTRALCONTRACTITEMSEL.MANDT == TCURC.MANDT
Material Group
  • Material Group
  • Client
  • I_CENTRALCONTRACTITEMSEL.MATERIALGROUP == T023.MATKL
  • I_CENTRALCONTRACTITEMSEL.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • I_CENTRALCONTRACTITEMSEL.ORDERPRICEUNIT == T006.MSEHI
  • I_CENTRALCONTRACTITEMSEL.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_CENTRALCONTRACTITEMSEL.MANDT == T006.MANDT
  • I_CENTRALCONTRACTITEMSEL.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_CENTRALCONTRACTITEMSEL.MANDT == T001W.MANDT
  • I_CENTRALCONTRACTITEMSEL.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_CENTRALCONTRACTITEMSEL.PURCHASECONTRACTTYPE == T161.BSART
  • I_CENTRALCONTRACTITEMSEL.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_CENTRALCONTRACTITEMSEL.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • I_CENTRALCONTRACTITEMSEL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • I_CENTRALCONTRACTITEMSEL.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_CENTRALCONTRACTITEMSEL.PURCHASINGGROUP == T024.EKGRP
  • I_CENTRALCONTRACTITEMSEL.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_CENTRALCONTRACTITEMSEL.PURCHASINGORGANIZATION == T024E.EKORG
  • I_CENTRALCONTRACTITEMSEL.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • I_CENTRALCONTRACTITEMSEL.SUPPLIER == LFA1.LIFNR
  • I_CENTRALCONTRACTITEMSEL.MANDT == LFA1.MANDT