I_CreditMemoRequestItemCube

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 I_CreditMemoRequestItemCube.
-- 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.
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_CreditMemoRequestItemCube AS
SELECT
  cast(SDIA.SalesDocument as credit_memo_request preserving type) AS CreditMemoRequest,
  cast(SDIA.SalesDocumentItem as credit_memo_request_item preserving type) AS CreditMemoRequestItem,
  SDIA.SalesDocumentType AS CreditMemoRequestType,
  SDIA.SalesDocumentItemCategory AS CreditMemoRequestItemCategory,
  SDIA._ItemCategory AS _ItemCategory,
  SDIA.SalesDocumentItemType AS CreditMemoRequestItemType,
  SDIA.CreatedByUser AS CreatedByUser,
  SDIA._CreatedByUser AS _CreatedByUser,
  SDIA.CreationDate AS CreationDate,
  SDIA.CreationTime AS CreationTime,
  SDIA.LastChangeDate AS LastChangeDate,
  cast(CalendarDate.CalendarYear as creation_date_year) AS CreationDateYear,
  cast(CalendarDate.YearQuarter as creation_date_year_quarter) AS CreationDateYearQuarter,
  cast(CalendarDate.YearMonth as creation_date_year_month) AS CreationDateYearMonth,
  SDIA.SalesOrganization AS SalesOrganization,
  SDIA._SalesOrganization AS _SalesOrganization,
  SDIA.DistributionChannel AS DistributionChannel,
  SDIA._DistributionChannel AS _DistributionChannel,
  cast(SDIA.OrganizationDivision as organization_division preserving type) AS OrganizationDivision,
  SDIA._OrganizationDivision AS _OrganizationDivision,
  SDIA.Division AS Division,
  SDIA._Division AS _Division,
  SDIA.SalesOffice AS SalesOffice,
  SDIA._SalesOffice AS _SalesOffice,
  SDIA.SalesGroup AS SalesGroup,
  SDIA._SalesGroup AS _SalesGroup,
  SDIA._SoldToParty.TradingPartner AS PartnerCompany,
  SDIA._SoldToParty._GlobalCompany AS _GlobalCompany,
  SDIA.SoldToParty AS SoldToParty,
  SDIA._SoldToParty AS _SoldToParty,
  SDIA.SDDocumentReason AS SDDocumentReason,
  SDIA._SDDocumentReason AS _SDDocumentReason,
  SDIA.SalesDocumentItemText AS CreditMemoRequestItemText,
  SDIA.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SDIA.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SDIA.CustomerGroup AS CustomerGroup,
  SDIA._CustomerGroup AS _CustomerGroup,
  SDIA.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SDIA._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SDIA.Material AS Material,
  SDIA._Material AS _Material,
  SDIA.Product AS Product,
  SDIA._Product AS _Product,
  SDIA.MaterialGroup AS MaterialGroup,
  SDIA._MaterialGroup AS _MaterialGroup,
  SDIA.ProductGroup AS ProductGroup,
  SDIA._ProductGroup AS _ProductGroup,
  SDIA.Plant AS Plant,
  SDIA._Plant AS _Plant,
  SDIA.ItemGrossWeight AS ItemGrossWeight,
  SDIA.ItemNetWeight AS ItemNetWeight,
  SDIA.ItemWeightUnit AS ItemWeightUnit,
  SDIA._ItemWeightUnit AS _ItemWeightUnit,
  SDIA.ItemVolume AS ItemVolume,
  SDIA.ItemVolumeUnit AS ItemVolumeUnit,
  SDIA._ItemVolumeUnit AS _ItemVolumeUnit,
  SDIA.MainItemPricingRefProduct AS MainItemPricingRefProduct,
  SDIA.HigherLevelItem AS HigherLevelItem,
  SDIA.BillOfMaterial AS BillOfMaterial,
  SDIA.PropagatePrftbltySgmt2BOM AS PropagatePrftbltySgmt2BOM,
  SDIA.CostDeterminationIsRequired AS CostDeterminationIsRequired,
  SDIA.TaxAmount AS TaxAmount,
  SDIA.CostAmount AS CostAmount,
  SDIA.Subtotal1Amount AS Subtotal1Amount,
  SDIA.Subtotal2Amount AS Subtotal2Amount,
  SDIA.Subtotal3Amount AS Subtotal3Amount,
  SDIA.Subtotal4Amount AS Subtotal4Amount,
  SDIA.Subtotal5Amount AS Subtotal5Amount,
  SDIA.Subtotal6Amount AS Subtotal6Amount,
  SDIA.BillingCompanyCode AS BillingCompanyCode,
  SDIA._BillingCompanyCode AS _BillingCompanyCode,
  SDIA.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SDIA._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  cast(SDIA.ItemBillingBlockReason as billing_block_reason_item preserving type) AS ItemBillingBlockReason,
  SDIA._ItemBillingBlockReason AS _ItemBillingBlockReason,
  SDIA.CustomerPaymentTerms AS CustomerPaymentTerms,
  SDIA._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SDIA.PaymentMethod AS PaymentMethod,
  SDIA.BusinessArea AS BusinessArea,
  SDIA._BusinessArea AS _BusinessArea,
  cast(SDIA.SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  SDIA._SDProcessStatus AS _SDProcessStatus,
  SDIA.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SDIA._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SDIA.BillingBlockStatus AS BillingBlockStatus,
  SDIA._BillingBlockStatus AS _BillingBlockStatus,
  SDIA.BusinessSolutionOrder AS BusinessSolutionOrder,
  SDIA.BaseUnit AS BaseUnit,
  SDIA._BaseUnit AS _BaseUnit,
  SDIA.TransactionCurrency AS TransactionCurrency,
  SDIA._TransactionCurrency AS _TransactionCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  SDIA.NetAmount AS NetAmount,
  cast( SDIA.NetAmount as credit_memo_request_net_amt preserving type ) AS CreditMemoRequestNetAmount,
  CreditMemoRequestQuantity,
  NumberOfCreditMemoRequestItems
FROM I_SalesDocumentItemAnalytics AS SDIA
LEFT OUTER JOIN I_CreditMemoRequest AS _CreditMemoRequest ON CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest  -- association [1..1]
LEFT OUTER JOIN I_CreditMemoRequestType AS _CreditMemoRequestType ON CreditMemoRequestType = _CreditMemoRequestType.CreditMemoRequestType  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CreditMemoRequest = _Extension.SalesDocument AND CreditMemoRequestItem = _Extension.SalesDocumentItem  -- association [0..1]
;