R_DebitMemoRequestTP

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_DebitMemoRequestTP.
-- 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_DebitMemoRequestTP AS
SELECT
  DebitMemoRequest.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  DebitMemoRequest.DebitMemoRequestDate AS DebitMemoRequestDate,
  DebitMemoRequest.ControllingArea AS ControllingArea,
  DebitMemoRequest.SoldToParty AS SoldToParty,
  _SoldToParty._DfltAddrRprstn.AddresseeFullName AS CustomerName,
  _Payer.Customer AS PayerParty,
  DebitMemoRequest.SalesOrganization AS SalesOrganization,
  DebitMemoRequest.DistributionChannel AS DistributionChannel,
  DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  _SlsOrganizationDistrChnl.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  DebitMemoRequest.SalesOffice AS SalesOffice,
  DebitMemoRequest.SalesGroup AS SalesGroup,
  DebitMemoRequest.SalesDistrict AS SalesDistrict,
  DebitMemoRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  DebitMemoRequest.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  DebitMemoRequest.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  DebitMemoRequest.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  DebitMemoRequest.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  DebitMemoRequest.CorrespncExternalReference AS CorrespncExternalReference,
  DebitMemoRequest.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  DebitMemoRequest.CustomerGroup AS CustomerGroup,
  DebitMemoRequest.SDDocumentReason AS SDDocumentReason,
  DebitMemoRequest.PricingDate AS PricingDate,
  DebitMemoRequest.TotalNetAmount AS TotalNetAmount,
  DebitMemoRequest.TransactionCurrency AS TransactionCurrency,
  DebitMemoRequest.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  DebitMemoRequest.SDPricingProcedure AS SDPricingProcedure,
  DebitMemoRequest.CustomerPriceGroup AS CustomerPriceGroup,
  DebitMemoRequest.PriceListType AS PriceListType,
  DebitMemoRequest.IncotermsClassification AS IncotermsClassification,
  DebitMemoRequest.IncotermsVersion AS IncotermsVersion,
  DebitMemoRequest.IncotermsLocation1 AS IncotermsLocation1,
  DebitMemoRequest.IncotermsLocation2 AS IncotermsLocation2,
  DebitMemoRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  DebitMemoRequest.BillingCompanyCode AS BillingCompanyCode,
  DebitMemoRequest.PaymentMethod AS PaymentMethod,
  DebitMemoRequest.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  DebitMemoRequest.AssignmentReference AS AssignmentReference,
  DebitMemoRequest.AccountingDocExternalReference AS AccountingDocExternalReference,
  DebitMemoRequest.BillingDocumentDate AS BillingDocumentDate,
  DebitMemoRequest.ServicesRenderedDate AS ServicesRenderedDate,
  DebitMemoRequest.ReferenceSDDocument AS ReferenceSDDocument,
  DebitMemoRequest.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  DebitMemoRequest.CreatedByUser AS CreatedByUser,
  DebitMemoRequest.CreationDate AS CreationDate,
  DebitMemoRequest.CreationTime AS CreationTime,
  DebitMemoRequest.LastChangedByUser AS LastChangedByUser,
  DebitMemoRequest.LastChangeDate AS LastChangeDate,
  DebitMemoRequest.DebitMemoReqApprovalReason AS DebitMemoReqApprovalReason,
  DebitMemoRequest.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  DebitMemoRequest.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  DebitMemoRequest.OverallSDProcessStatus AS OverallSDProcessStatus,
  DebitMemoRequest.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  DebitMemoRequest.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  DebitMemoRequest.TotalBlockStatus AS TotalBlockStatus,
  DebitMemoRequest.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  DebitMemoRequest.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  DebitMemoRequest.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  DebitMemoRequest.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  OutputRequest.OutputRequestUUID AS OutputRequestUUID,
  DebitMemoRequest._DebitMemoRequestType AS _DebitMemoRequestType,
  DebitMemoRequest._SalesOrganization AS _SalesOrganization,
  DebitMemoRequest._DistributionChannel AS _DistributionChannel,
  DebitMemoRequest._OrganizationDivision AS _OrganizationDivision,
  DebitMemoRequest._SalesOffice AS _SalesOffice,
  DebitMemoRequest._SalesGroup AS _SalesGroup,
  DebitMemoRequest._SalesDistrict AS _SalesDistrict,
  DebitMemoRequest._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  DebitMemoRequest._CustPurOrdTypeByShipToParty AS _CustPurOrdTypeByShipToParty,
  DebitMemoRequest._CustomerGroup AS _CustomerGroup,
  DebitMemoRequest._SDDocumentReason AS _SDDocumentReason,
  DebitMemoRequest._TransactionCurrency AS _TransactionCurrency,
  DebitMemoRequest._IncotermsClassification AS _IncotermsClassification,
  DebitMemoRequest._IncotermsVersion AS _IncotermsVersion,
  DebitMemoRequest._CustomerPaymentTerms AS _CustomerPaymentTerms,
  DebitMemoRequest._BillingCompanyCode AS _BillingCompanyCode,
  DebitMemoRequest._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  DebitMemoRequest._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  DebitMemoRequest._DebitMemoReqApprovalReason AS _DebitMemoReqApprovalReason,
  DebitMemoRequest._OverallSDProcessStatus AS _OverallSDProcessStatus,
  DebitMemoRequest._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  DebitMemoRequest._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
  DebitMemoRequest._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  DebitMemoRequest._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  DebitMemoRequest._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
  DebitMemoRequest._TotalBlockStatus AS _TotalBlockStatus,
  DebitMemoRequest._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  DebitMemoRequest._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  DebitMemoRequest._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  DebitMemoRequest._ControllingArea AS _ControllingArea,
  DebitMemoRequest._LastChangedByUser AS _LastChangedByUser,
  DebitMemoRequest._CreatedByUser AS _CreatedByUser,
  DebitMemoRequest._SDPricingProcedure AS _SDPricingProcedure,
  DebitMemoRequest._CustomerPriceGroup AS _CustomerPriceGroup,
  DebitMemoRequest._PriceListType AS _PriceListType,
  DebitMemoRequest._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup
FROM I_DebitMemoRequest AS DebitMemoRequest
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- 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_DebitMemoReqPartner AS _SoldToParty ON DebitMemoRequest = _SoldToParty.DebitMemoRequest AND _SoldToParty.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_DebitMemoReqPartner AS _Payer ON DebitMemoRequest = _Payer.DebitMemoRequest AND _Payer.PartnerFunction = 'RG'  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON DebitMemoRequest = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN R_DebitMemoRequestItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DebitMemoRequestPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DebitMemoRequestPrcgElmntTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DebitMemoRequestTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;