C_ReturnsReferenceDocument

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_ReturnsReferenceDocument.
-- 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 C_ReturnsReferenceDocument AS
SELECT
  ReferenceDocument.ReferenceSDDocument AS ReturnsReferenceDocument,
  ReferenceDocument.SDDocumentCategory AS SDDocumentCategory,
  ReferenceDocument.ReferenceSDDocumentType AS DocumentType,
  ReferenceDocument.DocumentTypeName AS DocumentTypeName,
  ReferenceDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ReferenceDocument.SoldToParty AS SoldToParty,
  ReferenceDocument.SoldToPartyName AS SoldToPartyName,
  ReferenceDocument.ShipToParty AS ShipToParty,
  ReferenceDocument.ShipToPartyName AS ShipToPartyName,
  ReferenceDocument.DocumentDate AS DocumentDate,
  ReferenceDocument.TotalNetAmount AS TotalNetAmount,
  ReferenceDocument.TransactionCurrency AS TransactionCurrency,
  ReferenceDocument.CreatedByUser AS CreatedByUser,
  ReferenceDocument.ResponsibleEmployee AS ResponsibleEmployee,
  ReferenceDocument.SalesOrganization AS SalesOrganization,
  ReferenceDocument.DistributionChannel AS DistributionChannel,
  ReferenceDocument.OrganizationDivision AS OrganizationDivision,
  ReferenceDocument.SalesGroup AS SalesGroup,
  ReferenceDocument.SalesOffice AS SalesOffice,
  ReferenceDocument.PricingDate AS PricingDate,
  ReferenceDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  ReferenceDocument.OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  '' AS CreateActionIsEnabled
FROM C_RetsReferenceDocumentUnion AS ReferenceDocument
LEFT OUTER JOIN C_ReturnsReferenceDocumentItem AS _ReturnRefDocItem ON ReturnsReferenceDocument = _ReturnRefDocItem.ReturnsReferenceDocument  -- association [0..*]
LEFT OUTER JOIN C_ShipToPartyValueHelp AS _ShipToPartyVH ON ShipToParty = _ShipToPartyVH.Customer  -- association [0..*]
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToPartyVH ON SoldToParty = _SoldToPartyVH.Customer  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatusVH ON OverallSDProcessStatus = _OverallSDProcessStatusVH.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN C_ReturnsRefDocUserValueHelp AS _CreatedByVH ON CreatedByUser = _CreatedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroupVH ON SalesGroup = _SalesGroupVH.SalesGroup  -- association [0..*]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOfficeVH ON SalesOffice = _SalesOfficeVH.SalesOffice  -- association [0..*]
LEFT OUTER JOIN C_RetsRefDocCategoryValueHelp AS _DocCategoryRefVH ON SDDocumentCategory = _DocCategoryRefVH.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_EmployeeValueHelp AS _EmplRespVH ON ResponsibleEmployee = _EmplRespVH.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannelVH ON SalesOrganization = _DistributionChannelVH.SalesOrganization AND DistributionChannel = _DistributionChannelVH.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _DivisionVH ON SalesOrganization = _DivisionVH.SalesOrganization AND DistributionChannel = _DivisionVH.DistributionChannel AND OrganizationDivision = _DivisionVH.Division  -- association [0..1]
LEFT OUTER JOIN C_ReturnsReferenceDocVH AS _ReferenceDocumentVH ON ReturnsReferenceDocument = _ReferenceDocumentVH.ReferenceSDDocument  -- association [0..*]
LEFT OUTER JOIN C_RetsRefDocItemAttribute AS _RetsRefDocItemAttribute ON ReturnsReferenceDocument = _RetsRefDocItemAttribute.ReferenceDocument  -- association [0..*]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployeeText ON ResponsibleEmployee = _ResponsibleEmployeeText.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON _SoldToParty.Customer = ReferenceDocument.SoldToParty  -- association [0..1]
;