P_SemTagAndSubldgrItmDisCrcy

DDL: P_SEMTAGANDSUBLDGRITMDISCRCY Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING
138 Fields 6 Data Sources

SubLedger and Semantic Tag View

P_SemTagAndSubldgrItmDisCrcy is a Composite CDS View that provides data about "SubLedger and Semantic Tag View" in SAP S/4HANA. It reads from 6 data sources and exposes 138 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. Part of development package FINS_COPA_REPORTING.

Data Sources (6)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem union_all
I_GLAcctLineItemSemTagGLAcct I_GLAcctLineItemSemTagGLAcct from
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles inner
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles inner
I_MargAnlysRptCurrencyField I_MargAnlysRptCurrencyField inner
I_MargAnlysRptCurrencyField I_MargAnlysRptCurrencyField inner

Parameters (1)

NameTypeDefault
P_GLAccountHierarchy fins_sem_tag_hryid

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey LedgerGLLineItem view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label SubLedger and Semantic Tag View view

Fields (138)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAcctLineItemSemTagGLAcct Ledger Ledger
KEY SourceLedger I_GLAcctLineItemSemTagGLAcct SourceLedger Source Ledger
KEY CompanyCode I_GLAcctLineItemSemTagGLAcct CompanyCode Receiver Company Code
KEY FiscalYear I_GLAcctLineItemSemTagGLAcct FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAcctLineItemSemTagGLAcct AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAcctLineItemSemTagGLAcct LedgerGLLineItem Journal Entry Item
KEY CurrencyField I_MargAnlysRptCurrencyField CurrencyField
LedgerFiscalYear I_GLAcctLineItemSemTagGLAcct LedgerFiscalYear
FiscalPeriod I_GLAcctLineItemSemTagGLAcct FiscalPeriod Tax period
FiscalYearPeriod I_GLAcctLineItemSemTagGLAcct FiscalYearPeriod Period/Year
GLAccount I_GLAcctLineItemSemTagGLAcct GLAccount General Ledger
GLAccountHierarchy I_GLAcctLineItemSemTagGLAcct GLAccountHierarchy
SemanticTag I_GLAcctLineItemSemTagGLAcct SemanticTag Semantic Tag
CostCenter I_GLAcctLineItemSemTagGLAcct CostCenter Cost Center
ProfitCenter I_GLAcctLineItemSemTagGLAcct ProfitCenter Profit Center
FunctionalArea I_GLAcctLineItemSemTagGLAcct FunctionalArea Sendr Fctl Area
BusinessArea I_GLAcctLineItemSemTagGLAcct BusinessArea Business Area
Segment I_GLAcctLineItemSemTagGLAcct Segment Segment number
ChartOfAccounts I_GLAcctLineItemSemTagGLAcct ChartOfAccounts Node Class
SalesOrganization I_GLAcctLineItemSemTagGLAcct SalesOrganization Sales Organization
ControllingArea I_GLAcctLineItemSemTagGLAcct ControllingArea Controlling Area
DistributionChannel I_GLAcctLineItemSemTagGLAcct DistributionChannel RefDistCh-Cust/Mat.
CustomerSupplierCountry I_GLAcctLineItemSemTagGLAcct CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry I_GLAcctLineItemSemTagGLAcct CustomerSupplierIndustry Industry
PurchasingDocument I_GLAcctLineItemSemTagGLAcct PurchasingDocument Purchasing Document
FiscalYearVariant I_GLAcctLineItemSemTagGLAcct FiscalYearVariant FY Variant
BusinessTransactionType I_GLAcctLineItemSemTagGLAcct BusinessTransactionType Bus.transaction
ReferenceDocumentType I_GLAcctLineItemSemTagGLAcct ReferenceDocumentType Reference Document Type
InventoryValuationType I_GLAcctLineItemSemTagGLAcct InventoryValuationType Valuation Type
Product I_GLAcctLineItemSemTagGLAcct Product Product Sold
InptPrVarcAmtInDspCrcy
OutpPrVarcAmtInDspCrcy
InptQtyVarcAmtInDspCrcy
RsceUsgeVarcAmtInDspCrcy
LotSizeVarcAmtInDspCrcy
InptRmngVarcAmtInDspCrcy
CompanyCodeCurrency I_GLAcctLineItemSemTagGLAcct CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAcctLineItemSemTagGLAcct AmountInCompanyCodeCurrency Local Crcy Amt
FixedAmountInCoCodeCrcy I_GLAcctLineItemSemTagGLAcct FixedAmountInCoCodeCrcy
GlobalCurrency I_GLAcctLineItemSemTagGLAcct GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_GLAcctLineItemSemTagGLAcct AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy I_GLAcctLineItemSemTagGLAcct FixedAmountInGlobalCrcy
QuantityUnit I_GLAcctLineItemSemTagGLAcct BaseUnit Unit of Measure
Quantity I_GLAcctLineItemSemTagGLAcct Quantity Value
FixedQuantity I_GLAcctLineItemSemTagGLAcct FixedQuantity Fixed Quantity
CostSourceUnit I_GLAcctLineItemSemTagGLAcct CostSourceUnit
ValuationQuantity I_GLAcctLineItemSemTagGLAcct ValuationQuantity
SalesDocument I_GLAcctLineItemSemTagGLAcct SalesDocument SD Document
SalesDocumentItem I_GLAcctLineItemSemTagGLAcct SalesOrderItem Sales Document Item
Plant I_GLAcctLineItemSemTagGLAcct Plant Valuation Area
Customer I_GLAcctLineItemSemTagGLAcct Customer Sold-to Party
AccountAssignmentType I_GLAcctLineItemSemTagGLAcct AccountAssignmentType Sndr AcctAssgmt Type
OrderID I_GLAcctLineItemSemTagGLAcct OrderID Order ID
OrderCategory I_GLAcctLineItemSemTagGLAcct OrderCategory Order Category
SoldProduct I_GLAcctLineItemSemTagGLAcct SoldProduct Product Sold
SoldProductGroup I_GLAcctLineItemSemTagGLAcct SoldProductGroup Product Sold Group
CustomerGroup I_GLAcctLineItemSemTagGLAcct CustomerGroup Customer Group
SalesDistrict I_GLAcctLineItemSemTagGLAcct SalesDistrict Sales District
ShipToParty I_GLAcctLineItemSemTagGLAcct ShipToParty Ship-To Party (obsolete)
BillToParty I_GLAcctLineItemSemTagGLAcct BillToParty Inv. Recipient
_ChartOfAccounts I_GLAcctLineItemSemTagGLAcct _ChartOfAccounts
_GLAccountInChartOfAccounts I_GLAcctLineItemSemTagGLAcct _GLAccountInChartOfAccounts
PostingDate I_GLAcctLineItemSemTagGLAcct PostingDate Posting Date for GR
Supplier I_GLAcctLineItemSemTagGLAcct Supplier Supplier
FinancialAccountType I_GLAcctLineItemSemTagGLAcct FinancialAccountType Fin. Account Type
OrganizationDivision I_GLAcctLineItemSemTagGLAcct OrganizationDivision Org. Division
AssetClass I_GLAcctLineItemSemTagGLAcct AssetClass Asset Class
ValuationArea I_GLAcctLineItemSemTagGLAcct ValuationArea Valuation Area
_Supplier I_GLAcctLineItemSemTagGLAcct _Supplier
_GlobalCurrency I_GLAcctLineItemSemTagGLAcct _GlobalCurrency
_CompanyCodeCurrency I_GLAcctLineItemSemTagGLAcct _CompanyCodeCurrency
Ledger Ledger
KEY SourceLedger I_GLAccountLineItem SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY CurrencyField I_MargAnlysRptCurrencyField CurrencyField
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
FiscalYearPeriod I_GLAccountLineItem FiscalYearPeriod Period/Year
GLAccount I_GLAccountLineItem GLAccount General Ledger
GLAccountHierarchy
SemanticTag Semantic Tag
CostCenter I_GLAccountLineItem CostCenter Cost Center
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItem BusinessArea Business Area
Segment I_GLAccountLineItem Segment Segment number
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
DistributionChannel I_GLAccountLineItem DistributionChannel RefDistCh-Cust/Mat.
CustomerSupplierCountry I_GLAccountLineItem CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry I_GLAccountLineItem CustomerSupplierIndustry Industry
PurchasingDocument I_GLAccountLineItem PurchasingDocument Purchasing Document
FiscalYearVariant I_GLAccountLineItem FiscalYearVariant FY Variant
BusinessTransactionType I_GLAccountLineItem BusinessTransactionType Bus.transaction
ReferenceDocumentType I_GLAccountLineItem ReferenceDocumentType Reference Document Type
InventoryValuationType I_GLAccountLineItem InventoryValuationType Valuation Type
Product I_GLAccountLineItem Product Product Sold
FixedAmountInDspCrcy
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
FixedAmountInCoCodeCrcy I_GLAccountLineItem FixedAmountInCoCodeCrcy
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy I_GLAccountLineItem FixedAmountInGlobalCrcy
QuantityUnit I_GLAccountLineItem BaseUnit Unit of Measure
Quantity I_GLAccountLineItem Quantity Value
FixedQuantity I_GLAccountLineItem FixedQuantity Fixed Quantity
CostSourceUnit I_GLAccountLineItem CostSourceUnit
ValuationQuantity I_GLAccountLineItem ValuationQuantity
SalesDocument I_GLAccountLineItem SalesDocument SD Document
SalesDocumentItem I_GLAccountLineItem SalesDocumentItem Sales Document Item
Plant I_GLAccountLineItem Plant Valuation Area
Customer I_GLAccountLineItem Customer Sold-to Party
AccountAssignmentType I_GLAccountLineItem AccountAssignmentType Sndr AcctAssgmt Type
OrderID I_GLAccountLineItem OrderID Order ID
OrderCategory I_GLAccountLineItem OrderCategory Order Category
SoldProduct I_GLAccountLineItem SoldProduct Product Sold
SoldProductGroup I_GLAccountLineItem SoldProductGroup Product Sold Group
CustomerGroup I_GLAccountLineItem CustomerGroup Customer Group
SalesDistrict I_GLAccountLineItem SalesDistrict Sales District
ShipToParty I_GLAccountLineItem ShipToParty Ship-To Party (obsolete)
BillToParty I_GLAccountLineItem BillToParty Inv. Recipient
_ChartOfAccounts I_GLAccountLineItem _ChartOfAccounts
_GLAccountInChartOfAccounts I_GLAccountLineItem _GLAccountInChartOfAccounts
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
Supplier I_GLAccountLineItem Supplier Supplier
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
AssetClass I_GLAccountLineItem AssetClass Asset Class
ValuationArea I_GLAccountLineItem ValuationArea Valuation Area
_Supplier I_GLAccountLineItem _Supplier
_GlobalCurrency I_GLAccountLineItem _GlobalCurrency
_CompanyCodeCurrency I_GLAccountLineItem _CompanyCodeCurrency
_Plant I_GLAccountLineItem _Plant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SemTagAndSubldgrItmDisCrcy.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW P_SemTagAndSubldgrItmDisCrcy AS
SELECT
  I_GLAcctLineItemSemTagGLAcct.Ledger AS Ledger,
  I_GLAcctLineItemSemTagGLAcct.SourceLedger AS SourceLedger,
  I_GLAcctLineItemSemTagGLAcct.CompanyCode AS CompanyCode,
  I_GLAcctLineItemSemTagGLAcct.FiscalYear AS FiscalYear,
  I_GLAcctLineItemSemTagGLAcct.AccountingDocument AS AccountingDocument,
  I_GLAcctLineItemSemTagGLAcct.LedgerGLLineItem AS LedgerGLLineItem,
  I_MargAnlysRptCurrencyField.CurrencyField AS CurrencyField,
  I_GLAcctLineItemSemTagGLAcct.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAcctLineItemSemTagGLAcct.FiscalPeriod AS FiscalPeriod,
  I_GLAcctLineItemSemTagGLAcct.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAcctLineItemSemTagGLAcct.GLAccount AS GLAccount,
  I_GLAcctLineItemSemTagGLAcct.GLAccountHierarchy AS GLAccountHierarchy,
  I_GLAcctLineItemSemTagGLAcct.SemanticTag AS SemanticTag,
  I_GLAcctLineItemSemTagGLAcct.CostCenter AS CostCenter,
  I_GLAcctLineItemSemTagGLAcct.ProfitCenter AS ProfitCenter,
  I_GLAcctLineItemSemTagGLAcct.FunctionalArea AS FunctionalArea,
  I_GLAcctLineItemSemTagGLAcct.BusinessArea AS BusinessArea,
  I_GLAcctLineItemSemTagGLAcct.Segment AS Segment,
  I_GLAcctLineItemSemTagGLAcct.ChartOfAccounts AS ChartOfAccounts,
  I_GLAcctLineItemSemTagGLAcct.SalesOrganization AS SalesOrganization,
  I_GLAcctLineItemSemTagGLAcct.ControllingArea AS ControllingArea,
  I_GLAcctLineItemSemTagGLAcct.DistributionChannel AS DistributionChannel,
  I_GLAcctLineItemSemTagGLAcct.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAcctLineItemSemTagGLAcct.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAcctLineItemSemTagGLAcct.PurchasingDocument AS PurchasingDocument,
  I_GLAcctLineItemSemTagGLAcct.FiscalYearVariant AS FiscalYearVariant,
  I_GLAcctLineItemSemTagGLAcct.BusinessTransactionType AS BusinessTransactionType,
  I_GLAcctLineItemSemTagGLAcct.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAcctLineItemSemTagGLAcct.InventoryValuationType AS InventoryValuationType,
  I_GLAcctLineItemSemTagGLAcct.Product AS Product,
  cast ( cast ('0' as abap.curr( 23,2)) as fis_inptprvarcamt_in_dspcrcy preserving type) AS InptPrVarcAmtInDspCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_outpprvarcamt_in_dspcrcy preserving type) AS OutpPrVarcAmtInDspCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fin_inptqtyvarcamt_in_dspcrcy preserving type) AS InptQtyVarcAmtInDspCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fin_rsceusgevarcamt_in_dspcrcy preserving type) AS RsceUsgeVarcAmtInDspCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fin_lotsizevarcamt_in_dspcrcy preserving type) AS LotSizeVarcAmtInDspCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fin_inptrmngvarcamt_in_dspcrcy preserving type) AS InptRmngVarcAmtInDspCrcy,
  I_GLAcctLineItemSemTagGLAcct.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAcctLineItemSemTagGLAcct.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAcctLineItemSemTagGLAcct.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAcctLineItemSemTagGLAcct.GlobalCurrency AS GlobalCurrency,
  I_GLAcctLineItemSemTagGLAcct.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAcctLineItemSemTagGLAcct.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAcctLineItemSemTagGLAcct.BaseUnit AS QuantityUnit,
  I_GLAcctLineItemSemTagGLAcct.Quantity AS Quantity,
  I_GLAcctLineItemSemTagGLAcct.FixedQuantity AS FixedQuantity,
  I_GLAcctLineItemSemTagGLAcct.CostSourceUnit AS CostSourceUnit,
  I_GLAcctLineItemSemTagGLAcct.ValuationQuantity AS ValuationQuantity,
  I_GLAcctLineItemSemTagGLAcct.SalesDocument AS SalesDocument,
  I_GLAcctLineItemSemTagGLAcct.SalesOrderItem AS SalesDocumentItem,
  I_GLAcctLineItemSemTagGLAcct.Plant AS Plant,
  I_GLAcctLineItemSemTagGLAcct.Customer AS Customer,
  I_GLAcctLineItemSemTagGLAcct.AccountAssignmentType AS AccountAssignmentType,
  I_GLAcctLineItemSemTagGLAcct.OrderID AS OrderID,
  I_GLAcctLineItemSemTagGLAcct.OrderCategory AS OrderCategory,
  I_GLAcctLineItemSemTagGLAcct.SoldProduct AS SoldProduct,
  I_GLAcctLineItemSemTagGLAcct.SoldProductGroup AS SoldProductGroup,
  I_GLAcctLineItemSemTagGLAcct.CustomerGroup AS CustomerGroup,
  I_GLAcctLineItemSemTagGLAcct.SalesDistrict AS SalesDistrict,
  I_GLAcctLineItemSemTagGLAcct.ShipToParty AS ShipToParty,
  I_GLAcctLineItemSemTagGLAcct.BillToParty AS BillToParty,
  I_GLAcctLineItemSemTagGLAcct._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAcctLineItemSemTagGLAcct._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAcctLineItemSemTagGLAcct.PostingDate AS PostingDate,
  I_GLAcctLineItemSemTagGLAcct.Supplier AS Supplier,
  I_GLAcctLineItemSemTagGLAcct.FinancialAccountType AS FinancialAccountType,
  I_GLAcctLineItemSemTagGLAcct.OrganizationDivision AS OrganizationDivision,
  I_GLAcctLineItemSemTagGLAcct.AssetClass AS AssetClass,
  I_GLAcctLineItemSemTagGLAcct.ValuationArea AS ValuationArea,
  I_GLAcctLineItemSemTagGLAcct._Supplier AS _Supplier,
  I_GLAcctLineItemSemTagGLAcct._GlobalCurrency AS _GlobalCurrency,
  I_GLAcctLineItemSemTagGLAcct._CompanyCodeCurrency AS _CompanyCodeCurrency,
  cast( 0 as fis_fixamount_crcyrolecrcy ) AS FixedAmountInDspCrcy,
  I_GLAccountLineItem._Plant AS _Plant
FROM I_GLAcctLineItemSemTagGLAcct
INNER JOIN I_MargAnlysRptCurrencyField ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;

Learn More