P_GrossMarginUnion_2

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_GrossMarginUnion_2.
-- 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.
-- SQL view name: PGRSSMARGUNION2
-- Parameters: P_Ledger : fins_ledger

CREATE VIEW P_GrossMarginUnion_2 AS
SELECT
  $parameters.P_Ledger AS Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  cast(cast('00000000000000000000000' as abap.numc(23))as rspm_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast(cast('000000' as abap.numc(6)) as rsdatapid) AS FinancialPlanningDataPacket,
  cast(0 as rsarecord) AS FinancialPlanningEntryItem,
  DocumentDate,
  SalesOrganization,
  CustomerGroup,
  Customer,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  FiscalPeriod,
  CompanyCodeCurrency,
  GlobalCurrency,
  cast(SoldProductGroup as fins_matkl_pa) AS MaterialGroup,
  ProfitCenter,
  ControllingArea,
  SalesDistrict,
  Segment,
  DistributionChannel,
  SoldProduct AS SoldMaterial,
  BusinessTransactionType,
  BusinessArea,
  CostCenter,
  CustomerSupplierCountry,
  FiscalYearPeriod,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AccountingDocumentCategory,
  _GL.GLAccount AS GLAccount,
  PostingDate,
  CreationDate,
  _GL.ChartOfAccounts AS ChartOfAccounts,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  AmountInTransactionCurrency,
  DebitCreditCode,
  AssignmentReference,
  PostingKey,
  AccountingDocCreatedByUser,
  GLAccountType,
  Plant,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  BillingDocumentType,
  OrganizationDivision,
  CustomerSupplierIndustry,
  BillToParty,
  ShipToParty,
  cast(SourceReferenceDocumentType as fins_src_awtyp) AS SourceReferenceDocumentType,
  cast(SourceReferenceDocument as fins_src_ref_doc) AS SourceReferenceDocument,
  cast(OperatingConcern as fins_erkrs preserving type) AS OperatingConcern,
  TransactionTypeDetermination,
  cast(ControllingDebitCreditCode as fins_debit_credit_indicator_co preserving type) AS ControllingDebitCreditCode,
  AccountingDocumentType,
  ReferenceDocumentType,
  FiscalYearVariant,
  cast(JrnlEntryItemObsoleteReason as fins_obs_reason) AS JrnlEntryItemObsoleteReason,
  case when SemanticTag = 'RECO_COS' then AmountInCompanyCodeCurrency end AS CostAmountInCompanyCodeCrcy,
  case when SemanticTag = 'RECO_COS' then AmountInGlobalCurrency end AS CostOfGoodsSoldAmtInGlobCrcy,
  case when SemanticTag = 'SALES_DED' then AmountInGlobalCurrency end AS SalesDeductionAmountInGlobCrcy,
  case when SemanticTag = 'SALES_DED' then AmountInCompanyCodeCurrency end AS SalesDeductionAmtInCoCodeCrcy,
  cast(0 as fis_reco_rev_hsl_p) AS PlnRecognizedRevnAmtInCCCrcy,
  cast(0 as fis_reco_rev_ksl_p) AS PlnRecgdRevenueAmtInGlobCrcy,
  cast(0 as fis_cost_hsl_p) AS PlnCostAmtInCompanyCodeCrcy,
  cast(0 as fis_cogs_ksl_p) AS PlnCostOfGdsSoldAmtInGlobCrcy,
  cast(0 as fis_rec_margin_hsl_p) AS PlnRecognizedMargAmtInCCCrcy,
  cast(0 as fis_rec_margin_hsl_p) AS PlnRecognizedMargAmtInGlobCrcy,
  cast(0 as fis_sales_ded_ksl_p) AS PlnSlsDeductionAmtInGlobCrcy,
  cast(0 as fis_res_masd_hsl_p) AS PlnSlsDeductionAmtInCCCrcy,
  cast(0 as fis_bill_rev_ksl_p) AS PlnBilledRevenueAmtInGlobCrcy,
  cast(0 as fis_bill_rev_hsl_p) AS PlnBilledRevenueAmtInCCCrcy,
  cast(cast( 'ACT01' as abap.char( 5 )) as fcom_category) AS PlanningCategory,
  cast(0 as fis_hsl) AS PlanAmountInCompanyCodeCrcy,
  cast(0 as fis_ksl) AS PlanAmountInGlobalCurrency,
  cast(0 as fis_wsl) AS PlanAmountInTransactionCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  cast(0 as fis_plan_osl) AS PlanAmountInFreeDefinedCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  cast(0 as fis_plan_vsl) AS PlanAmountInFreeDefinedCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  cast(0 as fis_plan_bsl) AS PlanAmountInFreeDefinedCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  cast(0 as fis_plan_csl) AS PlanAmountInFreeDefinedCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  cast(0 as fis_plan_dsl) AS PlanAmountInFreeDefinedCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  cast(0 as fis_plan_esl) AS PlanAmountInFreeDefinedCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  cast(0 as fis_plan_fsl) AS PlanAmountInFreeDefinedCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  cast(0 as fis_plan_gsl) AS PlanAmountInFreeDefinedCrcy8,
  BaseUnit,
  Quantity,
  '' AS IsSimulation,
  _Customer.AuthorizationGroup AS AuthorizationGroup
FROM I_GLAccountLineItemRawData AS _GL
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_SemTagFuncArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalCalendarDate AS _DocumentFiscalCalendarDate ON DocumentDate = _DocumentFiscalCalendarDate.CalendarDate AND FiscalYearVariant = _DocumentFiscalCalendarDate.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;