I_MargAnlysProdAndSrvcCube

Product and Service Margins - Cube | view: IPROSRVMARGIN | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, PROJ, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy FK Financial Statement Version
SemanticTag FK Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
BilledRevenueAmtInCoCodeCrcy Actual Revenue
RecognizableCostAmtInCCCrcy Actual Cost
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedCOGSAmtInCCCrcy Recognized COS
RecognizedMarginAmtInCCCrcy Recognized Margin
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
COGSAdjustmentAmtInCCCrcy COS Adjustment
DeferredCOGSAmtInCCCrcy Deferred COS
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedRevenueAmtInCCCrcy Accrued Revenue
AccruedCOGSAmtInCCCrcy Accrued COS
ImminentLossRsrvAmtInCCCrcy Reserves for Imminent Loss
SalesDeductReserveAmtInCCCrcy Reserves for Anticipated Sales Deductions
UnrlzdCostsReserveAmtInCCCrcy Reserves for Unrealized Costs
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
PersonnelNumber Personnel Number PERNR
WBSElement WBS Element FIS_WBS_NO_CONV
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.BASEUNIT == T006.MSEHI
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T006.MANDT
Billable Control
  • Billable Control
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.BILLABLECONTROL == TBMOT.BEMOT
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TBMOT.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == KNA1.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T004.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.COMPANYCODE == T001.BUKRS
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TKA01.MANDT
Customer Number
  • Customer Number
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.CUSTOMER == KNA1.KUNNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T151.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TVTW.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.EQUIPMENT == EQUI.EQUNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == EQUI.MANDT
Functional Area
  • Client
  • Functional Area
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TFKB.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.COMPANYCODE == SKB1.BUKRS
  • I_MARGANLYSPRODANDSRVCCUBE.GLACCOUNT == SKB1.SAKNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Material Number
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.MATERIAL == MARA.MATNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == MARA.MANDT
Division
  • Client
  • Division
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TSPA.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_MARGANLYSPRODANDSRVCCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_MARGANLYSPRODANDSRVCCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == CSLA.MANDT
Plant
  • Client
  • Plant
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T001W.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.PLANT == T001W.WERKS
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • I_MARGANLYSPRODANDSRVCCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_MARGANLYSPRODANDSRVCCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == CEPC.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.PROFITCENTER == CEPC.PRCTR
Provider Contract
  • Provider Contract
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.PROVIDERCONTRACT == DFKK_VT_H.VTKEY
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == DFKK_VT_H.MANDT
Provider Contract Item
  • Provider Contract
  • Client
  • Provider Contract Item
  • I_MARGANLYSPRODANDSRVCCUBE.PROVIDERCONTRACT == DFKK_VT_I.VTKEY
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == DFKK_VT_I.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.PROVIDERCONTRACTITEM == DFKK_VT_I.VTPOS
Sales Organization
  • Client
  • Sales Organization
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == TVKO.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SALESORGANIZATION == TVKO.VKORG
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Service Contract ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • Service Contract Item ID
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Client
  • Service Contract Item ID
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Contract Type
  • Service Contract Type
  • Client
Service Document ID
  • Service Document Item ID
  • Client
  • Service Document Type
  • Service Document ID
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Item ID
  • Service Document Item ID
  • Client
  • Service Document Type
  • Service Document ID
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_MARGANLYSPRODANDSRVCCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Client
  • Service Document Type
Ship-to Party
  • Client
  • Ship-to Party
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == KNA1.MANDT
  • I_MARGANLYSPRODANDSRVCCUBE.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Product Sold
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.SOLDPRODUCT == MARA.MATNR
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_MARGANLYSPRODANDSRVCCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_MARGANLYSPRODANDSRVCCUBE.MANDT == T023.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client