C_MassChangeSalesDocument

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_MassChangeSalesDocument.
-- 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_MassChangeSalesDocument AS
SELECT
  SalesDocument,
  SDDocumentCategory,
  SalesOrganization,
  DistributionChannel,
  SoldToParty,
  _StandardPartner.ShipToParty AS ShipToParty,
  SDDocumentReason,
  cast(OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SalesDistrict,
  BusinessArea,
  BillingCompanyCode,
  CostCenter,
  _CostCenterText.CostCenterDescription AS CostCenterDescription,
  ControllingArea,
  SalesDocumentType,
  CreationDate,
  CreatedByUser,
  cast( DeliveryBlockReason as header_delivery_block_reason preserving type ) AS DeliveryBlockReason,
  cast( SalesDocApprovalReason as sd_apm_approval_reason_vdm preserving type ) AS SalesDocApprovalReason,
  OverallSDProcessStatus,
  TotalNetAmount,
  TransactionCurrency,
  cast(HeaderBillingBlockReason as header_billing_block_reason preserving type ) AS HeaderBillingBlockReason,
  ShippingCondition,
  ShippingType AS SlsOrdShippingType,
  cast( CustomerPaymentTerms as hdr_dzterm preserving type ) AS CustomerPaymentTerms,
  PaymentMethod,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast( IncotermsClassification as vdm_header_incoterm1 preserving type ) AS HeaderIncotermsClassification,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  _StandardPartner.PayerParty AS PayerParty,
  _StandardPartner.BillToParty AS BillToParty,
  _StandardPartner.ResponsibleEmployee AS ResponsibleEmployee,
  _StandardPartner.SalesEmployee AS 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,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  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,
  cast( ' ' as spart ) AS Division,
  cast( ' ' as ps_posid_edit ) AS WBSElementExternalID,
  cast( ' ' as productnumber ) AS Product,
  cast( ' ' as abgru_va preserving type ) AS SalesDocumentRjcnReason,
  cast( ' ' as prctr ) AS ProfitCenter,
  hextobin( '00000000000000000000000000000000' ) AS SlsDocMassChangeRequestUUID,
  cast ('H' as sd_mcc_entity_level) AS SlsDocMassChgEntityLevel,
  cast(' ' as abap.char(4) ) AS PaymentTerms,
  cast(' ' as billing_block_reason_item preserving type) AS ItemBillingBlockReason,
  SalesDocumentDate,
  PricingDate,
  BillingDocumentDate,
  SalesDocument._SDDocumentReason AS _SDDocumentReason,
  _StandardPartner._ShipToParty AS _ShipToParty,
  _StandardPartner._PayerParty AS _PayerParty,
  _StandardPartner._BillToParty AS _BillToParty,
  _StandardPartner._ResponsibleEmployee AS _ResponsibleEmployee,
  _StandardPartner._SalesEmployee AS _SalesEmployee
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_SDDocStandardPartner AS _StandardPartner ON SalesDocument = _StandardPartner.SDDocument  -- association [0..1]
LEFT OUTER JOIN I_SlsDocNonStdPartner AS _NonStdPartner ON SalesDocument = _NonStdPartner.SDDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartner ON SalesDocument = _SDDocumentPartner.SDDocument  -- association [1..*]
LEFT OUTER JOIN C_MassChangeSalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument  -- association [0..*]
LEFT OUTER JOIN C_MassChgSalesDocumentItemWl AS _MassChgSalesDocumentItemWL ON SalesDocument = _MassChgSalesDocumentItemWL.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND BillingCompanyCode = _PaymentMethod.BillingCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.ValidityEndDate >= $session.system_date AND _CostCenterText.Language = $session.system_language  -- association [1]
;