C_CustomerReturnOPg

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_CustomerReturnOPg.
-- 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_CustomerReturnOPg AS
SELECT
  CustomerReturn.CustomerReturn AS CustomerReturn,
  CustomerReturn.CustomerReturnType AS CustomerReturnType,
  _CustomerReturnType.RetsMgmtIsActive AS RetsMgmtIsActive,
  case when CustomerReturn.ReferenceSDDocumentCategory = 'C' then CustomerReturn.ReferenceSDDocument end as SalesDocument AS ReferenceSDDocumentendasSalesDocument,
  case when CustomerReturn.ReferenceSDDocumentCategory = 'M' then CustomerReturn.ReferenceSDDocument end as BillingDocument AS ReferenceSDDocumentendasBillingDocument,
  CustomerReturn.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  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,
  CustomerReturn.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CustomerReturn._SalesDocApprovalStatus._Text[1: Language=$session.system_language].SalesDocApprovalStatusDesc AS SalesDocApprovalStatusDesc,
  SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast(_Partner[PartnerFunction='WE'].Customer as kunwe) AS ShipToParty,
  CustomerReturn.ShippingCondition AS ShippingCondition,
  _Partner[PartnerFunction='WE'].AddressID AS AddressID,
  _Partner[PartnerFunction='WE'].AddressPersonID AS AddressPersonID,
  cast('' as ad_namtext ) AS ShipToPartyName,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.PostalCode AS DeliveryAddressPostalCode,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.CityName AS ShipToPartyCityName,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.Country AS ShipToPartyCountry,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.StreetName AS DeliveryAddressStreetName,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.HouseNumber AS DeliveryAddressHouseNumber,
  _Partner[PartnerFunction='WE']._OrgNamePostalAddress.HouseNumberSupplementText AS ShipToPtyHouseNmbrSuplmntText,
  CustomerReturn.LastChangeDate AS LastChangeDate,
  CustomerReturn.LastChangeDateTime AS LastChangeDateTime,
  CustomerReturn.CreatedByUser AS CreatedByUser,
  CustomerReturn.CustomerReturnDate AS CustomerReturnDate,
  CustomerReturn.PricingDate AS PricingDate,
  cast (CustomerReturn.SDDocumentReason as returns_order_reason) AS ReturnsOrderReason,
  _SDDocumentReason._Text[1: Language=$session.system_language].SDDocumentReasonText AS SDDocumentReasonText,
  CustomerReturn.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SDDocumentCategoryText[1: Language=$session.system_language].SDDocumentCategoryName AS SDDocumentCategoryName,
  CustomerReturn.ReferenceSDDocument AS ReferenceSDDocument,
  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,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn.SalesOffice AS SalesOffice,
  CustomerReturn.SalesGroup AS SalesGroup,
  cast(_Partner[PartnerFunction='ZM'].Personnel as resp_empl preserving type ) AS ResponsibleEmployee,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  CustomerReturn.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CustomerReturn.TotalNetAmount AS TotalNetAmount,
  CustomerReturn.TransactionCurrency AS TransactionCurrency,
  cast('' as objky) AS LinkedSAPObjectKey,
  _ReldForSubsqntProcgSts.OvrlReldForSubsqntProcgSts AS OvrlReldForSubsqntProcgSts,
  '' AS ReturnActionIsEnabled,
  cast('' as boolean preserving type) AS IsValid,
  CustomerReturn._TransactionCurrency AS _TransactionCurrency
FROM I_CustomerReturn AS CustomerReturn
LEFT OUTER JOIN C_CustomerReturnItemOPg AS _CustomerReturnItem ON CustomerReturn = _CustomerReturnItem.CustomerReturn  -- association [0..*]
LEFT OUTER JOIN C_CustomerReturnRefDoc AS _ReturnRefDoc ON CustomerReturn = _ReturnRefDoc.CustomerReturn AND SalesOrganization = _ReturnRefDoc.SalesOrganization AND DistributionChannel = _ReturnRefDoc.DistributionChannel AND OrganizationDivision = _ReturnRefDoc.OrganizationDivision  -- association [0..*]
LEFT OUTER JOIN C_CustomerReturnRefDocItem AS _ReturnRefDocItem ON CustomerReturn = _ReturnRefDocItem.CustomerReturn AND SalesOrganization = _ReturnRefDocItem.SalesOrganization AND DistributionChannel = _ReturnRefDocItem.DistributionChannel AND OrganizationDivision = _ReturnRefDocItem.OrganizationDivision  -- association [0..*]
LEFT OUTER JOIN C_CustomerReturnItemRefund AS _CustRetItemRefund ON CustomerReturn = _CustRetItemRefund.CustomerReturn  -- association [0..*]
LEFT OUTER JOIN C_InternalContacts AS _InternalContacts ON CustomerReturn = _InternalContacts.SDDocument  -- association [0..*]
LEFT OUTER JOIN C_ExternalContacts AS _ExternalContacts ON CustomerReturn = _ExternalContacts.SDDocument  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentCustomer AS _BusinessPartners ON CustomerReturn = _BusinessPartners.SDDocument  -- association [0..*]
LEFT OUTER JOIN I_CustReturnSubsqntProcgSts AS _ReldForSubsqntProcgSts ON CustomerReturn = _ReldForSubsqntProcgSts.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN C_SlsDocPaymentPlanItem AS _PaymentPlanItemDetails ON CustomerReturn = _PaymentPlanItemDetails.SalesDocument  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentCustomerVH AS _ShipToPartyVH ON ShipToParty = _ShipToPartyVH.Customer AND addressid = _ShipToPartyVH.AddressID  -- association [0..1]
LEFT OUTER JOIN C_EmployeeValueHelp AS _EmplResp_VH ON ResponsibleEmployee = _EmplResp_VH.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON ReferenceSDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON CustomerReturnType = _SalesDocumentTypeText.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_OverallSDDocumentRjcnStatusT AS _OverallSDDocumentRejectionSts ON OverallSDDocumentRejectionSts = _OverallSDDocumentRejectionSts.OverallSDDocumentRejectionSts  -- association [0..*]
LEFT OUTER JOIN I_ShippingConditionText AS _ShippingConditionText ON ShippingCondition = _ShippingConditionText.ShippingCondition  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentIncompletionLog AS _IncompletionLog ON CustomerReturn = _IncompletionLog.SDDocument  -- association [0..*]
;