C_ContractMaintainItem

Purchase Contract Maintain Item | view: CCTRMAINTAINITEM | Extraction: Not supported | Component: Contract

Tables used: SCAL_TT_DATE, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, QTY_CON_PAI, EKKO, EKPO, T163K, T163I, T001, TKA02, TCURT, TINCT, TVZBT, T001W, T161, T161T, T024, T024E, T162, A019, KONP, A016, TINCVT, USREFUS, T163Y, LFA1, USR21, KONM, KONW

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (12)
Other (37)
🔗 Relations (27)

Column Name	Description
PurchaseContractItem	Item Number of Purchasing Contract
PurchaseContract FK	Purchasing Contract Header

Column Name	Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
TargetAmount	Target Value for Outline Agreement in Document Currency

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity	Target Quantity
PurgDocReleaseOrderQuantity	Standard release order quantity

Column Name	Description
PurgDocPriceDate	Date of Price Determination
TaxDeterminationDate	Date for Determining Tax Rates
ContractExpiryPredictedDate	Predicted Contract Expiry Date
ValidityEndDate	End of Validity Period

Column Name	Description
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
PartialInvoiceDistribution	Partial invoice indicator	Show values
EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)	Show values
PriceIsToBePrinted	Price Printout	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
IsInfoRecordUpdated	Indicator: Update Info Record	Show values
PurgDocEstimatedPrice	Indicator: Estimated Price	Show values
StockType	Stock Type	Show values
IsOrderAcknRqd	Order Acknowledgment Requirement	Show values
GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated	Show values
IsStatisticalItem	Item is statistical	Show values

