P_ActlSemTagMarginMultiCrcy

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