C_ContractItemAcctMntr

Purchase Contract Items by Account Assignment | view: CCTRITEMACCTMONI | TRAN | Extraction: Not supported | Component: Contract
Tables used: VBAP, AFKO, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, VBAK, VBKD, VEDA, PRTE, T163K, T163I, FMBUDGETPDT, TGSBT, T001, TKA02, TKA01, CSKS, CSKT, TCURC, TCURX, FMFINT, GMGRTEXTS, AUFK, MARA, T023, T023T, MAKT, T001W, CEPC, CEPCT, PROJ, T161, T161T, T024, T024E, T163, T163Y, T16FB, T16FE, T000, T001L, LFA1, USR21, PRPS, ANLA, FAAT_MD, FAAT_MD_ROOT, SKAT, T004
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