C_Purchaseorderitemacctmntr

Purchase Order Items by Account Assignment | view: CPOMNTRACCASSIGN | Extraction: Not supported | Component: Fiori FXU Purchasing MM-FIO-PUR
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
AccountAssignmentCategory FK Account Assignment Category
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Currency Key (DocumentCurrency):
PurgDocNetAmount Target Amount
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
PurchaseOrderItemNetAmount Net Order Value in PO Currency
StillToBeDeliveredValue null
StillToInvoiceValue null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
Quantity Quantity
OrderQuantity Purchase Order Quantity
StillToBeDeliveredQuantity null
StillToInvoiceQuantity null
Column Name Description
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
ScheduleLineDeliveryDate null
PurchasingDocumentOrderDate Purchase Order Date
ValidityDate null
Column Name Description
Column Name Description Domain name
AcctAssignmentCategoryName Account Assignment Category Description
FormattedPurchaseOrderItem null
CompanyCodeName Name of Company Code or Company
MultipleAcctAssgmtDistrPercent null
Plant Plant WERKS
PlantName Plant Name TEXT30
CostCenterName Cost Center Name
WBSElement Work Breakdown Structure Element (WBS Element)
WBSDescription WBS Element Name
GLAccountName G/L Account Short Text
SupplyingPlantName Plant Name
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category
PurgCatUUID Purchasing Category UUID /BOBF/CONF_KEY
MasterFixedAssetDescription Asset Main Number Text
SupplierName Name of Supplier
PurchasingDocumentTypeName Short Description of Purchasing Document Type
PurchasingOrganizationName Purchasing Organization Name
PurchasingGroupName Purchasing Group Name
ProjectNetworkDescription Description
SalesOrder Sales and Distribution Document Number
PurgDocExternalItemCategory Item Category in Purchasing Document EPSTP
PurgDocItemCategoryName Text for Item Category
MaterialName Material Description
MaterialGroupName Product Group Description
StorageLocationName Storage Location Name
PurchasingDocumentStatus null
PurchasingDocumentStatusName Purchasing Document Status Name
TaxCode Tax on sales/purchases code MWSKZ
ControllingAreaName Controlling Area Name TEXT25
SalesOrderItem Sales Document Item POSNR
FixedAssetDescription Asset Description
BusinessAreaName Business Area Description
ProfitCenter Profit Center
ProfitCenterName Description of Profit Center
ProfitabilitySegment null
GrantID Grant GM_GRANT_NBR
GrantName Short Description of the Grant
FundsCenter Funds Center
Fund Fund BP_GEBER
FundName Fund Name
BudgetPeriod Budget Period FM_BUDGET_PERIOD
BudgetPeriodName Budget Period Name
OrderDescription Order Description
NumberOfPurchaseOrderItems Number of Purchase Orders
RequirementTracking Requirement Tracking Number
PurchasingIsBlockedForSupplier Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingDocumentItemText Short Text
IsCompletelyDelivered "Delivery Completed" Indicator
IsFinallyInvoiced Final Invoice Indicator
IsCompleted Checkbox
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T163K.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Business Area
  • Client
  • Business Area
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == TGSB.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T004.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.CHARTOFACCOUNTS == T004.KTOPL
Commitment Item
  • ?
  • ?
  • Client
  • Commitment Item
  • C_PURCHASEORDERITEMACCTMNTR.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
  • C_PURCHASEORDERITEMACCTMNTR.[column in domain "FIKRS"] == FMFPO.FIKRS
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == FMFPO.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.COMMITMENTITEM == FMFPO.FIPOS
Company Code
  • Client
  • Company Code
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T001.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == TKA01.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • C_PURCHASEORDERITEMACCTMNTR.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == CSKS.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.CONTROLLINGAREA == CSKS.KOKRS
  • C_PURCHASEORDERITEMACCTMNTR.COSTCENTER == CSKS.KOSTL
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == TCURC.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.DISPLAYCURRENCY == TCURC.WAERS
  • C_PURCHASEORDERITEMACCTMNTR.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == TCURC.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.DISPLAYCURRENCY == TCURC.WAERS
  • C_PURCHASEORDERITEMACCTMNTR.DOCUMENTCURRENCY == TCURC.WAERS
Asset Subnumber
  • Asset Subnumber
  • Client
  • Main Asset Number
  • Company Code
  • C_PURCHASEORDERITEMACCTMNTR.FIXEDASSET == ANLA.ANLN2
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == ANLA.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.MASTERFIXEDASSET == ANLA.ANLN1
  • C_PURCHASEORDERITEMACCTMNTR.COMPANYCODE == ANLA.BUKRS
G/L Account Number
  • Client
  • G/L Account Number
  • Chart of Accounts
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == SKA1.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.GLACCOUNT == SKA1.SAKNR
  • C_PURCHASEORDERITEMACCTMNTR.CHARTOFACCOUNTS == SKA1.KTOPL
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == MARA.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T023.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.MATERIALGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == AUFK.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.ORDERID == AUFK.AUFNR
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == AUFK.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PROJECTNETWORK == AUFK.AUFNR
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T163.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T006.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Client
  • Purchase Order Type
  • ?
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T161.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURCHASEORDERITEMACCTMNTR.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T024.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == EINA.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T024E.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Storage Location
  • Client
  • Plant
  • C_PURCHASEORDERITEMACCTMNTR.STORAGELOCATION == T001L.LGORT
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T001L.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == LFA1.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.SUPPLIER == LFA1.LIFNR
Supplier Subrange
  • Client
  • Supplier Subrange
  • ?
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == WYT1.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_PURCHASEORDERITEMACCTMNTR.[column in domain "LIFNR"] == WYT1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURCHASEORDERITEMACCTMNTR.MANDT == T001W.MANDT
  • C_PURCHASEORDERITEMACCTMNTR.SUPPLYINGPLANT == T001W.WERKS