C_CustomerReturn

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_CustomerReturn.
-- 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_CustomerReturn AS
SELECT
  cast (CustomerReturn.CustomerReturn as msr_returns_order preserving type) AS CustomerReturn,
  cast (CustomerReturn.CustomerReturnType as msr_returns_order_type preserving type) AS CustomerReturnType,
  cast('' as ad_namtext ) AS SoldToPartyName,
  CustomerReturn._SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  CustomerReturn._SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  CustomerReturn._Partner[PartnerFunction='AG'].AddressID AS SoldToPartyAddressID,
  cast (_SDDocumentCategoryText.SDDocumentCategoryName as sd_ref_doc_cat_desc) AS ReferenceDocumentCategoryName,
  cast('' as msr_ret_reason_text ) AS ReturnReason,
  cast('' as refund_progress) AS CustReturnRefundStatus,
  cast('' as val_text) AS CustReturnRefundStatusDesc,
  cast (CustomerReturn.SDDocumentReason as returns_order_reason) AS ReturnsOrderReason,
  _SDDocumentReason._Text[1: Language=$session.system_language].SDDocumentReasonText AS SDDocumentReasonText,
  cast('' as return_log_procg_status) AS RetsMgmtLogProcgStatus,
  cast('' as val_text) AS RetsMgmtLogProcgStatusDesc,
  cast('' as msr_fin_status) AS RetsMgmtCompnProcgStatus,
  cast('' as val_text) AS RetsMgmtCompnProcgStatusDesc,
  cast('' as msr_proc_status) AS RetsMgmtProcessingStatus,
  cast('' as val_text) AS RetsMgmtProcessingStatusDesc,
  cast('' as cust_ret_rel_status) AS OvrlReldForSubsqntProcgSts,
  cast('' as val_text) AS OvrlReldForSubsqntProcgStsDesc,
  CustomerReturn._CustRetApprovalReason._SDApprovalReason.WorkflowIsExternal AS WorkflowIsExternal,
  CustomerReturn._SalesDocApprovalStatus._Text[1: Language=$session.system_language].SalesDocApprovalStatusDesc AS SalesDocApprovalStatusDesc,
  case when CustomerReturn.LastChangeDate = '00000000' then CustomerReturn.CreationDate else CustomerReturn.LastChangeDate end as LastChangeDate AS LastChangeDateendasLastChangeDate,
  CreatedByUser,
  LastChangedByUser,
  cast( concat_with_space( concat( concat( CustomerReturn._SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName, concat_with_space(',',CustomerReturn._DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName,1) ), ',' ), CustomerReturn._OrganizationDivision._Text[1: Language=$session.system_language].DivisionName ,1) as txt_vtrber) as SalesAreaDesc AS DivisionName1astxt_vtrberasSalesAreaDesc,
  concat( concat( CustomerReturn.SalesOrganization, CustomerReturn.DistributionChannel ), CustomerReturn.OrganizationDivision ) as SalesArea AS OrganizationDivisionasSalesArea,
  cast (CustomerReturn._Partner[PartnerFunction = 'ZM'].Personnel as resp_empl) AS ResponsibleEmployee,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  cast (CustomerReturn._Partner[PartnerFunction='WE'].Customer as kunwe) AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  CustomerReturn._Partner[PartnerFunction='WE'].AddressID AS AddressID,
  RetsMgmtProcess,
  CustomerReturn.SoldToParty AS SoldToParty,
  CustomerReturn.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturn.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturn.OverallTotalDeliveryStatus AS OverallDeliveryStatus,
  CustomerReturn.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  CustomerReturn.OverallSDProcessStatus AS OverallSDProcessStatus,
  CustomerReturn.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CustomerReturn.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CustomerReturn.CustomerReturnDate AS CustomerReturnDate,
  CustomerReturn.CreationDate AS CreationDate,
  CustomerReturn.LastChangeDateTime AS LastChangeDateTime,
  CustomerReturn.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  CustomerReturn.SalesOffice AS SalesOffice,
  CustomerReturn.SalesGroup AS SalesGroup,
  CustomerReturn.TotalNetAmount AS TotalNetAmount,
  CustomerReturn.TransactionCurrency AS TransactionCurrency,
  _ChangedByVH.UserDescription AS LastChangedByUserName,
  _CreatedByVH.UserDescription AS CreatedByUserName,
  _CustomerReturnType.RetsMgmtIsActive AS RetsMgmtIsActive,
  _SalesDocumentTypeText.SalesDocumentTypeName AS SalesDocumentTypeName,
  _SoldToParty.CustomerClassification AS CustomerClassification,
  _SoldToParty._CustomerClassification AS _CustomerClassification
