I_ProfitabilityAnalysisDoc

Profitability Analysis Document | view: IFIPROFANADOC | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LD_CMP, FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Currency Key (ControllingObjectCurrency):
AmountInObjectCurrency Value in CO Object Currency
💲 Controlling area currency (ControllingAreaCurrency):
ActualAmtInCtrlgAreaCrcy Total Value in Controlling Area Currency
FixedAmountInCtrlgAreaCrcy Fixed Value in Controlling Area Currency
TotalPriceVarcInCtrlgAreaCrcy Total Price Variance in CO Area Currency
FixedPriceVarcInCtrlgAreaCrcy Fixed Price Variance in Controlling Area Currency
Column Name Description
📏 Unit of Measure (CostSourceUnit):
TotalQuantity Total Quantity
FixedQuantity Fixed quantity
📏 Unit of entry (EntryUnit):
TotalQuantityInEntryUnit Total quantity entered
EnteredFixedQuantity Fixed quantity entered
📏 Additional Unit of Measure 1 (AdditionalQuantity1Unit):
AdditionalQuantity1 Additional Quantity 1
📏 Additional Unit of Measure 2 (AdditionalQuantity2Unit):
AdditionalQuantity2 Additional Quantity 2
📏 Additional Unit of Measure 3 (AdditionalQuantity3Unit):
AdditionalQuantity3 Additional Quantity 3
Column Name Description
SettlementReferenceDate Reference Date for Settlement
DocumentDate Journal Entry Date
PostingDate Posting Date
CreationDate Creation Date
CreationTime Creation Time
Column Name Description
ControllingValueType Value Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
QuantityCompletion Quantity Completion Show values
FinancialAccountType Account Type Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectDebitType Debit Type Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
AllocPriceDetnStrategy Strategy for Determining an Allocation Price Show values
OrderCategory Order category Show values
PartnerOrderCategory Partner Order Category Show values
BudgetPlanningLedger Ledger for Controlling Objects Show values
Column Name Description Domain name
ControllingDocument Document Number CO_BELNR
ControllingDocumentItem Posting Row BUZEI
FiscalPeriod Fiscal Period POPER
DocumentItemText Item Text TEXT50
ReferenceDocumentItem Reference Document Line Item NUMC6
OperativeVersionLineItem Posting Row in Operative Version BUZEI
OffsettingAccount Offsetting Account GKONT
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
Personnel Personnel Number PERNR
CtrlgAreaCurrencyAmountClass Amount Class for Value in Controlling Area Currency NUMC2
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
PartnerCostElement Cost element of partner KSTAR
GrantID Grant GM_GRANT_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
RefAccountingDocumentItem Journal Entry Posting View Item BUZEI
AccountingDocumentItemRef Accounting Document Line Item Number POSNR_ACC
OriginalReferenceDocument Object key AWKEY
AccountAssignment Account Assignment ACCAS
CostCenter Cost Center KOSTL
CostCtrActivityType Activity Type LSTAR
OrderID Order ID AUFNR
WBSElementInternalID WBS Element PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
SDDocument Sales and Distribution Document Number VBELN
SalesDocumentItem Sales Document Item POSNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PartnerWBSElement Partner WBS Element PS_POSID
PartnerProject Partner Project PS_PSPID
FiscalYear Fiscal Year GJAHR
SalesOrderItem Sales Order Item POSNR
Industry Industry key BRSCH
SalesDistrict Sales District BZIRK
SalesOffice Sales office VKBUR
SalesEmployee Sales Employee PERNR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Additional Unit of Measure 1
  • Additional Unit of Measure 1
  • Client
  • I_PROFITABILITYANALYSISDOC.ADDITIONALQUANTITY1UNIT == T006.MSEHI
  • I_PROFITABILITYANALYSISDOC.MANDT == T006.MANDT
Additional Unit of Measure 2
  • Additional Unit of Measure 2
  • Client
  • I_PROFITABILITYANALYSISDOC.ADDITIONALQUANTITY2UNIT == T006.MSEHI
  • I_PROFITABILITYANALYSISDOC.MANDT == T006.MANDT
