C_MassChangeSalesQuotationItem

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_MassChangeSalesQuotationItem.
-- 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_MassChangeSalesQuotationItem AS
SELECT
  cast(_SalesQuotationItem.SalesDocument as sales_quotation preserving type ) AS SalesQuotation,
  SDDocumentCategory,
  cast(SalesDocumentType as sales_quotation_type preserving type ) AS SalesQuotationType,
  SDDocumentReason,
  SalesOrganization,
  DistributionChannel,
  cast(OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  BusinessArea,
  ControllingArea,
  ShippingCondition,
  ProfitCenter,
  cast(_SalesQuotation.SalesDocApprovalReason as sd_apm_approval_reason_vdm preserving type ) AS SalesQuotationApprovalReason,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast(_SalesQuotation.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type ) AS OverallSDDocumentRejectionSts,
  cast(_SalesQuotation.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast(_SalesQuotation.HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type ) AS HeaderBillgIncompletionStatus,
  cast(_SalesQuotation.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type ) AS OverallPricingIncompletionSts,
  cast(_SalesQuotation.OverallTrdCmplncEmbargoSts as overall_embargo_status preserving type ) AS OverallTrdCmplncEmbargoSts,
  cast(_SalesQuotation.OvrlTrdCmplncSnctndListChkSts as ovrl_watchlist_screening_sts preserving type ) AS OvrlTrdCmplncSnctndListChkSts,
  cast(OvrlTrdCmplncLegalCtrlChkSts as overall_legal_control_status preserving type ) AS OvrlTrdCmplncLegalCtrlChkSts,
  cast(_SalesQuotation.OverallChmlCmplncStatus as ovrl_product_marketability_sts preserving type ) AS OverallChmlCmplncStatus,
  cast(_SalesQuotation.OverallDangerousGoodsStatus as overall_dangerous_goods_status preserving type ) AS OverallDangerousGoodsStatus,
  cast(_SalesQuotation.ContractDownPaymentStatus as hdr_down_payment_status preserving type ) AS ContractDownPaymentStatus,
  SalesDocumentDate AS SalesQuotationDate,
  CustomerPaymentTerms AS PaymentTerms,
  cast(_SalesQuotation.CustomerPaymentTerms as hdr_dzterm preserving type ) AS CustomerPaymentTerms,
  PaymentMethod,
  cast(_SalesQuotation.IncotermsClassification as vdm_header_incoterm1 preserving type ) AS HeaderIncotermsClassification,
  IncotermsClassification,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerGroup,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee,
  SalesEmployee,
  TransactionCurrency,
  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,
  Material,
  Division,
  _ItemCategory._Text[1:Language = $session.system_language].SalesDocumentItemCategoryName AS SalesQuotationItemCategoryName,
  SalesDocumentItemCategory AS SalesQuotationItemCategory,
  cast(SDProcessStatus as overall_sd_doc_processing_sts preserving type ) AS SDProcessStatus,
  SDDocumentRejectionStatus,
  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,
  cast(ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type ) AS ItemDeliveryIncompletionStatus,
  SDDocReferenceStatus,
  TotalSDDocReferenceStatus,
  TrdCmplncEmbargoSts,
  TrdCmplncSnctndListChkSts,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  ContractItemDownPaymentStatus,
  _SalesDocumentRjcnReason._Text[1: Language=$session.system_language].SalesDocumentRjcnReasonName AS SalesDocumentRjcnReasonName,
  SalesDocumentRjcnReason,
  _Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  Product,
  SalesDocumentItemText AS SalesQuotationItemText,
  cast(RequestedQuantity as requested_quantity ) AS RequestedQuantity,
  RequestedQuantityUnit,
  NetAmount,
  cast( ' ' as abap.char( 100 )) AS AdditionalPartnerName,
  cast( ' ' as parvw_unv preserving type ) AS PartnerFunction,
  cast( ' ' as kunnr preserving type ) AS Customer,
  cast( ' ' as lifnr preserving type ) AS Supplier,
  cast( '00000000' as pernr_d preserving type ) AS Personnel,
  cast( '0000000000' as parnr preserving type ) AS ContactPerson,
  hextobin( '00000000000000000000000000000000' ) AS SlsDocMassChangeRequestUUID,
  cast ( 'I' as sd_mcc_entity_level ) AS SlsDocMassChgEntityLevel,
  _SalesQuotationItem.SalesDocumentItem AS SalesQuotationItem,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _SalesQuotation.CreatedByUser AS CreatedByUser,
  _SalesQuotation.CreationDate AS CreationDate,
  _SalesQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SalesQuotation.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  _SalesQuotation.CostCenter AS CostCenter,
  _SalesQuotation.CreditControlArea AS CreditControlArea,
  _SalesQuotation.BillingCompanyCode AS BillingCompanyCode,
  _SalesQuotation.ShippingType AS SlsOrdShippingType,
  _SalesQuotation.OverallSDProcessStatus AS OverallSDProcessStatus,
  _SalesQuotation.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  _SalesQuotation.TotalBlockStatus AS TotalBlockStatus,
  _SalesQuotation.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  _SalesQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  _SalesQuotation.SalesDocumentType AS SalesDocumentType,
  _SalesQuotation._ShippingType AS _ShippingType,
  _SalesQuotation._OverallSDProcessStatus AS _OverallSDProcessStatus,
  _SalesQuotation._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  _SalesQuotation._TotalBlockStatus AS _TotalBlockStatus,
  _SalesQuotation._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  _SalesQuotation._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  _SalesQuotation._HeaderBillgIncompletionStatus AS _HeaderBillgIncompletionStatus,
  _SalesQuotation._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  _SalesQuotation._OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus,
  _SalesQuotation._OvTrdCmplncSnctndListChkSts AS _OvTrdCmplncSnctndListChkSts,
  _SalesQuotation._OverallChmlCmplncStatus AS _OverallChmlCmplncStatus,
  _SalesQuotation._OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus,
  _SalesQuotation._DownPaymentStatus AS _DownPaymentStatus,
  _SalesQuotation._BillingCompanyCode AS _BillingCompanyCode,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_SalesDocumentItem AS _SalesQuotationItem
LEFT OUTER JOIN I_SalesDocument AS _SalesQuotation ON SalesQuotation = _SalesQuotation.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocItemCompletePartner AS _SalesItemCompletePartner ON SalesQuotation = _SalesItemCompletePartner.SalesDocument AND SalesQuotationItem = _SalesItemCompletePartner.SalesDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_SlsDocItmNonStdPartner AS _NonStdPartner ON SalesQuotation = _NonStdPartner.SalesDocument AND SalesQuotationItem = _NonStdPartner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ItemExtension ON SalesQuotation = _ItemExtension.SalesDocument AND SalesQuotationItem = _ItemExtension.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesQuotation = _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 C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND billingcompanycode = _PaymentMethod.BillingCompanyCode  -- association [0..1]
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
;