P_GLAcctLineItemCompBreakdown

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_GLAcctLineItemCompBreakdown.
-- 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.

CREATE VIEW P_GLAcctLineItemCompBreakdown AS
SELECT
  li.SourceLedger AS SourceLedger,
  li.CompanyCode AS CompanyCode,
  li.FiscalYear AS FiscalYear,
  li.AccountingDocument AS AccountingDocument,
  li.LedgerGLLineItem AS LedgerGLLineItem,
  cb.ComponentBreakdown AS ComponentBreakdown,
  cb.ComponentBreakdownMethod AS ComponentBreakdownMethod,
  cb.ComponentBreakdownComponent AS ComponentBreakdownComponent,
  cb._ComponentBreakdownMethod.ComponentBreakdownMethodType AS ComponentBreakdownMethodType,
  cb.CostBreakdownStructure AS CostBreakdownStructure,
  cb.CostBreakdownComponent AS CostBreakdownComponent,
  cb.QuantityBreakdownStructure AS QuantityBreakdownStructure,
  cb.QuantityBreakdownComponent AS QuantityBreakdownComponent,
  li.LedgerFiscalYear AS LedgerFiscalYear,
  li.ChartOfAccounts AS ChartOfAccounts,
  li.ControllingArea AS ControllingArea,
  li.FiscalPeriod AS FiscalPeriod,
  li.FiscalYearPeriod AS FiscalYearPeriod,
  li.PostingDate AS PostingDate,
  li.FiscalYearVariant AS FiscalYearVariant,
  li.AccountingDocumentType AS AccountingDocumentType,
  li.ReferenceDocument AS ReferenceDocument,
  li.BusinessTransactionCategory AS BusinessTransactionCategory,
  li.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  li.GLAccount AS GLAccount,
  li.FinancialAccountType AS FinancialAccountType,
  li.Plant AS Plant,
  li.Product AS Product,
  li.CostEstimate AS CostEstimate,
  li.ValuationArea AS ValuationArea,
  cast( li.ControllingDebitCreditCode as fis_co_belkz_no_conv preserving type ) AS ControllingDebitCreditCode,
  li.AccountAssignmentType AS AccountAssignmentType,
  li.AccountAssignment AS AccountAssignment,
  li.CostCenter AS CostCenter,
  li.CostCtrActivityType AS CostCtrActivityType,
  li.OriginCostCenter AS OriginCostCenter,
  li.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  li.OrderID AS OrderID,
  li.OrderItem AS OrderItem,
  li.OrderCategory AS OrderCategory,
  li.BusinessArea AS BusinessArea,
  li.FunctionalArea AS FunctionalArea,
  li.Segment AS Segment,
  li.SalesDocument AS SalesDocument,
  li.SalesOrganization AS SalesOrganization,
  li.SalesDistrict AS SalesDistrict,
  li.ShipToParty AS ShipToParty,
  li.BillToParty AS BillToParty,
  li.DistributionChannel AS DistributionChannel,
  li.OrganizationDivision AS OrganizationDivision,
  li.ProfitCenter AS ProfitCenter,
  li.SoldProduct AS SoldProduct,
  li.SoldProductGroup AS SoldProductGroup,
  li.Customer AS Customer,
  li.CustomerGroup AS CustomerGroup,
  cb.QuantityUnit AS QuantityUnit,
  cast(cb.CompanyCodeCurrency as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(cb.GlobalCurrency as fis_rkcur preserving type) AS GlobalCurrency,
  cb._ComponentBreakdownMethod AS _ComponentBreakdownMethod,
  cb._CostBreakdownStructure AS _CostBreakdownStructure,
  cb._CostBreakdownComponent AS _CostBreakdownComponent,
  cb._QtyBreakdownStructure AS _QtyBreakdownStructure,
  cb._QtyBreakdownComponent AS _QtyBreakdownComponent
FROM I_GLAccountLineItemRawData AS li
INNER JOIN R_ComponentBreakdown AS cb ON /* join condition not captured in parsed metadata */
;