Additional Unit of Measure 3
  • Additional Unit of Measure 3
  • Client
  • I_PROFITABILITYANALYSISDOC.ADDITIONALQUANTITY3UNIT == T006.MSEHI
  • I_PROFITABILITYANALYSISDOC.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • I_PROFITABILITYANALYSISDOC.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PROFITABILITYANALYSISDOC.MANDT == TVFK.MANDT
Budget Period
  • ?
  • Fund
  • Budget Period
  • Client
  • I_PROFITABILITYANALYSISDOC.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • I_PROFITABILITYANALYSISDOC.FUND == FMFUNDBPD.FINCODE
  • I_PROFITABILITYANALYSISDOC.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PROFITABILITYANALYSISDOC.MANDT == FMFUNDBPD.MANDT
Business Area
  • Business Area
  • Client
  • I_PROFITABILITYANALYSISDOC.BUSINESSAREA == TGSB.GSBER
  • I_PROFITABILITYANALYSISDOC.MANDT == TGSB.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_PROFITABILITYANALYSISDOC.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • I_PROFITABILITYANALYSISDOC.MANDT == FINSC_BTTYPE.MANDT
Company Code
  • Company Code
  • Client
  • I_PROFITABILITYANALYSISDOC.COMPANYCODE == T001.BUKRS
  • I_PROFITABILITYANALYSISDOC.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROFITABILITYANALYSISDOC.MANDT == TKA01.MANDT
Controlling area currency
  • Controlling area currency
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_PROFITABILITYANALYSISDOC.MANDT == TCURC.MANDT
Cost Analysis Resource
  • Controlling Area
  • Cost Analysis Resource
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == CSKR.KOKRS
  • I_PROFITABILITYANALYSISDOC.COSTANALYSISRESOURCE == CSKR.RESRC
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CSKR.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CSKR.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_PROFITABILITYANALYSISDOC.COMPANYCODE == SKB1.BUKRS
  • I_PROFITABILITYANALYSISDOC.COSTELEMENT == SKB1.SAKNR
  • I_PROFITABILITYANALYSISDOC.MANDT == SKB1.MANDT
Cost Object
  • Cost Object
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.COSTOBJECT == CKPH.KSTRG
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CKPH.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CKPH.MANDT
Unit of Measure
  • Client
  • Unit of Measure
  • I_PROFITABILITYANALYSISDOC.MANDT == T006.MANDT
  • I_PROFITABILITYANALYSISDOC.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • I_PROFITABILITYANALYSISDOC.CUSTOMER == KNA1.KUNNR
  • I_PROFITABILITYANALYSISDOC.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_PROFITABILITYANALYSISDOC.CUSTOMERGROUP == T151.KDGRP
  • I_PROFITABILITYANALYSISDOC.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_PROFITABILITYANALYSISDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PROFITABILITYANALYSISDOC.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_PROFITABILITYANALYSISDOC.DIVISION == TSPA.SPART
  • I_PROFITABILITYANALYSISDOC.MANDT == TSPA.MANDT
Unit of entry
  • Client
  • Unit of entry
  • I_PROFITABILITYANALYSISDOC.MANDT == T006.MANDT
  • I_PROFITABILITYANALYSISDOC.ENTRYUNIT == T006.MSEHI
Functional Area
  • Functional Area
  • Client
  • I_PROFITABILITYANALYSISDOC.FUNCTIONALAREA == TFKB.FKBER
  • I_PROFITABILITYANALYSISDOC.MANDT == TFKB.MANDT
Fund
  • ?
  • Fund
  • Client
  • I_PROFITABILITYANALYSISDOC.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • I_PROFITABILITYANALYSISDOC.FUND == FMFINCODE.FINCODE
  • I_PROFITABILITYANALYSISDOC.MANDT == FMFINCODE.MANDT
Logical System I_PROFITABILITYANALYSISDOC.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Material Number
  • Client
  • I_PROFITABILITYANALYSISDOC.MATERIAL == MARA.MATNR
  • I_PROFITABILITYANALYSISDOC.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_PROFITABILITYANALYSISDOC.MATERIALGROUP == T023.MATKL
  • I_PROFITABILITYANALYSISDOC.MANDT == T023.MANDT
