I_GLIncgOrdPrdtvAnalysis

Pred. Analysis based on Inc. Orders | view: IFGLIOPRANLS | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
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
💲 Transaction Currency (TransactionCurrency):
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedRevnAmtInGlobCrcy Recognized Revenue
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
RevenueInGlobalCurrency Revenue Amount in Global Currency
RecognizedCOGSAmtInCCCrcy Recognized COS
CostOfGoodsSoldAmtInGlobCrcy Cost of Goods Sold - Total
RecognizedMarginAmtInCCCrcy Recognized Margin
RecognizedMarginAmount Recognized Margin
SalesDeductionAmountInGlobCrcy Sales Deduction
SalesDeductionAmtInCoCodeCrcy Sales Deduction
RecognizableRevnAmtInGlobCrcy Actual Revenue
AmountInCompanyCodeCurrency Amount in Company Code Currency
InvertedAmtInCoCodeCurrency Amount in Company Code Currency
InvertedAmountInGlobalCurrency Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
AmountInFunctionalCurrency Amount in Functional Currency
InvertedAmtInFuncnlCurrency Amount in Functional Currency
AmountInTransactionCurrency Amount in Transaction Currency
InvertedAmtInTransCrcy Amount in Transaction Currency
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
InvertedAmtInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
InvertedAmtInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
InvertedAmtInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
InvertedAmtInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
InvertedAmtInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
InvertedAmtInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
InvertedAmtInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
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 FK Valid To Date
DocumentDate Journal Entry Date
PostingDate Posting Date
CreationDate Creation Date
ClearingDate Clearing Date
FiscalPeriodStartDate Start Date of Fiscal Period
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
JrnlEntrDerivedFiscalQuarter Journal Entry Derived Fiscal Quarter Show values
JrnlEntryItemObsoleteReason Reason Item is Obsolete Show values
Column Name Description Domain name
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item NUM06
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LedgerFiscalYear Ledger Fiscal Year GJAHR
AssignmentReference Assignment Reference ZUONR
ClearingAccountingDocument Clearing Journal Entry BELNR
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
AccountingDocumentItem Journal Entry Posting View Item BUZEI
TransactionTypeDetermination Transaction Key CHAR3
JrnlEntrDerivedFiscalYear Journal Entry Derived Fiscal Year GJAHR
JrnlEntrDerivedFiscalPeriod Journal Entry Derived Fiscal Period POPER
JrnlEntrDerivdFiscalYearPeriod Journal Entry Derived Fiscal Year Period NUMC07
NumberOfSalesOrders null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_GLINCGORDPRDTVANALYSIS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T003.MANDT
Asset Class
  • Client
  • Asset Class
  • I_GLINCGORDPRDTVANALYSIS.MANDT == ANKA.MANDT
  • I_GLINCGORDPRDTVANALYSIS.ASSETCLASS == ANKA.ANLKL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T006.MANDT
  • I_GLINCGORDPRDTVANALYSIS.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • I_GLINCGORDPRDTVANALYSIS.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TVFK.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • I_GLINCGORDPRDTVANALYSIS.MANDT == KNA1.MANDT
  • I_GLINCGORDPRDTVANALYSIS.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TGSB.MANDT
  • I_GLINCGORDPRDTVANALYSIS.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T004.MANDT
  • I_GLINCGORDPRDTVANALYSIS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T001.MANDT
  • I_GLINCGORDPRDTVANALYSIS.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_GLINCGORDPRDTVANALYSIS.CONTROLLINGAREA == TKA01.KOKRS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • I_GLINCGORDPRDTVANALYSIS.CONTROLLINGAREA == CSKS.KOKRS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == CSKS.MANDT
  • I_GLINCGORDPRDTVANALYSIS.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLINCGORDPRDTVANALYSIS.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • I_GLINCGORDPRDTVANALYSIS.MANDT == KNA1.MANDT
  • I_GLINCGORDPRDTVANALYSIS.CUSTOMER == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • I_GLINCGORDPRDTVANALYSIS.CUSTOMERGROUP == T151.KDGRP
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_GLINCGORDPRDTVANALYSIS.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T016.MANDT
  • I_GLINCGORDPRDTVANALYSIS.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TVTW.MANDT
  • I_GLINCGORDPRDTVANALYSIS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division in order header
  • Client
  • Division
  • Division
  • Sales Organization
  • Distribution Channel
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TVTA.MANDT
  • I_GLINCGORDPRDTVANALYSIS.DIVISION == TVTA.SPART
  • I_GLINCGORDPRDTVANALYSIS.ORGANIZATIONDIVISION == TVTA.SPART
  • I_GLINCGORDPRDTVANALYSIS.SALESORGANIZATION == TVTA.VKORG
  • I_GLINCGORDPRDTVANALYSIS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T856.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_GLINCGORDPRDTVANALYSIS.FISCALYEARVARIANT == T009.PERIV
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • ?
  • Client
  • Asset Subnumber
  • I_GLINCGORDPRDTVANALYSIS.MASTERFIXEDASSET == ANLA.ANLN1
  • I_GLINCGORDPRDTVANALYSIS.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == ANLA.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Currency
  • Client
  • Functional Currency
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_GLINCGORDPRDTVANALYSIS.GLACCOUNT == SKB1.SAKNR
  • I_GLINCGORDPRDTVANALYSIS.MANDT == SKB1.MANDT
  • I_GLINCGORDPRDTVANALYSIS.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Product Sold Group
  • Product Sold Group
  • Client
  • I_GLINCGORDPRDTVANALYSIS.MATERIALGROUP == T023.MATKL
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T023.MANDT
Operating Concern
  • Operating Concern
  • Client
  • I_GLINCGORDPRDTVANALYSIS.OPERATINGCONCERN == TKEB.ERKRS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TKEB.MANDT
