C_ContractItemAcctMntr

Purchase Contract Items by Account Assignment | view: CCTRITEMACCTMONI | TRAN | Extraction: Not supported | Component: Contract

Tables used: VBAP, AFKO, AFKO, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, VBAK, VBAP, VBKD, VEDA, PRTE, EKKO, EKPO, T163K, T163I, FMBUDGETPDT, TGSBT, T001, TKA02, TKA01, CSKS, CSKS, CSKT, TCURC, TCURX, FMFINT, GMGRTEXTS, AUFK, MARA, T023, T023T, MAKT, AUFK, T001W, CEPC, CEPCT, PROJ, T161, T161T, T024, T024E, T163, T163Y, T16FB, T16FE, T000, T001L, LFA1, USR21, PRPS, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, SKAT, T004

🔑 Keys (3)
💰 Amounts (3)
∑ Quantities (4)
📅 Dates (5)
☰ Categorical (1)
Other (47)
🔗 Relations (29)

Column Name	Description
AccountAssignment	Sequential Number of Account Assignment
PurchaseContract FK	Purchasing Document Number
PurchaseContractItem FK	Item Number of Purchasing Document

Column Name	Description
💲 Document Currency (DocumentCurrency):
PurgDocNetAmount	Target Amount
ContractNetPriceAmount	Net Price
PurchaseContractTargetAmount	Target Value for Header Area per Distribution

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
OrderQuantity	null
Quantity	Account Assignment Quantity
TargetQuantity	Target Quantity
OpenTargetQuantity	null

Column Name	Description
ValidityEndDate	Date Validity Ends
ValidityStartDate	Date for Beginning of Validity
CreationDate	Creation Date of Purchasing Document
ReleaseOrderDate	Release Order Date
ValidityDate	null

Column Name	Description
PurchaseContractValidityStatus	Validity Status	Show values

