P_ActlSemTagMultiCrcy_F8689

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_ActlSemTagMultiCrcy_F8689.
-- 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_ActlSemTagMultiCrcy_F8689 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.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.Segment AS Segment,
  ActlLineItemSegTag.WBSElementInternalID AS WBSElementInternalID,
  ActlLineItemSegTag.ProjectNetwork AS ProjectNetwork,
  ActlLineItemSegTag.FunctionalArea AS FunctionalArea,
  ActlLineItemSegTag.Product AS Product,
  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.ProjectUUID AS ProjectUUID,
  ActlLineItemSegTag.Project AS Project,
  ActlLineItemSegTag.ProjectInternalID AS ProjectInternalID,
  ActlLineItemSegTag.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._Supplier AS _Supplier,
  ActlLineItemSegTag._AccountingDocumentType AS _AccountingDocumentType,
  ActlLineItemSegTag._CurrentProfitCenter AS _CurrentProfitCenter,
  ActlLineItemSegTag._CurrentCostCenter AS _CurrentCostCenter,
  ActlLineItemSegTag._ServiceDocument AS _ServiceDocument,
  ActlLineItemSegTag.BillableControl AS BillableControl,
  ActlLineItemSegTag.ServicesRenderedDate AS ServicesRenderedDate,
  ActlLineItemSegTag.CostAnalysisResource AS CostAnalysisResource,
  ActlLineItemSegTag.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  ActlLineItemSegTag.PersonnelNumber AS PersonnelNumber,
  ActlLineItemSegTag.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  ActlLineItemSegTag.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  ActlLineItemSegTag._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  ActlLineItemSegTag.IsCommitment AS IsCommitment,
  ActlLineItemSegTag.ProjectProfileCode AS ProjectProfileCode,
  ActlLineItemSegTag.ProjectManagerUUID AS ProjectManagerUUID,
  ActlLineItemSegTag.ProjectManager AS ProjectManager,
  ActlLineItemSegTag.AvailabilityControlProfile AS AvailabilityControlProfile,
  ActlLineItemSegTag.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  ActlLineItemSegTag.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  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 ' ' then ActlLineItemSegTag.AmountInTransactionCurrency when 'FC ' then ActlLineItemSegTag.AmountInFunctionalCurrency 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 'FDC1' then cast ('0' as abap.curr( 23,2)) 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._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._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._FunctionalArea AS _FunctionalArea,
  ActlLineItemSegTag._Product AS _Product,
  ActlLineItemSegTag._Plant AS _Plant,
  ActlLineItemSegTag._SalesOrganization AS _SalesOrganization,
  ActlLineItemSegTag._SalesDistrict AS _SalesDistrict,
  ActlLineItemSegTag._CustomerSupplierCountry AS _CustomerSupplierCountry,
  ActlLineItemSegTag._ShipToParty AS _ShipToParty,
  ActlLineItemSegTag._BillToParty AS _BillToParty,
  ActlLineItemSegTag._FiscalYearVariant AS _FiscalYearVariant,
  ActlLineItemSegTag._WBSElementBasicData AS _WBSElementBasicData,
  ActlLineItemSegTag._CostAnalysisResource AS _CostAnalysisResource,
  ActlLineItemSegTag._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  ActlLineItemSegTag._ProjectManager AS _ProjectManager
FROM P_GLAcctLineItemSemTagRevProj AS ActlLineItemSegTag
INNER JOIN I_PrjMargAnlysRptCrcyFld AS CurrencyField ON /* join condition not captured in parsed metadata */
;