P_GLIncgOrdPrdtvAnalysisUnion

Incoming Sales Orders Union | view: PFGLIOPRANLS | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
Tables used: SCAL_TT_DATE, VBAK, ACDOCA, HRRP_FSV_DIR, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, 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
💲 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
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
  • Client
  • Journal Entry Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T003.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Client
  • Asset Class
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == ANKA.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.ASSETCLASS == ANKA.ANLKL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T006.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.BASEUNIT == T006.MSEHI
Billing Type
  • Client
  • Billing Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TVFK.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == KNA1.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Business Area
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.BUSINESSAREA == TGSB.GSBER
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TGSB.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T001.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TKA01.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • P_GLINCGORDPRDTVANALYSISUNION.[column in domain "DATBI"] == CSKS.DATBI
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == CSKS.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.COSTCENTER == CSKS.KOSTL
  • P_GLINCGORDPRDTVANALYSISUNION.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Customer Number
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.CUSTOMER == KNA1.KUNNR
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T151.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T005.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T016.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TVTW.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Division
  • Sales Organization
  • P_GLINCGORDPRDTVANALYSISUNION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TVTA.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.DIVISION == TVTA.SPART
  • P_GLINCGORDPRDTVANALYSISUNION.ORGANIZATIONDIVISION == TVTA.SPART
  • P_GLINCGORDPRDTVANALYSISUNION.SALESORGANIZATION == TVTA.VKORG
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T856.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T009.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Fixed Asset
  • Asset Subnumber
  • ?
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == ANLA.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.MASTERFIXEDASSET == ANLA.ANLN1
  • P_GLINCGORDPRDTVANALYSISUNION.FIXEDASSET == ANLA.ANLN2
  • P_GLINCGORDPRDTVANALYSISUNION.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == SKB1.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.GLACCOUNT == SKB1.SAKNR
  • P_GLINCGORDPRDTVANALYSISUNION.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FINSC_LEDGER.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.LEDGER == FINSC_LEDGER.RLDNR
  • P_GLINCGORDPRDTVANALYSISUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR
Product Sold Group
  • Client
  • Product Sold Group
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T023.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.MATERIALGROUP == T023.MATKL
Operating Concern
  • Operating Concern
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.OPERATINGCONCERN == TKEB.ERKRS
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TKEB.MANDT
Order ID
  • Client
  • Order ID
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == AUFK.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.ORDERID == AUFK.AUFNR
Order type in order header
  • Client
  • Sales Document Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TVAK.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.ORDERTYPE == TVAK.AUART
Division
  • Client
  • Division
  • Division
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TSPA.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.DIVISION == TSPA.SPART
  • P_GLINCGORDPRDTVANALYSISUNION.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T001W.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TBSL.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.POSTINGKEY == TBSL.BSCHL
Profit Center
  • ?
  • Client
  • Profit Center
  • Controlling Area
  • P_GLINCGORDPRDTVANALYSISUNION.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == CEPC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.PROFITCENTER == CEPC.PRCTR
  • P_GLINCGORDPRDTVANALYSISUNION.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type P_GLINCGORDPRDTVANALYSISUNION.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.SALESDISTRICT == T171.BZIRK
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TVKO.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FAGL_SEGM.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.SEMANTICTAG == FINSC_SEM_TAG.FINS_SEM_TAG
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FINSC_SEM_TAG.MANDT
Service Document ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FCO_SRVDOC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Item ID
  • Service Document Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FCO_SRVDOC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_GLINCGORDPRDTVANALYSISUNION.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Ship-to Party
  • Ship-to Party
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.SHIPTOPARTY == KNA1.KUNNR
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_GLINCGORDPRDTVANALYSISUNION.SOLDMATERIAL == MARA.MATNR
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == MARA.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == FINSC_LEDGER.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.LEDGER == FINSC_LEDGER.RLDNR
  • P_GLINCGORDPRDTVANALYSISUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR
Source Document Type P_GLINCGORDPRDTVANALYSISUNION.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • P_GLINCGORDPRDTVANALYSISUNION.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T074U.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == LFA1.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == TCURC.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • P_GLINCGORDPRDTVANALYSISUNION.MANDT == T001K.MANDT
  • P_GLINCGORDPRDTVANALYSISUNION.VALUATIONAREA == T001K.BWKEY