P_ActlLineItmMargMultiCrcy

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_ActlLineItmMargMultiCrcy.
-- 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_ActlLineItmMargMultiCrcy AS
SELECT
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  CurrencyField.CurrencyField AS CurrencyField,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItem.PurchasingDocument AS PurchasingDocument,
  I_GLAccountLineItem.SalesOrder AS SalesOrder,
  I_GLAccountLineItem.SalesOrderItem AS SalesOrderItem,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.OrderCategory AS OrderCategory,
  I_GLAccountLineItem.ConditionContract AS ConditionContract,
  I_GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItem.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItem.ShipToParty AS ShipToParty,
  I_GLAccountLineItem.BillToParty AS BillToParty,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.BaseUnit AS BaseUnit,
  I_GLAccountLineItem.OrderType AS OrderType,
  I_GLAccountLineItem.Segment AS Segment,
  cast( I_GLAccountLineItem.WBSElement as ps_posid preserving type ) AS WBSElement,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItem.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.Product AS Product,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.ServiceContract AS ServiceContract,
  I_GLAccountLineItem.ServiceContractItem AS ServiceContractItem,
  I_GLAccountLineItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  I_GLAccountLineItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  I_GLAccountLineItem.ProviderContract AS ProviderContract,
  I_GLAccountLineItem.ProviderContractItem AS ProviderContractItem,
  I_GLAccountLineItem.ServiceContractType AS ServiceContractType,
  I_GLAccountLineItem.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.Project AS Project,
  I_GLAccountLineItem.ProjectInternalID AS ProjectInternalID,
  I_GLAccountLineItem._ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.BillableControl AS BillableControl,
  I_GLAccountLineItem.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAccountLineItem.Material AS Material,
  I_GLAccountLineItem.WorkPackage AS WorkPackage,
  I_GLAccountLineItem.WorkItem AS WorkItem,
  I_GLAccountLineItem.CostAnalysisResource AS CostAnalysisResource,
  I_GLAccountLineItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItem.PersonnelNumber AS PersonnelNumber,
  I_GLAccountLineItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItem.IsCommitment AS IsCommitment,
  I_GLAccountLineItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAccountLineItem.DocumentItemText AS DocumentItemText,
  cast( case CurrencyField.CurrencyField when 'CCC ' then I_GLAccountLineItem.AmountInCompanyCodeCurrency when 'GC ' then I_GLAccountLineItem.AmountInGlobalCurrency when 'FDC1' then I_GLAccountLineItem.AmountInFreeDefinedCurrency1 when 'OC' then I_GLAccountLineItem.AmountInObjectCurrency when 'FC' then I_GLAccountLineItem.AmountInFunctionalCurrency when ' ' then I_GLAccountLineItem.AmountInTransactionCurrency else cast ( 0 as abap.curr( 23, 2 ) ) end as abap.dec( 23, 2 ) ) as AmountInDisplayCurrency AS dec232asAmountInDisplayCurrency,
  cast( case CurrencyField.CurrencyField when 'CCC ' then I_GLAccountLineItem.FixedAmountInCoCodeCrcy when 'GC ' then I_GLAccountLineItem.FixedAmountInGlobalCrcy when ' ' then I_GLAccountLineItem.FixedAmountInTransCrcy else cast ( 0 as abap.curr( 23, 2 ) ) end as abap.dec( 23, 2 ) ) as FixedAmountInDspCrcy AS dec232asFixedAmountInDspCrcy,
  I_GLAccountLineItem.Quantity AS Quantity,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  I_GLAccountLineItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  I_GLAccountLineItem._Project AS _Project,
  I_GLAccountLineItem._ProjectBasicData AS _ProjectBasicData,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._CustomerGroup AS _CustomerGroup,
  I_GLAccountLineItem._PurchasingDocument AS _PurchasingDocument,
  I_GLAccountLineItem._SoldProduct AS _SoldProduct,
  I_GLAccountLineItem._SoldProductGroup AS _SoldProductGroup,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._OriginProfitCenter AS _OriginProfitCenter,
  I_GLAccountLineItem._ControllingArea AS _ControllingArea,
  I_GLAccountLineItem._CostSourceUnit AS _CostSourceUnit,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._SalesOrder AS _SalesOrder,
  I_GLAccountLineItem._SalesOrderItem AS _SalesOrderItem,
  I_GLAccountLineItem._Order AS _Order,
  I_GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  I_GLAccountLineItem._BaseUnit AS _BaseUnit,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._WBSElement AS _WBSElement,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._Product AS _Product,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  I_GLAccountLineItem._SalesDistrict AS _SalesDistrict,
  I_GLAccountLineItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  I_GLAccountLineItem._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  I_GLAccountLineItem._ShipToParty AS _ShipToParty,
  I_GLAccountLineItem._BillToParty AS _BillToParty,
  I_GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItem._WBSElementBasicData AS _WBSElementBasicData,
  I_GLAccountLineItem._Material AS _Material,
  I_GLAccountLineItem._WorkPackage AS _WorkPackage,
  I_GLAccountLineItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
  I_GLAccountLineItem._CostAnalysisResource AS _CostAnalysisResource,
  I_GLAccountLineItem._Employment AS _Employment,
  I_GLAccountLineItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType
FROM I_GLAccountLineItem
INNER JOIN I_PrjMargAnlysRptCrcyFld AS CurrencyField ON /* join condition not captured in parsed metadata */
;