C_GrossMarginKPI

Gross Margin KPI | view: CGROSSMARGKPI | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
Tables used: SCAL_TT_DATE, VBAK, PRTE, ACDOCA, ACDOCP, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, T004, T001, TKA02, SKA1, FINSC_LEDGER, PROJ, HRRP_FSV_DIR, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger Ledger in General Ledger Accounting
SourceLedger Source Ledger
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy Financial Statement Version
SemanticTag Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
FinancialPlanningReqTransSqnc Request Transaction Sequence Number
FinancialPlanningDataPacket Data packet number
FinancialPlanningEntryItem Data record number
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
ActlRecognizedRevnAmtInCCCrcy Actual Recognized Revenue Amount in Company Code Currency
ActualCostAmtInCCCrcy null
ActlRecognizedMargAmtInCCCrcy Actual Recognized Margin Amount in Company Code Currency
ActlSlsDeductionAmtInCCCrcy null
ActlBilledRevenueAmtInCCCrcy Actual Billed Revenue Amount In Company Code Currency
PrdtdRecognizedRevnAmtInCCCrcy Actual Recognized Revenue Amount in Company Code Currency
PrdtdCostAmtInCompanyCodeCrcy null
PrdtdRecognizedMargAmtInCCCrcy Actual Recognized Margin Amount in Company Code Currency
PrdtdSlsDeductionAmtInCCCrcy null
PrdtdBilledRevenueAmtInCCCrcy Actual Billed Revenue Amount In Company Code Currency
RecognizedRevnAmtInCCCrcy Recognized Revenue
CostAmountInCompanyCodeCrcy null
RecognizedMarginAmtInCCCrcy Recognized Margin
SalesDeductionAmtInCoCodeCrcy null
BilledRevenueAmtInCoCodeCrcy Actual Revenue
PlnRecognizedRevnAmtInCCCrcy Plan Recognized Revenue Amount in Company Code Currency
PlnCostAmtInCompanyCodeCrcy null
PlnRecognizedMargAmtInCCCrcy Plan Recognized Margin Amount in Company Code Currency
PlnSlsDeductionAmtInCCCrcy null
PlnBilledRevenueAmtInCCCrcy Plan Billed Revenue Amount In Company Code Currency
💲 Global Currency (GlobalCurrency):
ActlRecgdRevenueAmtInGlobCrcy Actual Recognized Revenue Amount In Global Currency
ActlCostOfGdsSoldAmtInGlobCrcy null
ActlRecgdMargAmtInGlobCrcy Recognized Margin
ActlSlsDeductionAmtInGlobCrcy null
ActlBilledRevenueAmtInGlobCrcy Actual Billed Revenue Amt In Global Currency
PrdtdRecgdRevenueAmtInGlobCrcy Actual Recognized Revenue Amount In Global Currency
PrdtdCostAmtInGlobCrcy null
PrdtdRecgdMargAmtInGlobCrcy Recognized Margin
PrdtdSlsDeductionAmtInGlobCrcy null
PrdtdBilledRevnAmtInGlobCrcy Actual Billed Revenue Amt In Global Currency
RecognizedRevnAmtInGlobCrcy Recognized Revenue
CostOfGoodsSoldAmtInGlobCrcy null
RecognizedMarginAmount Recognized Margin
SalesDeductionAmountInGlobCrcy null
BilledRevenueAmtInGlobCrcy Actual Revenue
PlnRecgdRevenueAmtInGlobCrcy Planned Recognized Revenue Amount In Global Currency
PlnCostOfGdsSoldAmtInGlobCrcy null
PlnRecognizedMargAmtInGlobCrcy Plan Recognized Margin Amount in Company Code Currency
PlnSlsDeductionAmtInGlobCrcy null
PlnBilledRevenueAmtInGlobCrcy Plan Billed Revenue Amount In Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
DocumentDate Journal Entry Date
FiscalPeriodStartDate Start Date of Fiscal Period
FiscalPeriodEndDate End Date of Fiscal Period
PostingDate Posting Date
CreationDate Creation Date
ClearingDate Clearing Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
JrnlEntryItemObsoleteReason Reason Item is Obsolete Show values
Column Name Description Domain name
ProfitCenter Profit Center PRCTR
GLAccount G/L Account SAKNR
SalesOrder Sales Order VBELN
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SoldProduct Product Sold MATNR
ProductGroup Product Sold Group MATKL
CustomerGroup Customer Group KDGRP
Customer Customer Number KUNNR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod null
SalesDistrict Sales District BZIRK
Segment Segment for Segmental Reporting FB_SEGMENT
SalesOrderItem Sales Order Item POSNR
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
BusinessArea Business Area GSBER
CostCenter Cost Center KOSTL
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
ControllingArea Controlling Area CACCD
ChartOfAccounts Chart of Accounts KTOPL
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialTransactionType Financial Transaction Type RMVCT
AssignmentReference Assignment Reference ZUONR
PostingKey Posting Key BSCHL
AccountingDocCreatedByUser User that created the journal entry
Plant Plant WERKS
SpecialGLCode Special G/L Indicator UMSKZ
ClearingAccountingDocument Clearing Journal Entry BELNR
BillingDocumentType Billing Type FKART
CustomerSupplierIndustry Customer Supplier Industry BRSCH
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SourceReferenceDocumentType Source Document Type AWTYP
SourceReferenceDocument Source Document Reference Document Number AWREF
OperatingConcern Operating Concern ERKRS
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Journal Entry Type BLART
ReferenceDocumentType Reference Document Type AWTYP
PlanningCategory Revenue Variance Planning Category FCOM_CATEGORY
AmountFulfillmentPercent null
IsSimulation null
MktgKPIToleranceRangeLow null
MktgKPIDeviationRangeLow null
Master Data Relations Join Conditions
Division in order header
  • ?
  • Division
  • ?
  • Client
  • C_GROSSMARGINKPI.[column in domain "VTWEG"] == TVTA.VTWEG
  • C_GROSSMARGINKPI.DIVISION == TVTA.SPART
  • C_GROSSMARGINKPI.[column in domain "VKORG"] == TVTA.VKORG
  • C_GROSSMARGINKPI.MANDT == TVTA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_GROSSMARGINKPI.ORDERTYPE == TVAK.AUART
  • C_GROSSMARGINKPI.MANDT == TVAK.MANDT