P_SemTagAndSubLedgerItem

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_SemTagAndSubLedgerItem.
-- 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.
-- SQL view name: PSEMTAGSLITP
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW P_SemTagAndSubLedgerItem AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  AccountingDocument,
  LedgerGLLineItem,
  SemanticTag,
  cast( '' as fins_sem_tag_hryid ) AS GLAccountHierarchy,
  LedgerFiscalYear,
  ProfitCenter,
  SoldProduct,
  SoldProductGroup,
  Customer,
  CustomerGroup,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  OrderID,
  OrderCategory,
  ConditionContract,
  FiscalYearPeriod,
  ChartOfAccounts,
  GLAccount,
  SalesOrganization,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  ShipToParty,
  BillToParty,
  ControllingArea,
  CostSourceUnit,
  BusinessTransactionType,
  SubLedgerAcctLineItemType,
  DistributionChannel,
  OrganizationDivision,
  BaseUnit,
  OrderType,
  Segment,
  Project,
  WBSElement,
  ProjectNetwork,
  FunctionalArea,
  Plant,
  FiscalYearVariant,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  ServiceContractType,
  AccountAssignmentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ProjectInternalID,
  BusinessArea,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  cast(cast( '' as abap.char( 1 ) ) as fins_xsemtag_calculated) AS LineIsSemTagCalculated,
  GlobalCurrency,
  CompanyCodeCurrency,
  FreeDefinedCurrency1,
  AmountInCompanyCodeCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInGlobalCurrency,
  FixedAmountInCoCodeCrcy,
  FixedAmountInGlobalCrcy,
  cast( cast ('0' as abap.curr( 23,2) ) as fins_trr_actrevn preserving type ) AS BilledRevenueAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_sales_deduction) AS SalesDeductionAmountInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_trr_revnadjust) AS RevenueAdjustAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2) ) as fins_trr_recrevn preserving type ) AS RecognizedRevnAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_cogs_variable ) AS VarblCOGSAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_i ) AS ContrbnMargin1AmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_cogs_fixed) AS FxdCOGSAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_price_differences) AS PriceDifferenceAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_ii) AS ContrbnMargin2AmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_administration_overhead) AS AdminOverheadAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_sales_overhead) AS SalesOverheadAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_marketing_overhead) AS MarketingOverheadAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_research_and_dev_overhead) AS RnDOverheadAmtInGlobCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_contribution_margin_iii) AS ContrbnMargin3AmtInGlobCrcy,
  InptPriceVarcAmtInGlobCrcy,
  OutpPriceVarcAmtInGlobCrcy,
  InptQtyVarcAmtInGlobCrcy,
  RsceUsgeVarcAmtInGlobCrcy,
  LotSizeVarcAmtInGlobCrcy,
  InputRmngVarcAmtInGlobCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_billed_revenue_cccrcy) AS BilledRevenueAmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_sales_deduction_cccrcy) AS SalesDeductionAmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fis_adj_rev_hsl) AS RevenueAdjustmentAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fis_reco_rev_hsl) AS RecognizedRevnAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_variable_cccrcy) AS VarblCOGSAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_1_cccrcy) AS ContrbnMargin1AmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_fixed_ccrcy) AS FxdCOGSAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_price_differences_cccrcy) AS PriceDifferenceAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_2_cccrcy) AS ContrbnMargin2AmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_admin_overhead_cccrcy) AS AdminOverheadAmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_sales_overhead_cccrcy) AS SalesOverheadAmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_marketing_overhead_cccrcy) AS MarketingOvhdAmtInCoCodeCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_resear_dev_overhead_ccrcy) AS RnDOverheadAmtInCCCrcy,
  cast ( cast ('0' as abap.curr( 23,2)) as fins_cogs_contribmarg_3_cccrcy) AS ContrbnMargin3AmtInCoCodeCrcy,
  InptPriceVarcAmtInCoCodeCrcy,
  OutpPrVarcAmtInCoCodeCrcy,
  InptQtyVarcAmtInCoCodeCrcy,
  RsceUsgeVarcAmtInCoCodeCrcy,
  LotSizeVarcAmtInCoCodeCrcy,
  InputRmngVarcAmtInCoCodeCrcy,
  cast( cast ('0' as abap.curr( 23,2)) as fins_billed_quantity) AS BilledValnQtyInCostSourceUnit,
  Supplier,
  AccountingDocumentType,
  FinancialAccountType,
  CostCenter,
  ValuationArea,
  AssetClass,
  PostingDate
FROM I_GLAcctLineItmSubLdgrItmTypeC
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON projectexternalid = _ProjectExternalID.ProjectExternalID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemSemTag
;