Column Name	Description	Domain name
PurgConfigurableItemNumber	Hierarchy Number	EXLIN
PurchaseContractItemForEdit	Item Number of Purchasing Contract	EBELP
PurchaseContractItemText	Short Text	TEXT40
ManualDeliveryAddressID	Manual address number in purchasing document item	AD_ADDRNUM
NetPriceQuantity	Price Unit	DEC5
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
PurgDocItemCategoryName	Text for Item Category	TEXT20
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
SupplierMaterialNumber	Material Number Used by Supplier	IDNEX
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance	PRZ21
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance	PRZ21
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
IncotermsLocation1	Incoterms Location 1	INCO_L
PurgDocOrderAcknNumber	Order Acknowledgment Number	TEXT20
IsInfoAtRegistration	Info at Registration
NoDaysReminder1	Number of Days for First Reminder/Expediter	MAHNT
NoDaysReminder2	Number of Days for Second Reminder/Expediter	MAHNT
NoDaysReminder3	Number of Days for Third Reminder/Expediter	MAHNT
PlannedDeliveryDurationInDays	Planned Delivery Time in Days	DEC3
TaxCountry	Tax Reporting Country/Region	LAND1
RequirementTracking	Requirement Tracking Number	CHAR10
ServicePerformer	Service Performer	BU_PARTNER
ProductType	Product Type Group	CHAR2
FormattedPurchaseContractItem	null
PurchasingContractDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
NumberOfDays	Number of Days in Year or Month	INT4
HierarchyNode	Hierarchy node	RSCHAVLEXT
HierarchyParentNode	Hierarchy node	RSCHAVLEXT
HierarchyLevel	null
HierarchyNodeSubTreeSize	null
HierarchyDrillState	null
HierarchyNodeOrdinalNumber	null
IsOutline	Checkbox
AcctAssignmentCategoryName	Account Assignment Category Description	TEXT20

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_CONTRACTMAINTAINITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_CONTRACTMAINTAINITEM.MANDT == T163K.MANDT`
Company Code Company Code Client	`C_CONTRACTMAINTAINITEM.COMPANYCODE == T001.BUKRS` `C_CONTRACTMAINTAINITEM.MANDT == T001.MANDT`
Customer Client Customer	`C_CONTRACTMAINTAINITEM.MANDT == KNA1.MANDT` `C_CONTRACTMAINTAINITEM.CUSTOMER == KNA1.KUNNR`
Currency Key Currency Key Client	`C_CONTRACTMAINTAINITEM.DOCUMENTCURRENCY == TCURC.WAERS` `C_CONTRACTMAINTAINITEM.MANDT == TCURC.MANDT`
Incoterms (Part 1) Incoterms (Part 1) Client	`C_CONTRACTMAINTAINITEM.INCOTERMSCLASSIFICATION == TINC.INCO1` `C_CONTRACTMAINTAINITEM.MANDT == TINC.MANDT`
Material Number Client Material Number	`C_CONTRACTMAINTAINITEM.MANDT == MARA.MANDT` `C_CONTRACTMAINTAINITEM.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`C_CONTRACTMAINTAINITEM.MATERIALGROUP == T023.MATKL` `C_CONTRACTMAINTAINITEM.MANDT == T023.MANDT`
Material type Client Material type	`C_CONTRACTMAINTAINITEM.MANDT == T134.MANDT` `C_CONTRACTMAINTAINITEM.MATERIALTYPE == T134.MTART`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_CONTRACTMAINTAINITEM.ORDERPRICEUNIT == T006.MSEHI` `C_CONTRACTMAINTAINITEM.ORDPRCUNITTOORDERUNITNMRTRUOM == T006.MSEHI` `C_CONTRACTMAINTAINITEM.MANDT == T006.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure Purchase Order Unit of Measure	`C_CONTRACTMAINTAINITEM.MANDT == T006.MANDT` `C_CONTRACTMAINTAINITEM.ORDERQUANTITYUNIT == T006.MSEHI` `C_CONTRACTMAINTAINITEM.ORDPRCUNITTOORDERUNITDNMNTRUOM == T006.MSEHI`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure Purchase Order Unit of Measure	`C_CONTRACTMAINTAINITEM.MANDT == T006.MANDT` `C_CONTRACTMAINTAINITEM.ORDERQUANTITYUNIT == T006.MSEHI` `C_CONTRACTMAINTAINITEM.ORDPRCUNITTOORDERUNITDNMNTRUOM == T006.MSEHI`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_CONTRACTMAINTAINITEM.ORDERPRICEUNIT == T006.MSEHI` `C_CONTRACTMAINTAINITEM.ORDPRCUNITTOORDERUNITNMRTRUOM == T006.MSEHI` `C_CONTRACTMAINTAINITEM.MANDT == T006.MANDT`
Plant Client Plant	`C_CONTRACTMAINTAINITEM.MANDT == T001W.MANDT` `C_CONTRACTMAINTAINITEM.PLANT == T001W.WERKS`
Purchasing Document Type ? Purchasing Document Type Purchasing Document Type Client	`C_CONTRACTMAINTAINITEM.[column in domain "BSTYP"] == T161.BSTYP` `C_CONTRACTMAINTAINITEM.PURCHASECONTRACTTYPE == T161.BSART` `C_CONTRACTMAINTAINITEM.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_CONTRACTMAINTAINITEM.MANDT == T161.MANDT`
Item category in purchasing document Client Item category in purchasing document	`C_CONTRACTMAINTAINITEM.MANDT == T163.MANDT` `C_CONTRACTMAINTAINITEM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Document Type ? Purchasing Document Type Purchasing Document Type Client	`C_CONTRACTMAINTAINITEM.[column in domain "BSTYP"] == T161.BSTYP` `C_CONTRACTMAINTAINITEM.PURCHASECONTRACTTYPE == T161.BSART` `C_CONTRACTMAINTAINITEM.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_CONTRACTMAINTAINITEM.MANDT == T161.MANDT`
Purchasing organization Client Purchasing organization	`C_CONTRACTMAINTAINITEM.MANDT == T024E.MANDT` `C_CONTRACTMAINTAINITEM.PURCHASINGORGANIZATION == T024E.EKORG`
Reference Delivery Address ? ? Reference Delivery Address Client	`C_CONTRACTMAINTAINITEM.[column in domain "AD_NATION"] == ADRC.NATION` `C_CONTRACTMAINTAINITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `C_CONTRACTMAINTAINITEM.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER` `C_CONTRACTMAINTAINITEM.MANDT == ADRC.CLIENT`
Shipping Instructions Shipping Instructions Client	`C_CONTRACTMAINTAINITEM.SHIPPINGINSTRUCTION == T027A.EVERS` `C_CONTRACTMAINTAINITEM.MANDT == T027A.MANDT`
Storage Location Client Storage Location Plant	`C_CONTRACTMAINTAINITEM.MANDT == T001L.MANDT` `C_CONTRACTMAINTAINITEM.STORAGELOCATION == T001L.LGORT` `C_CONTRACTMAINTAINITEM.PLANT == T001L.WERKS`
Supplier to be Supplied/Who is to Receive Delivery Supplier to be Supplied/Who is to Receive Delivery Client	`C_CONTRACTMAINTAINITEM.SUBCONTRACTOR == LFA1.LIFNR` `C_CONTRACTMAINTAINITEM.MANDT == LFA1.MANDT`
Confirmation Control Key Confirmation Control Key Client	`C_CONTRACTMAINTAINITEM.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE` `C_CONTRACTMAINTAINITEM.MANDT == T163L.MANDT`
Tax on sales/purchases code Client Tax on sales/purchases code ?	`C_CONTRACTMAINTAINITEM.MANDT == T007A.MANDT` `C_CONTRACTMAINTAINITEM.TAXCODE == T007A.MWSKZ` `C_CONTRACTMAINTAINITEM.[column in domain "KALSM_D"] == T007A.KALSM`
Volume unit Client Volume unit	`C_CONTRACTMAINTAINITEM.MANDT == T006.MANDT` `C_CONTRACTMAINTAINITEM.VOLUMEUNIT == T006.MSEHI`