Operating concern
  • Operating concern
  • Client
  • I_PROFITABILITYANALYSISDOC.OPERATINGCONCERN == TKEB.ERKRS
  • I_PROFITABILITYANALYSISDOC.MANDT == TKEB.MANDT
FM: Partner Budget Period
  • ?
  • Partner Fund
  • Client
  • FM: Partner Budget Period
  • I_PROFITABILITYANALYSISDOC.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • I_PROFITABILITYANALYSISDOC.PARTNERFUND == FMFUNDBPD.FINCODE
  • I_PROFITABILITYANALYSISDOC.MANDT == FMFUNDBPD.MANDT
  • I_PROFITABILITYANALYSISDOC.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Partner Business Area
  • Client
  • Partner Business Area
  • I_PROFITABILITYANALYSISDOC.MANDT == TGSB.MANDT
  • I_PROFITABILITYANALYSISDOC.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PROFITABILITYANALYSISDOC.PARTNERCOMPANY == T880.RCOMP
  • I_PROFITABILITYANALYSISDOC.MANDT == T880.MANDT
Company Code of Partner
  • Company Code of Partner
  • Client
  • I_PROFITABILITYANALYSISDOC.PARTNERCOMPANYCODE == T001.BUKRS
  • I_PROFITABILITYANALYSISDOC.MANDT == T001.MANDT
Partner Cost Center
  • Controlling Area
  • Partner Cost Center
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == CSKS.KOKRS
  • I_PROFITABILITYANALYSISDOC.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • Controlling Area
  • Partner Cost Center Activity Type
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == CSLA.KOKRS
  • I_PROFITABILITYANALYSISDOC.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CSLA.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CSLA.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_PROFITABILITYANALYSISDOC.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_PROFITABILITYANALYSISDOC.MANDT == TFKB.MANDT
Partner Fund
  • ?
  • Partner Fund
  • Client
  • I_PROFITABILITYANALYSISDOC.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • I_PROFITABILITYANALYSISDOC.PARTNERFUND == FMFINCODE.FINCODE
  • I_PROFITABILITYANALYSISDOC.MANDT == FMFINCODE.MANDT
Partner Logical System I_PROFITABILITYANALYSISDOC.PARTNERLOGICALSYSTEM == TBDLS.LOGSYS
Partner Order
  • Partner Order
  • Client
  • I_PROFITABILITYANALYSISDOC.PARTNERORDER == AUFK.AUFNR
  • I_PROFITABILITYANALYSISDOC.MANDT == AUFK.MANDT
Partner Profit Center
  • Controlling Area
  • Partner Profit Center
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROFITABILITYANALYSISDOC.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_PROFITABILITYANALYSISDOC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_PROFITABILITYANALYSISDOC.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • I_PROFITABILITYANALYSISDOC.PLANT == T001W.WERKS
  • I_PROFITABILITYANALYSISDOC.MANDT == T001W.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PROFITABILITYANALYSISDOC.PRODUCT == MARA.MATNR
  • I_PROFITABILITYANALYSISDOC.MANDT == MARA.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • I_PROFITABILITYANALYSISDOC.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROFITABILITYANALYSISDOC.PROFITCENTER == CEPC.PRCTR
  • I_PROFITABILITYANALYSISDOC.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROFITABILITYANALYSISDOC.MANDT == CEPC.MANDT
Logical System of Reference Document I_PROFITABILITYANALYSISDOC.REFERENCEDOCUMENTLOGICALSYSTEM == TBDLS.LOGSYS
Reference Document Type I_PROFITABILITYANALYSISDOC.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Sales Organization
  • Client
  • I_PROFITABILITYANALYSISDOC.SALESORGANIZATION == TVKO.VKORG
  • I_PROFITABILITYANALYSISDOC.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PROFITABILITYANALYSISDOC.MANDT == FAGL_SEGM.MANDT
  • I_PROFITABILITYANALYSISDOC.SEGMENT == FAGL_SEGM.SEGMENT
Transaction Currency
  • Client
  • Transaction Currency
  • I_PROFITABILITYANALYSISDOC.MANDT == TCURC.MANDT
  • I_PROFITABILITYANALYSISDOC.TRANSACTIONCURRENCY == TCURC.WAERS