C_Customerreturnfs

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_Customerreturnfs.
-- 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: CCUSTRETURNFS

CREATE VIEW C_Customerreturnfs AS
SELECT
  Return.CustomerReturn AS CustomerReturn,
  concat_with_space(_CustomerReturnType._Text[1: Language=$session.system_language].SalesDocumentTypeName, ltrim(CustomerReturn, '0'), 1) AS SalesDocumentTypeName,
  Return.CustomerReturnType AS CustomerReturnType,
  Return.SoldToParty AS SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyName,
  Return.OverallSDProcessStatus AS OverallSDProcessStatus,
  Return.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  Return.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  Return.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  Return.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  Return.CustomerReturnApprovalReason AS CustomerReturnApprovalReason,
  _CustRetApprovalReason._SDApprovalReasonT[1: Language=$session.system_language].SDApprovalReasonName AS SDApprovalReasonName,
  Return.TotalNetAmount AS TotalNetAmount,
  Return.TransactionCurrency AS TransactionCurrency,
  cast( concat_with_space( concat( concat( Return._SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName, concat_with_space(',',Return._DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName,1) ), ',' ), Return._OrganizationDivision._Text[1: Language=$session.system_language].DivisionName ,1) as txt_vtrber) as SalesAreaDesc AS DivisionName1astxt_vtrberasSalesAreaDesc,
  Return.SalesOrganization AS SalesOrganization,
  Return.DistributionChannel AS DistributionChannel,
  Return.OrganizationDivision AS OrganizationDivision,
  cast(_ResponsibleEmployee.Personnel as resp_empl preserving type ) AS ResponsibleEmployee,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  Return.SDDocumentReason AS SDDocumentReason,
  Return.CustomerReturnDate AS CustomerReturnDate,
  Return.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  Return.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  Return.CreatedByUser AS CreatedByUser,
  Return._CreatedByUser.UserDescription AS CreatedByUserDescription,
  Return.CreationDate AS CreationDate,
  Return.LastChangedByUser AS LastChangedByUser,
  Return._LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  _ShipToParty.Customer AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  cast( '' as boolean preserving type ) AS IsValid
FROM I_CustomerReturn AS Return
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToPartyVH ON SoldToParty = _SoldToPartyVH.Customer  -- association [0..1]
LEFT OUTER JOIN C_Customerreturnitemfs AS _Item ON CustomerReturn = _Item.CustomerReturn  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON CustomerReturn = _SDDocumentPartnerCard.SDDocument AND _SDDocumentPartnerCard.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_SlsDocPaymentPlanItem AS _SlsDocPaymentPlanItem ON CustomerReturn = _SlsDocPaymentPlanItem.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCustomer AS _ShipToParty ON CustomerReturn = _ShipToParty.SDDocument AND _ShipToParty.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentPersonnel AS _EmployeeResponsible ON CustomerReturn = _EmployeeResponsible.SDDocument AND _EmployeeResponsible.PartnerFunction = 'ZM'  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentPartner AS _ResponsibleEmployee ON CustomerReturn = _ResponsibleEmployee.SalesDocument AND _ResponsibleEmployee.PartnerFunction = 'ZM'  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument  -- association [0..1]
;