C_MassChgDebitMemoReqItem

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_MassChgDebitMemoReqItem.
-- 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: CSDMCDBMEREQITM

CREATE VIEW C_MassChgDebitMemoReqItem AS
SELECT
  cast (DebitMemoRequestItem.SalesDocument as debit_memo_request preserving type) AS DebitMemoRequest,
  SalesOrganization,
  DistributionChannel,
  SoldToParty,
  Product,
  cast(SalesDocumentType as debit_memo_request_type preserving type ) AS DebitMemoRequestType,
  SDDocumentCategory,
  SDDocumentReason,
  CreationDate,
  CreatedByUser,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast (_DebitMemoReq.HeaderBillingBlockReason as header_billing_block_reason preserving type ) AS HeaderBillingBlockReason,
  cast(_DebitMemoReq.SalesDocApprovalReason as sd_apm_approval_reason_vdm preserving type) AS DebitMemoReqApprovalReason,
  cast(_DebitMemoReq.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type ) AS OverallSDDocumentRejectionSts,
  cast(_DebitMemoReq.OverallOrdReltdBillgStatus as ovrl_ord_rel_billg_status preserving type ) AS OverallOrdReltdBillgStatus,
  cast (_DebitMemoReq.OverallBillingBlockStatus as overall_billing_block_status preserving type ) AS OverallBillingBlockStatus,
  cast (_DebitMemoReq.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast (_DebitMemoReq.HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type ) AS HeaderBillgIncompletionStatus,
  cast(_DebitMemoReq.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type ) AS OverallPricingIncompletionSts,
  cast(_DebitMemoReq.OvrlTrdCmplncSnctndListChkSts as ovrl_watchlist_screening_sts preserving type ) AS OvrlTrdCmplncSnctndListChkSts,
  SalesDocumentItemCategory AS DebitMemoRequestItemCategory,
  Division,
  ProfitCenter,
  WBSElementInternalID,
  BusinessArea,
  ControllingArea,
  cast (OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SalesDistrict,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  cast (SDProcessStatus as overall_sd_doc_processing_sts preserving type ) AS SDProcessStatus,
  OrderRelatedBillingStatus,
  SDDocumentRejectionStatus,
  BillingBlockStatus,
  cast (ItemGeneralIncompletionStatus as item_general_incompletion_sts preserving type ) AS ItemGeneralIncompletionStatus,
  cast (ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type ) AS ItemBillingIncompletionStatus,
  cast (PricingIncompletionStatus as pricing_incompletion_status preserving type ) AS PricingIncompletionStatus,
  SDDocReferenceStatus,
  TotalSDDocReferenceStatus,
  cast (DeliveryStatus as itm_overall_delivery_status preserving type ) AS DeliveryStatus,
  cast(TotalDeliveryStatus as itms_ovrl_delivery_status preserving type ) AS TotalDeliveryStatus,
  DeliveryBlockStatus,
  DeliveryConfirmationStatus,
  DebitMemoRequestItem._SalesDocumentRjcnReason._Text[1: Language=$session.system_language].SalesDocumentRjcnReasonName AS SalesDocumentRjcnReasonName,
  SalesDocumentRjcnReason,
  ShipToParty,
  PayerParty,
  BillToParty,
  ResponsibleEmployee,
  SalesEmployee,
  cast('' as ad_namtext ) AS ShipToPartyName,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast('' as ad_namtext ) AS BillToPartyName,
  cast('' as ad_namtext ) AS PayerPartyName,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  cast('' as ad_namtext ) AS SalesEmployeeName,
  TransactionCurrency,
  cast( ' ' as abap.char( 100 )) AS AdditionalPartnerName,
  cast( ' ' as parvw_unv preserving type ) AS PartnerFunction,
  cast( ' ' as kunnr) AS Customer,
  cast( ' ' as lifnr) AS Supplier,
  cast( '00000000' as pernr_d) AS Personnel,
  cast( '0000000000' as parnr) AS ContactPerson,
  SalesDocumentDate AS DebitMemoRequestDate,
  BillingDocumentDate,
  PricingDate,
  PaymentMethod,
  CustomerPaymentTerms AS PaymentTerms,
  cast(_DebitMemoReq.CustomerPaymentTerms as hdr_dzterm ) AS CustomerPaymentTerms,
  hextobin( '00000000000000000000000000000000' ) AS SlsDocMassChangeRequestUUID,
  cast ('I' as sd_mcc_entity_level) AS SlsDocMassChgEntityLevel,
  SalesDocumentItemText AS DebitMemoRequestItemText,
  NetAmount,
  cast( ItemBillingBlockReason as billing_block_reason_item preserving type ) AS ItemBillingBlockReason,
  SalesDocumentItemText,
  DebitMemoRequestItem.SalesDocumentItem AS DebitMemoRequestItem,
  DebitMemoRequestItem._DistributionChannel AS _DistributionChannel,
  _DebitMemoReq.OverallSDProcessStatus AS OverallSDProcessStatus,
  _DebitMemoReq.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _DebitMemoReq.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  _DebitMemoReq.TotalBlockStatus AS TotalBlockStatus,
  _DebitMemoReq.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  _DebitMemoReq.CostCenter AS CostCenter,
  _DebitMemoReq.BillingCompanyCode AS BillingCompanyCode,
  _DebitMemoReq.CreditControlArea AS CreditControlArea,
  _DebitMemoReq.TotalNetAmount AS TotalNetAmount,
  _DebitMemoReq.SalesDocumentType AS SalesDocumentType,
  _DebitMemoReq._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  _DebitMemoReq._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  _DebitMemoReq._BillingCompanyCode AS _BillingCompanyCode,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  _WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID
FROM I_SalesDocumentItem AS DebitMemoRequestItem
LEFT OUTER JOIN I_SalesDocument AS _DebitMemoReq ON DebitMemoRequest = _DebitMemoReq.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocItemCompletePartner AS _SalesItemCompletePartner ON DebitMemoRequest = _SalesItemCompletePartner.SalesDocument AND DebitMemoRequestItem = _SalesItemCompletePartner.SalesDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_SlsDocItmNonStdPartner AS _NonStdPartner ON DebitMemoRequest = _NonStdPartner.SalesDocument AND DebitMemoRequestItem = _NonStdPartner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND _DebitMemoReq.BillingCompanyCode = _PaymentMethod.BillingCompanyCode  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ItemExtension ON DebitMemoRequest = _ItemExtension.SalesDocument AND DebitMemoRequestItem = _ItemExtension.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON DebitMemoRequest = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityEndDate >= $session.system_date AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
;