I_RevenueVariance

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
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
GLAccountHierarchy Financial Statement Version
Column Name Description
Interval1LineItemRevenue Revenue Amount in Company Code Currency
Interval2LineItemRevenue Revenue Amount in Company Code Currency
Column Name Description
Interval1LineItemVolume null
Interval2LineItemVolume null
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
PlanningCategory Plan Category FCOM_CATEGORY
BaseUnitName Unit of Measurement Text (Maximum 10 Characters) TEXT10
LedgerName Ledger Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
Country Country/Region Key LAND1
CountryName Country/Region Name TEXT50
SalesOrganization Sales Organization VKORG
SalesOrganizationName Sales Organization Description TEXT20
Division Division SPART
DivisionName Division Description TEXT20
DistributionChannel Distribution Channel VTWEG
DistributionChannelName Distribution Channel Description TEXT20
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
Material Sold Material MATNR
MaterialName Material Description TEXT40
MaterialGroup Product Sold Group MATKL
MaterialGroupName Product Group Description TEXT20
CustomerGroup Customer Group KDGRP
GLAccount G/L Account SAKNR
ProfitCenter Profit Center PRCTR
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
CustomerSupplierIndustry Customer Supplier Industry BRSCH
Interval1Type null
Interval2Type null
AuthorizationGroup Authorization Group BRGRU
AccountingDocumentType Journal Entry Type BLART
AssetClass Asset Class ANLKL
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
ControllingArea Controlling Area CACCD
CostCenter Cost Center KOSTL
Plant Plant WERKS
ValuationArea Valuation area BWKEY
OrganizationDivision Division SPART
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
Supplier Supplier LIFNR
SalesDocument Sales Document VBELN
OrderID Order ID AUFNR
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • I_REVENUEVARIANCE.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_REVENUEVARIANCE.MANDT == T077D.MANDT