FROM I_CustomerReturn AS CustomerReturn
LEFT OUTER JOIN C_CustomerReturnRefundSts AS _CustRetRfndStatus ON CustomerReturn = _CustRetRfndStatus.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN I_CustReturnSubsqntProcgSts AS _ReldForSubsqntProcgStatus ON CustomerReturn = _ReldForSubsqntProcgStatus.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN C_Overallsddocumentrjcnstatus AS _OverallSDDocumentRjcnStsVH ON OverallSDDocumentRejectionSts = _OverallSDDocumentRjcnStsVH.OverallSDDocumentRejectionSts  -- association [0..1]
LEFT OUTER JOIN C_ShipToPartyValueHelp AS _ShipToPartyVH ON ShipToParty = _ShipToPartyVH.Customer AND addressid = _ShipToPartyVH.AddressID  -- association [0..1]
LEFT OUTER JOIN C_EmployeeValueHelp AS _EmplRespVH ON ResponsibleEmployee = _EmplRespVH.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN C_ReturnsReferenceDocVH AS _ReferenceDocumentVH ON ReferenceSDDocument = _ReferenceDocumentVH.ReferenceSDDocument  -- association [0..*]
LEFT OUTER JOIN C_RetsRefDocCategoryValueHelp AS _RetsRefDocCategoryVH ON ReferenceSDDocumentCategory = _RetsRefDocCategoryVH.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByVH ON CreatedByUser = _CreatedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _ChangedByVH ON LastChangedByUser = _ChangedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_CustRetReleaseStatusVH AS _ReleaseStatusVH ON OvrlReldForSubsqntProcgSts = _ReleaseStatusVH.CustRetReleaseStatus  -- association [0..1]
LEFT OUTER JOIN C_CustRetRefundProgressVH AS _RefundProgressVH ON CustReturnRefundStatus = _RefundProgressVH.CustRetRefundProgress  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatus AS _ProcessingStatusVH ON RetsMgmtProcessingStatus = _ProcessingStatusVH.RetsMgmtProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatus AS _LogisticalStatusVH ON RetsMgmtLogProcgStatus = _LogisticalStatusVH.RetsMgmtProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtCompnProcgStatus AS _RefundStatusVH ON RetsMgmtCompnProcgStatus = _RefundStatusVH.RetsMgmtCompnProcgStatus  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOfficeVH ON SalesOffice = _SalesOfficeVH.SalesOffice AND SalesOrganization = _SalesOfficeVH.SalesOrganization AND DistributionChannel = _SalesOfficeVH.DistributionChannel AND OrganizationDivision = _SalesOfficeVH.OrganizationDivision  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroupVH ON SalesGroup = _SalesGroupVH.SalesGroup AND SalesOffice = _SalesGroupVH.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_CustomerReturnTypeVH AS _CustomerReturnTypeVH ON CustomerReturnType = _CustomerReturnTypeVH.CustomerReturnType  -- association [0..1]
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToPartyVH ON SoldToParty = _SoldToPartyVH.Customer  -- 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 I_CustRetReleaseStatusText AS _ReleaseStatus ON OvrlReldForSubsqntProcgSts = _ReleaseStatus.CustRetReleaseStatus AND _ReleaseStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustRetRefundPrgrsStatusText AS _RefundProgress ON CustReturnRefundStatus = _RefundProgress.CustRetRefundProgress AND _RefundProgress.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatusText AS _RetsMgmtProcgStatusText ON RetsMgmtProcessingStatus = _RetsMgmtProcgStatusText.RetsMgmtProcessingStatus AND _RetsMgmtProcgStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatusText AS _RetsMgmtLogProcgStatusText ON RetsMgmtLogProcgStatus = _RetsMgmtLogProcgStatusText.RetsMgmtProcessingStatus AND _RetsMgmtLogProcgStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtCompnProcgStatusText AS _RetsMgmtCompnProcgStatusText ON RetsMgmtCompnProcgStatus = _RetsMgmtCompnProcgStatusText.RetsMgmtCompnProcgStatus AND _RetsMgmtCompnProcgStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatusText AS _OverallSDProcessStatusText ON OverallSDProcessStatus = _OverallSDProcessStatusText.OverallSDProcessStatus AND _OverallSDProcessStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON CustomerReturnType = _SalesDocumentTypeText.SalesDocumentType AND _SalesDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON ReferenceSDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory AND _SDDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _Employment ON ResponsibleEmployee = _Employment.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN C_CustRetProcgStatus AS _RetsMgmtProcessWthProcgSts ON CustomerReturn = _RetsMgmtProcessWthProcgSts.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentItemWl AS _SalesDocumentItemWl ON CustomerReturn = _SalesDocumentItemWl.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument  -- association [0..1]
;