Order ID
  • Client
  • Order ID
  • I_GLINCGORDPRDTVANALYSIS.MANDT == AUFK.MANDT
  • I_GLINCGORDPRDTVANALYSIS.ORDERID == AUFK.AUFNR
Order type in order header
  • Client
  • Sales Document Type
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TVAK.MANDT
  • I_GLINCGORDPRDTVANALYSIS.ORDERTYPE == TVAK.AUART
Division
  • Client
  • Division
  • Division
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TSPA.MANDT
  • I_GLINCGORDPRDTVANALYSIS.DIVISION == TSPA.SPART
  • I_GLINCGORDPRDTVANALYSIS.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Plant
  • Client
  • I_GLINCGORDPRDTVANALYSIS.PLANT == T001W.WERKS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T001W.MANDT
Posting Key
  • Client
  • Posting Key
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TBSL.MANDT
  • I_GLINCGORDPRDTVANALYSIS.POSTINGKEY == TBSL.BSCHL
Profit Center
  • Profit Center
  • Controlling Area
  • Client
  • ?
  • I_GLINCGORDPRDTVANALYSIS.PROFITCENTER == CEPC.PRCTR
  • I_GLINCGORDPRDTVANALYSIS.CONTROLLINGAREA == CEPC.KOKRS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == CEPC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.[column in domain "DATBI"] == CEPC.DATBI
Reference Document Type I_GLINCGORDPRDTVANALYSIS.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • I_GLINCGORDPRDTVANALYSIS.SALESDISTRICT == T171.BZIRK
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TVKO.MANDT
  • I_GLINCGORDPRDTVANALYSIS.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GLINCGORDPRDTVANALYSIS.MANDT == FAGL_SEGM.MANDT
  • I_GLINCGORDPRDTVANALYSIS.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Service Document ID
  • Service Document Type
  • Client
  • Service Document Item ID
  • Service Document ID
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GLINCGORDPRDTVANALYSIS.MANDT == FCO_SRVDOC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Item ID
  • Service Document Type
  • Client
  • Service Document Item ID
  • Service Document ID
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GLINCGORDPRDTVANALYSIS.MANDT == FCO_SRVDOC.MANDT
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLINCGORDPRDTVANALYSIS.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Service Document Type
  • Client
Ship-to Party
  • Ship-to Party
  • Client
  • I_GLINCGORDPRDTVANALYSIS.SHIPTOPARTY == KNA1.KUNNR
  • I_GLINCGORDPRDTVANALYSIS.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_GLINCGORDPRDTVANALYSIS.SOLDMATERIAL == MARA.MATNR
  • I_GLINCGORDPRDTVANALYSIS.MANDT == MARA.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Document Type I_GLINCGORDPRDTVANALYSIS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • I_GLINCGORDPRDTVANALYSIS.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T074U.MANDT
  • I_GLINCGORDPRDTVANALYSIS.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Supplier
  • Client
  • I_GLINCGORDPRDTVANALYSIS.SUPPLIER == LFA1.LIFNR
  • I_GLINCGORDPRDTVANALYSIS.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_GLINCGORDPRDTVANALYSIS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_GLINCGORDPRDTVANALYSIS.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • I_GLINCGORDPRDTVANALYSIS.VALUATIONAREA == T001K.BWKEY
  • I_GLINCGORDPRDTVANALYSIS.MANDT == T001K.MANDT