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,
  li.ComponentBreakdown AS ComponentBreakdown,
  mtd.ComponentBreakdownMethod AS ComponentBreakdownMethod,
  cb.ComponentBreakdownComponent AS ComponentBreakdownComponent,
  mtd.ComponentBreakdownMethodType AS ComponentBreakdownMethodType,
  mtd._ComponentBreakdownMethod.CostBreakdownStructure AS CostBreakdownStructure,
  coalesce(cb.CostBreakdownComponent, '') AS CostBreakdownComponent,
  mtd._ComponentBreakdownMethod.QuantityBreakdownStructure AS QuantityBreakdownStructure,
  coalesce(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.ReferenceDocumentType AS ReferenceDocumentType,
  li.BusinessTransactionCategory AS BusinessTransactionCategory,
  li.BusinessTransactionType AS BusinessTransactionType,
  li.TransactionTypeDetermination AS TransactionTypeDetermination,
  li.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  li.GLAccount AS GLAccount,
  li.FinancialAccountType AS FinancialAccountType,
  li.PurchasingDocument AS PurchasingDocument,
  li.PurchasingDocumentItem AS PurchasingDocumentItem,
  li.Plant AS Plant,
  li.Product AS Product,
  li.CostEstimate AS CostEstimate,
  li.InventoryValuationType AS InventoryValuationType,
  li.ValuationArea AS ValuationArea,
  cast(li.ControllingDebitCreditCode as fis_co_belkz_no_conv preserving type) AS ControllingDebitCreditCode,
  li.ControllingObjectDebitType AS ControllingObjectDebitType,
  li.AccountAssignmentType AS AccountAssignmentType,
  li.AccountAssignment AS AccountAssignment,
  li.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  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.WBSElementInternalID AS WBSElementInternalID,
  li.WBSElement AS WBSElement,
  li.ProjectInternalID AS ProjectInternalID,
  li.Project AS Project,
  li.ServiceDocumentType AS ServiceDocumentType,
  li.ServiceDocument AS ServiceDocument,
  li.ServiceDocumentItem AS ServiceDocumentItem,
  li.CostOriginGroup AS CostOriginGroup,
  li.BusinessArea AS BusinessArea,
  li.FunctionalArea AS FunctionalArea,
  li.Segment AS Segment,
  li.SalesDocument AS SalesDocument,
  li.SalesDocumentItem AS SalesDocumentItem,
  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,
  cast(coalesce(cb.ComponentBreakdownQuantityUnit, cast('' as fucb_quantity_unit)) as fucb_quantity_unit preserving type) AS ComponentBreakdownQuantityUnit,
  cast(li.CompanyCodeCurrency as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(li.GlobalCurrency as fis_rkcur preserving type) AS GlobalCurrency,
  li.FunctionalCurrency AS FunctionalCurrency,
  cast(li.FreeDefinedCurrency1 as fis_rocur preserving type) AS FreeDefinedCurrency1,
  mtd._ComponentBreakdownMethod AS _ComponentBreakdownMethod
FROM I_GLAccountLineItemRawData AS li
;