C_RU_ImportNotifRegisterC

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 C_RU_ImportNotifRegisterC.
-- 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: CRURINCUBE
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_RU_ImportNotifRegisterC AS
SELECT
  VATReturnOperation,
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS TaxTransferDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  INHeaderData.RU_ImprtNotifExternalNumber AS RU_ImprtNotifExternalNumber,
  INHeaderData.RU_ImprtNotifInternalNumber AS RU_ImprtNotifInternalNumber,
  INHeaderData.RU_ImprtNotifRegistrationDate AS RU_ImprtNotifRegistrationDate,
  INHeaderData.RU_ImportNotifSellerSection AS RU_ImportNotifSellerSection,
  INHeaderData.AssignmentReference AS AssignmentReference,
  Contract.ExternalContractNumber AS ExternalContractNumber,
  Contract.ExternalContractDate AS ExternalContractDate,
  INHeaderData.Customer AS Customer,
  Customer.CustomerName AS CustomerName,
  Customer.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  CustomerCountry.CountryThreeDigitISOCode AS CountryThreeDigitISOCode,
  INItemData.RU_ImportNotificationItem AS RU_ImportNotificationItem,
  INItemData.BillingDocument AS BillingDocument,
  INItemData.BillingDocumentItem AS BillingDocumentItem,
  INItemData.DeliveryDocument AS DeliveryDocument,
  INItemData.DeliveryDocumentItem AS DeliveryDocumentItem,
  INItemData.Material AS Material,
  _MaterialDescription.ProductDescription AS MaterialDesc,
  INItemData.Quantity AS Quantity,
  INItemData.UnitOfMeasure AS UnitOfMeasure,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_RU_ImportNotifRegRptItem AS RegisterItems
LEFT OUTER JOIN I_ProductDescription AS _MaterialDescription ON Material = _MaterialDescription.Product AND _MaterialDescription.Language = $session.system_language  -- association [0..1]
;