Column Name	Description	Domain name
FormattedPurchaseContractItem	Formatted Purchase Contract Item
PurchaseContractItemText	Purchasing Document Item Text	TEXT40
DocumentTypeName	Purchasing Document Type Name	TEXT20
MaterialName	Material Description	TEXT40
SupplierName	Supplier Name	TEXT80
AcctAssignmentCategoryName	Account Assignment Category Description
MultipleAcctAssgmtDistrPercent	null
NetPriceQuantity	Price Unit	DEC5
CostCenterName	Cost Center Name	TEXT20
OrderDescription	Order Description
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingGroupName	Purchasing Group Name	TEXT18
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
FixedAssetDescription	Asset Description
PurContrValidityStatusName	Validity Status Name	DDTEXT
PlantName	Plant Name	TEXT30
PurgDocExternalItemCategory	Item Category in Purchasing Document	EPSTP
PurgDocItemCategoryName	Item Category Text	TEXT20
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Purchasing Category Name
PurgCatUUID	Purchasing Category UUID	/BOBF/CONF_KEY
StorageLocationName	Storage Location Name
MaterialGroupName	Material Group Description	TEXT20
ReleaseCodeName	Release Status	TEXT30
ControllingAreaName	Controlling Area Name	TEXT25
SalesOrderItem	Sales Document Item	POSNR
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItemText	Short text for sales order item	TEXT40
ProjectNetworkDescription	Description
BusinessAreaName	Business Area Description
GLAccountName	G/L Account Short Text
ProfitabilitySegment	null
ProfitCenter	Profit Center	PRCTR
ProfitCenterName	Description of Profit Center	TEXT20
GrantID	Grant	GM_GRANT_NBR
GrantName	Short Description of the Grant
FundsCenter	Funds Center	FISTL
BudgetPeriod	Budget Period	FM_BUDGET_PERIOD
BudgetPeriodName	Budget Period Name
NumberOfContractItems	Number of Contracts
Fund	Fund	BP_GEBER
FundName	Fund Name
PurchasingIsBlockedForSupplier	Boolean Variable (X = True, - = False, Space = Unknown)
PurgOrgCompanyCodeName	Name of Company Code or Company
CreatedByUser	User of person who created a purchasing document	USNAM
UserDescription	User Description

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_CONTRACTITEMACCTMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_CONTRACTITEMACCTMNTR.MANDT == T163K.MANDT`
Business Area Business Area Client	`C_CONTRACTITEMACCTMNTR.BUSINESSAREA == TGSB.GSBER` `C_CONTRACTITEMACCTMNTR.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`C_CONTRACTITEMACCTMNTR.CHARTOFACCOUNTS == T004.KTOPL` `C_CONTRACTITEMACCTMNTR.MANDT == T004.MANDT`
Commitment Item Creation Date of Purchasing Document Commitment Item ? Client	`C_CONTRACTITEMACCTMNTR.CREATIONDATE == FMFPO.DATBIS` `C_CONTRACTITEMACCTMNTR.COMMITMENTITEM == FMFPO.FIPOS` `C_CONTRACTITEMACCTMNTR.[column in domain "FIKRS"] == FMFPO.FIKRS` `C_CONTRACTITEMACCTMNTR.MANDT == FMFPO.MANDT`
Company Code Company Code Client	`C_CONTRACTITEMACCTMNTR.COMPANYCODE == T001.BUKRS` `C_CONTRACTITEMACCTMNTR.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_CONTRACTITEMACCTMNTR.CONTROLLINGAREA == TKA01.KOKRS` `C_CONTRACTITEMACCTMNTR.MANDT == TKA01.MANDT`
Cost Center Creation Date of Purchasing Document Controlling Area Cost Center Client	`C_CONTRACTITEMACCTMNTR.CREATIONDATE == CSKS.DATBI` `C_CONTRACTITEMACCTMNTR.CONTROLLINGAREA == CSKS.KOKRS` `C_CONTRACTITEMACCTMNTR.COSTCENTER == CSKS.KOSTL` `C_CONTRACTITEMACCTMNTR.MANDT == CSKS.MANDT`
Document Currency Display Currency Document Currency Client	`C_CONTRACTITEMACCTMNTR.DISPLAYCURRENCY == TCURC.WAERS` `C_CONTRACTITEMACCTMNTR.DOCUMENTCURRENCY == TCURC.WAERS` `C_CONTRACTITEMACCTMNTR.MANDT == TCURC.MANDT`
Fixed Asset Company Code Main Asset Number Fixed Asset Client	`C_CONTRACTITEMACCTMNTR.COMPANYCODE == ANLA.BUKRS` `C_CONTRACTITEMACCTMNTR.MASTERFIXEDASSET == ANLA.ANLN1` `C_CONTRACTITEMACCTMNTR.FIXEDASSET == ANLA.ANLN2` `C_CONTRACTITEMACCTMNTR.MANDT == ANLA.MANDT`
G/L Account Number Chart of Accounts Client G/L Account Number	`C_CONTRACTITEMACCTMNTR.CHARTOFACCOUNTS == SKA1.KTOPL` `C_CONTRACTITEMACCTMNTR.MANDT == SKA1.MANDT` `C_CONTRACTITEMACCTMNTR.GLACCOUNT == SKA1.SAKNR`
Material Number Material Number Client	`C_CONTRACTITEMACCTMNTR.MATERIAL == MARA.MATNR` `C_CONTRACTITEMACCTMNTR.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_CONTRACTITEMACCTMNTR.MATERIALGROUP == T023.MATKL` `C_CONTRACTITEMACCTMNTR.MANDT == T023.MANDT`
Order Number Order Number Client	`C_CONTRACTITEMACCTMNTR.ORDERID == AUFK.AUFNR` `C_CONTRACTITEMACCTMNTR.MANDT == AUFK.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_CONTRACTITEMACCTMNTR.ORDERPRICEUNIT == T006.MSEHI` `C_CONTRACTITEMACCTMNTR.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_CONTRACTITEMACCTMNTR.ORDERQUANTITYUNIT == T006.MSEHI` `C_CONTRACTITEMACCTMNTR.MANDT == T006.MANDT`
Plant Plant Client	`C_CONTRACTITEMACCTMNTR.PLANT == T001W.WERKS` `C_CONTRACTITEMACCTMNTR.MANDT == T001W.MANDT`
Network Number for Account Assignment Client Network Number for Account Assignment	`C_CONTRACTITEMACCTMNTR.MANDT == AUFK.MANDT` `C_CONTRACTITEMACCTMNTR.PROJECTNETWORK == AUFK.AUFNR`
Purchasing Document Type Purchasing Document Type ? Client	`C_CONTRACTITEMACCTMNTR.PURCHASECONTRACTTYPE == T161.BSART` `C_CONTRACTITEMACCTMNTR.[column in domain "BSTYP"] == T161.BSTYP` `C_CONTRACTITEMACCTMNTR.MANDT == T161.MANDT`
Item category in purchasing document Item category in purchasing document Client	`C_CONTRACTITEMACCTMNTR.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP` `C_CONTRACTITEMACCTMNTR.MANDT == T163.MANDT`
Purchasing Group Purchasing Group Client	`C_CONTRACTITEMACCTMNTR.PURCHASINGGROUP == T024.EKGRP` `C_CONTRACTITEMACCTMNTR.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_CONTRACTITEMACCTMNTR.PURCHASINGINFORECORD == EINA.INFNR` `C_CONTRACTITEMACCTMNTR.MANDT == EINA.MANDT`
Purchasing Organization Purchasing Organization Client	`C_CONTRACTITEMACCTMNTR.PURCHASINGORGANIZATION == T024E.EKORG` `C_CONTRACTITEMACCTMNTR.MANDT == T024E.MANDT`
Storage Location Storage Location Plant Client	`C_CONTRACTITEMACCTMNTR.STORAGELOCATION == T001L.LGORT` `C_CONTRACTITEMACCTMNTR.PLANT == T001L.WERKS` `C_CONTRACTITEMACCTMNTR.MANDT == T001L.MANDT`
Supplier Supplier Client	`C_CONTRACTITEMACCTMNTR.SUPPLIER == LFA1.LIFNR` `C_CONTRACTITEMACCTMNTR.MANDT == LFA1.MANDT`
Tax on sales/purchases code Tax on sales/purchases code ? Client	`C_CONTRACTITEMACCTMNTR.TAXCODE == T007A.MWSKZ` `C_CONTRACTITEMACCTMNTR.[column in domain "KALSM_D"] == T007A.KALSM` `C_CONTRACTITEMACCTMNTR.MANDT == T007A.MANDT`