I_DebitMemoRequest

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 I_DebitMemoRequest.
-- 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: ISDDEBITMEMOREQ

CREATE VIEW I_DebitMemoRequest AS
SELECT
  cast(SalesDocument as debit_memo_request preserving type) AS DebitMemoRequest,
  cast(SalesDocumentType as debit_memo_request_type preserving type ) AS DebitMemoRequestType,
  SalesDocumentProcessingType AS DebitMemoRequestProcessingType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  SalesDocumentDate AS DebitMemoRequestDate,
  ServicesRenderedDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  SalesDistrict,
  TotalNetAmount,
  TransactionCurrency,
  SDPricingProcedure,
  PricingDate,
  SalesDocumentCondition AS DebitMemoRequestCondition,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  cast(SalesDocApprovalReason as sd_dmr_approval_reason) AS DebitMemoReqApprovalReason,
  BillingDocumentDate,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FiscalYear,
  FiscalPeriod,
  ExchangeRateDate,
  ExchangeRateType,
  cast(AccountingExchangeRate as kurrf_not_converted preserving type ) AS AccountingExchangeRate,
  BusinessArea,
  CustomerAccountAssignmentGroup,
  CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  OrderID,
  ControllingObject,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallOrdReltdBillgStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  SalesDocApprovalStatus,
  AccountingDocExternalReference,
  AssignmentReference
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _CostCenterBusinessAreaText ON CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea association[0..*] to I_DebitMemoRequestItem as _Item on DebitMemoRequest = _Item.DebitMemoRequest association[0..1] to I_DebitMemoRequestType as _DebitMemoRequestType on DebitMemoRequestType = _DebitMemoRequestType.DebitMemoRequestType association[1..*] to I_DebitMemoReqPartner as _Partner on DebitMemoRequest = _Partner.DebitMemoRequest  -- association [0..*]
LEFT OUTER JOIN I_DebitMemoReqApprovalReason AS _DebitMemoReqApprovalReason ON DebitMemoReqApprovalReason = _DebitMemoReqApprovalReason.DebitMemoReqApprovalReason association[0..*] to I_DebitMemoReqPrcgElmnt as _PricingElement on DebitMemoRequest = _PricingElement.DebitMemoRequest  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;