C_GLIncgOrdPrdtvAnalysis

Column Name Description
Ledger FK 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
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
InvertedAmountInGlobalCurrency Amount in Global Currency
RevenueInGlobalCurrency Recognized Revenue
RecognizedMarginAmount Recognized Margin
SalesDeductionAmountInGlobCrcy null
RecognizableRevnAmtInGlobCrcy Actual Revenue
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
InvertedAmtInFuncnlCurrency Amount in Functional Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
InvertedAmtInCoCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
InvertedAmtInTransCrcy Amount in Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
InvertedAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
InvertedAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
InvertedAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
InvertedAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
InvertedAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
InvertedAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
InvertedAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
InvertedAmtInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
FixedQuantity Fixed Quantity
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
DocumentDate Journal Entry Date
FiscalPeriodStartDate Start Date of Fiscal Period
PostingDate Posting Date
CreationDate Creation Date
ClearingDate Clearing Date
Column Name Description
JrnlEntrDerivedFiscalQuarter Journal Entry Derived Fiscal Quarter Show values
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
LedgerName Ledger Name TEXT30
GLAccountHierarchyName Hierarchy description TEXT50
CompanyCodeName Name of Company Code or Company TEXT25
SemanticTagName Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
GLAccount G/L Account SAKNR
GLAccountName G/L Account Name TEXT20
AlternativeGLAccountName Name of Semantic Tag of Hierarchy Node
SalesOrder Sales Order VBELN
SalesOrganization Sales Organization VKORG
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannel Distribution Channel VTWEG
DistributionChannelName Distribution Channel Description TEXT20
SoldProduct Product Sold MATNR
SoldProductName Product Description TEXT40
ProductGroup Product Sold Group MATKL
ProductGroupName Product Sold Group Description TEXT20
CustomerGroup Customer Group KDGRP
CustomerGroupName Name
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
JrnlEntrDerivedFiscalYear Journal Entry Derived Fiscal Year GJAHR
JrnlEntrDerivedFiscalPeriod Journal Entry Derived Fiscal Period POPER
JrnlEntrDerivdFiscalYearPeriod Journal Entry Derived Fiscal Year Period NUMC07
SalesDistrict Sales District BZIRK
SalesDistrictName Name of the district TEXT20
Segment Segment for Segmental Reporting FB_SEGMENT
SegmentName Segment Name TEXT50
SalesOrderItem Sales Order Item NUM06
SalesOrderItemText Short text for sales order item TEXT40
DivisionName Division Description TEXT20
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
BusinessTransactionTypeName Business Transaction Type Description
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
ControllingArea Controlling Area CACCD
ControllingAreaName Controlling Area Name TEXT25
AccountingDocumentCategoryName Journal Entry Category Name DDTEXT
ChartOfAccounts Chart of Accounts KTOPL
ChartOfAccountsName Chart of Accounts Description
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialTransactionType Financial Transaction Type RMVCT
BaseUnitName Unit of Measurement Text (Maximum 10 Characters) TEXT10
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 Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
OperatingConcern Operating Concern ERKRS
AccountingDocumentItem Journal Entry Posting View Item BUZEI
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Journal Entry Type BLART
AccountingDocumentTypeName Document Type Name TEXT20
ReferenceDocumentType Reference Document Type AWTYP
NumberOfSalesOrders null
SalesOrderDiscountRate null
SalesOrderGrossMargin null
SalesOrderType Sales Order Selection
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ValuationArea Valuation area BWKEY
Supplier Supplier LIFNR
SalesDocument Sales Document VBELN
FixedAsset Asset Subnumber ANLN2
MasterFixedAsset Fixed Asset ANLN1
OrderID Order ID AUFNR
OrganizationDivision Division SPART
AssetClass Asset Class ANLKL
Master Data Relations Join Conditions
Division in order header
  • Division
  • ?
  • Client
  • ?
  • C_GLINCGORDPRDTVANALYSIS.DIVISION == TVTA.SPART
  • C_GLINCGORDPRDTVANALYSIS.[column in domain "VKORG"] == TVTA.VKORG
  • C_GLINCGORDPRDTVANALYSIS.MANDT == TVTA.MANDT
  • C_GLINCGORDPRDTVANALYSIS.[column in domain "VTWEG"] == TVTA.VTWEG
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Order type in order header
  • Sales Document Type
  • Client
  • C_GLINCGORDPRDTVANALYSIS.ORDERTYPE == TVAK.AUART
  • C_GLINCGORDPRDTVANALYSIS.MANDT == TVAK.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client