R_CustomerReturnTP

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 R_CustomerReturnTP.
-- 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 R_CustomerReturnTP AS
SELECT
  CustomerReturn.CustomerReturn AS CustomerReturn,
  CustomerReturn.CustomerReturnType AS CustomerReturnType,
  CustomerReturn.CustomerReturnDate AS CustomerReturnDate,
  CustomerReturn.SoldToParty AS SoldToParty,
  _SoldToParty.FullName AS CustomerName,
  _SoldToParty.AddressID AS SoldToPartyAddressID,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  _SlsOrganizationDistrChnl.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn.SalesOffice AS SalesOffice,
  CustomerReturn.SalesGroup AS SalesGroup,
  CustomerReturn.SalesDistrict AS SalesDistrict,
  CustomerReturn.CreationDate AS CreationDate,
  CustomerReturn.CreatedByUser AS CreatedByUser,
  CustomerReturn.LastChangedByUser AS LastChangedByUser,
  CustomerReturn.CreationTime AS CreationTime,
  CustomerReturn.LastChangeDate AS LastChangeDate,
  CustomerReturn.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturn.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  CustomerReturn.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  CustomerReturn.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  CustomerReturn.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  CustomerReturn.CorrespncExternalReference AS CorrespncExternalReference,
  CustomerReturn.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  CustomerReturn.CustomerGroup AS CustomerGroup,
  CustomerReturn.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  CustomerReturn.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  CustomerReturn.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  CustomerReturn.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  CustomerReturn.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  CustomerReturn.BillingDocumentDate AS BillingDocumentDate,
  CustomerReturn.BusinessSolutionOrder AS BusinessSolutionOrder,
  CustomerReturn.ControllingArea AS ControllingArea,
  CustomerReturn.CustomerPriceGroup AS CustomerPriceGroup,
  CustomerReturn.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  CustomerReturn.PriceListType AS PriceListType,
  CustomerReturn.ServicesRenderedDate AS ServicesRenderedDate,
  CustomerReturn.TaxDepartureCountry AS TaxDepartureCountry,
  CustomerReturn.VATRegistrationCountry AS VATRegistrationCountry,
  CustomerReturn.FixedValueDate AS FixedValueDate,
  cast(CustomerReturn.SDDocumentReason as vdm_return_order_reason preserving type) AS SDDocumentReason,
  CustomerReturn.PricingDate AS PricingDate,
  CustomerReturn.RequestedDeliveryDate AS RequestedDeliveryDate,
  CustomerReturn.TotalNetAmount AS TotalNetAmount,
  CustomerReturn.TransactionCurrency AS TransactionCurrency,
  CustomerReturn.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  CustomerReturn.DeliveryBlockReason AS DeliveryBlockReason,
  CustomerReturn.SDPricingProcedure AS SDPricingProcedure,
  CustomerReturn.IncotermsClassification AS IncotermsClassification,
  CustomerReturn.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerReturn.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturn.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturn.IncotermsVersion AS IncotermsVersion,
  CustomerReturn.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturn.PaymentMethod AS PaymentMethod,
  CustomerReturn.BillingCompanyCode AS BillingCompanyCode,
  CustomerReturn.CustomerTaxClassification1 AS CustomerTaxClassification1,
  CustomerReturn.CustomerTaxClassification2 AS CustomerTaxClassification2,
  CustomerReturn.CustomerTaxClassification3 AS CustomerTaxClassification3,
  CustomerReturn.CustomerTaxClassification4 AS CustomerTaxClassification4,
  CustomerReturn.CustomerTaxClassification5 AS CustomerTaxClassification5,
  CustomerReturn.CustomerTaxClassification6 AS CustomerTaxClassification6,
  CustomerReturn.CustomerTaxClassification7 AS CustomerTaxClassification7,
  CustomerReturn.CustomerTaxClassification8 AS CustomerTaxClassification8,
  CustomerReturn.CustomerTaxClassification9 AS CustomerTaxClassification9,
  CustomerReturn.AccountingDocExternalReference AS AccountingDocExternalReference,
  CustomerReturn.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  CustomerReturn.AssignmentReference AS AssignmentReference,
  CustomerReturn.ShippingType AS ShippingType,
  CustomerReturn.ShippingCondition AS ShippingCondition,
  CustomerReturn.CustomerReturnApprovalReason AS CustomerReturnApprovalReason,
  CustomerReturn.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  CustomerReturn.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturn.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturn.RetsMgmtProcess AS RetsMgmtProcess,
  _CustomerReturnType.RetsMgmtIsActive AS RetsMgmtIsActive,
  CustomerReturn.RetsMgmtLogProcgStatus AS RetsMgmtLogProcgStatus,
  CustomerReturn.RetsMgmtProcessingStatus AS RetsMgmtProcessingStatus,
  CustomerReturn.OverallSDProcessStatus AS OverallSDProcessStatus,
  CustomerReturn.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  CustomerReturn.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  CustomerReturn.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  cast(CustomerReturn.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast(CustomerReturn.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) AS OvrlItmGeneralIncompletionSts,
  OutputRequest.OutputRequestUUID AS OutputRequestUUID,
  CustomerReturn._CustomerReturnType AS _CustomerReturnType,
  CustomerReturn._SoldToParty AS _SoldToParty,
  CustomerReturn._SalesOrganization AS _SalesOrganization,
  CustomerReturn._DistributionChannel AS _DistributionChannel,
  CustomerReturn._OrganizationDivision AS _OrganizationDivision,
  CustomerReturn._SalesGroup AS _SalesGroup,
  CustomerReturn._SalesOffice AS _SalesOffice,
  CustomerReturn._ShippingCondition AS _ShippingCondition,
  CustomerReturn._SDDocumentReason AS _SDDocumentReason,
  CustomerReturn._TransactionCurrency AS _TransactionCurrency,
  CustomerReturn._CustRetApprovalReason AS _CustRetApprovalReason,
  CustomerReturn._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  CustomerReturn._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  CustomerReturn._RetsMgmtProcess AS _RetsMgmtProcess,
  CustomerReturn._OverallSDProcessStatus AS _OverallSDProcessStatus,
  CustomerReturn._OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus,
  CustomerReturn._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
  CustomerReturn._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  CustomerReturn._LastChangedByUser AS _LastChangedByUser,
  CustomerReturn._CreatedByUser AS _CreatedByUser,
  CustomerReturn._SDPricingProcedure AS _SDPricingProcedure,
  CustomerReturn._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  CustomerReturn._CustPurOrdTypeByShipToParty AS _CustPurOrdTypeByShipToParty,
  CustomerReturn._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  CustomerReturn._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  CustomerReturn._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  CustomerReturn._IncotermsClassification AS _IncotermsClassification,
  CustomerReturn._IncotermsVersion AS _IncotermsVersion,
  CustomerReturn._CustomerPaymentTerms AS _CustomerPaymentTerms,
  CustomerReturn._DeliveryBlockReason AS _DeliveryBlockReason,
  CustomerReturn._SalesDistrict AS _SalesDistrict
FROM I_CustomerReturnEnhanced AS CustomerReturn
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_CustomerReturnPartner AS _SoldToParty ON CustomerReturn = _SoldToParty.CustomerReturn AND _SoldToParty.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CustReturnSubsqntProcgSts AS _ReldForSubsqntProcgStatus ON CustomerReturn = _ReldForSubsqntProcgStatus.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN C_CustomerReturnRefundSts AS _CustRetRfndStatus ON CustomerReturn = _CustRetRfndStatus.CustomerReturn  -- association [0..1]
LEFT OUTER JOIN I_CustomerReturnType AS _CustomerReturnType ON CustomerReturnType = _CustomerReturnType.CustomerReturnType  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtCompnProcgStatus AS _RetsMgmtCompnProcgStatus ON RetsMgmtCompnProcgStatus = _RetsMgmtCompnProcgStatus.RetsMgmtCompnProcgStatus  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN R_CustomerReturnItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustomerReturnPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustomerReturnTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustomerReturnShipToPartyTP AS _ShipToParty ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_CustomerReturnPrgElmTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustReturnRelatedObjectTP AS _RelatedObject ON /* condition not available in parsed metadata */  -- association [0..*]
;