C_MassChangeSlsSchedgAgrmtItem

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_MassChangeSlsSchedgAgrmtItem.
-- 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_MassChangeSlsSchedgAgrmtItem AS
SELECT
  cast(_SalesSchedgAgreementItem.SalesDocument as vdm_sales_schedg_agrmt preserving type) AS SalesSchedulingAgreement,
  cast( _SalesSchedgAgreement.SalesDocumentType as vdm_sales_schedg_agrmt_type preserving type) AS SalesSchedgAgrmtType,
  cast( _SalesSchedgAgreement.DelivSchedTypeMRPRlvnceCode as mrp_del_sch_type preserving type ) AS DelivSchedTypeMRPRlvnceCode,
  cast( _SalesSchedgAgreement.SalesDocumentProcessingType as sd_schedg_agrmt_proc_type preserving type) AS SalesSchedgAgrmtProcessingType,
  OrderID,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SalesDocumentItemCategory AS SalesSchedgAgrmtItemCategory,
  _Product._Text[1:Language = $session.system_language ].ProductName AS ProductName,
  Product,
  Batch,
  Division,
  ProfitCenter,
  SalesOrganization,
  PurchaseOrderByCustomer,
  DistributionChannel,
  cast( OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SalesDistrict,
  ControllingArea,
  BusinessArea,
  cast(_SalesSchedgAgreement.DeliveryBlockReason as header_delivery_block_reason) AS DeliveryBlockReason,
  cast( _SalesSchedgAgreement.OverallDeliveryStatus as overall_delivery_status preserving type ) AS OverallDeliveryStatus,
  cast( _SalesSchedgAgreement.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type ) AS OverallSDDocumentRejectionSts,
  cast(_SalesSchedgAgreement.TotalCreditCheckStatus as overall_credit_check_status preserving type ) AS TotalCreditCheckStatus,
  cast( _SalesSchedgAgreement.OverallDeliveryBlockStatus as overall_delivery_block_status preserving type ) AS OverallDeliveryBlockStatus,
  cast( _SalesSchedgAgreement.OverallBillingBlockStatus as overall_billing_block_status preserving type ) AS OverallBillingBlockStatus,
  cast( _SalesSchedgAgreement.HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type ) AS HeaderBillgIncompletionStatus,
  cast( _SalesSchedgAgreement.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type ) AS OverallPricingIncompletionSts,
  cast( _SalesSchedgAgreement.HeaderDelivIncompletionStatus as hdrdelivincompletionstatus preserving type ) AS HeaderDelivIncompletionStatus,
  cast( _SalesSchedgAgreement.OverallDelivConfStatus as overall_delivery_conf_status preserving type ) AS OverallDelivConfStatus,
  cast( _SalesSchedgAgreement.OverallTrdCmplncEmbargoSts as overall_embargo_status preserving type ) AS OverallTrdCmplncEmbargoSts,
  cast( _SalesSchedgAgreement.OvrlTrdCmplncSnctndListChkSts as ovrl_watchlist_screening_sts preserving type ) AS OvrlTrdCmplncSnctndListChkSts,
  cast( _SalesSchedgAgreement.OvrlTrdCmplncLegalCtrlChkSts as overall_legal_control_status preserving type ) AS OvrlTrdCmplncLegalCtrlChkSts,
  cast( _SalesSchedgAgreement.OverallChmlCmplncStatus as ovrl_product_marketability_sts preserving type ) AS OverallChmlCmplncStatus,
  cast( _SalesSchedgAgreement.OverallDangerousGoodsStatus as overall_dangerous_goods_status preserving type ) AS OverallDangerousGoodsStatus,
  cast( _SalesSchedgAgreement.OverallSafetyDataSheetStatus as ovrl_safety_data_sheet_sts preserving type ) AS OverallSafetyDataSheetStatus,
  cast( _SalesSchedgAgreement.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast( SDProcessStatus as overall_sd_doc_processing_sts preserving type ) AS SDProcessStatus,
  OrderRelatedBillingStatus,
  _SalesSchedgAgreementItem._SalesDocumentRjcnReason._Text[1: Language=$session.system_language].SalesDocumentRjcnReasonName AS SalesDocumentRjcnReasonName,
  SalesDocumentRjcnReason,
  SDDocumentRejectionStatus,
  DeliveryBlockStatus,
  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,
  cast( ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type ) AS ItemDeliveryIncompletionStatus,
  DeliveryConfirmationStatus,
  SDDocReferenceStatus,
  TotalSDDocReferenceStatus,
  TrdCmplncEmbargoSts,
  TrdCmplncSnctndListChkSts,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  SafetyDataSheetStatus,
  SoldToParty,
  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,
  BillingDocumentDate,
  PricingDate,
  SalesDocumentDate AS SalesSchedgAgrmtDate,
  ShippingCondition,
  cast(_SalesSchedgAgreementItem.ShippingType as itm_vsarttr preserving type ) AS ShippingType,
  Plant,
  StorageLocation,
  _SalesSchedgAgreementItem._DeliveryPriority._Text[1: Language=$session.system_language].DeliveryPriorityDesc AS DeliveryPriorityDesc,
  DeliveryPriority,
  Route,
  _SalesItemCompletePartner[1:PartnerFunction = 'WE'].UnloadingPointName AS UnloadingPointName,
  cast(ItemIsDeliveryRelevant as lfrel_mcc) AS ItemIsDeliveryRelevant,
  ShippingPoint,
  cast(_SalesSchedgAgreement.CustomerPaymentTerms as hdr_dzterm ) AS CustomerPaymentTerms,
  cast(_SalesSchedgAgreement.IncotermsClassification as vdm_header_incoterm1 ) AS HeaderIncotermsClassification,
  IncotermsLocation1,
  IncotermsLocation2,
  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,
  hextobin( '00000000000000000000000000000000' ) AS SlsDocMassChangeRequestUUID,
  cast ('I' as sd_mcc_entity_level) AS SlsDocMassChgEntityLevel,
  cast( ' ' as abap.char( 100 )) AS AdditionalPartnerName,
  cast( ' ' as schedule_line_del_block_reason ) AS DelivBlockReasonForSchedLine,
  TransactionCurrency,
  HigherLevelItem,
  cast( 'X' as lfrel_mcc ) AS SlsDocMassChgItmIsHigherLvl,
  _ItemCategory._Text[1:Language = $session.system_language ].SalesDocumentItemCategoryName AS SchedgAgrmtItemCategoryName,
  Material,
  cast(RequestedQuantity as requested_quantity) AS RequestedQuantity,
  RequestedQuantityUnit,
  NetAmount,
  ContractItemDownPaymentStatus,
  SDDocumentCategory,
  cast(_SalesSchedgAgreement.SalesDocApprovalReason as sd_apm_approval_reason_vdm) AS SalesDocApprovalReason,
  ItemBillingBlockReason,
  _SalesSchedgAgreementItem.SalesDocumentItem AS SalesSchedulingAgreementItem,
  _SalesSchedgAgreementItem.OvrlTrdCmplncLegalCtrlChkSts AS TradeCmplncLegalCtrlChkSts,
  _SalesSchedgAgreementItem.CustomerPaymentTerms AS PaymentTerms,
  _SalesSchedgAgreementItem.PaymentMethod AS PaymentMethod,
  _SalesSchedgAgreementItem.IncotermsClassification AS IncotermsClassification,
  _SalesSchedgAgreementItem.IncotermsVersion AS IncotermsVersion,
  _SalesSchedgAgreementItem._SDDocumentCategory AS _SDDocumentCategory,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _SalesSchedgAgreement.SDDocumentReason AS SDDocumentReason,
  _SalesSchedgAgreement.CreationDate AS CreationDate,
  _SalesSchedgAgreement.CreatedByUser AS CreatedByUser,
  _SalesSchedgAgreement.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  _SalesSchedgAgreement.BillingCompanyCode AS BillingCompanyCode,
  _SalesSchedgAgreement.CostCenter AS CostCenter,
  _SalesSchedgAgreement.CreditControlArea AS CreditControlArea,
  _SalesSchedgAgreement.OverallSDProcessStatus AS OverallSDProcessStatus,
  _SalesSchedgAgreement.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  _SalesSchedgAgreement.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  _SalesSchedgAgreement.TotalBlockStatus AS TotalBlockStatus,
  _SalesSchedgAgreement.SalesDocumentType AS SalesDocumentType,
  _SalesSchedgAgreement._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  _SalesSchedgAgreement._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  _SalesSchedgAgreement._DelivSchedTypeMRPRlvnceCode AS _DelivSchedTypeMRPRlvnceCode,
  _SalesSchedgAgreement._BillingCompanyCode AS _BillingCompanyCode,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_SalesDocumentItem AS _SalesSchedgAgreementItem
LEFT OUTER JOIN I_SalesDocument AS _SalesSchedgAgreement ON SalesSchedulingAgreement = _SalesSchedgAgreement.SalesDocument  -- association [1]
LEFT OUTER JOIN I_SalesDocItemCompletePartner AS _SalesItemCompletePartner ON SalesSchedulingAgreement = _SalesItemCompletePartner.SalesDocument AND SalesSchedulingAgreementItem = _SalesItemCompletePartner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentScheduleLine AS _ScheduleLine ON SalesSchedulingAgreement = _ScheduleLine.SalesDocument AND SalesSchedulingAgreementItem = _ScheduleLine.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SlsDocItmNonStdPartner AS _NonStdPartner ON SalesSchedulingAgreement = _NonStdPartner.SalesDocument AND SalesSchedulingAgreementItem = _NonStdPartner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ItemExtension ON SalesSchedulingAgreement = _ItemExtension.SalesDocument AND SalesSchedulingAgreementItem = _ItemExtension.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesSchedulingAgreement = _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 _SalesDocPaymentMethodVH ON PaymentMethod = _SalesDocPaymentMethodVH.PaymentMethod AND BillingCompanyCode = _SalesDocPaymentMethodVH.BillingCompanyCode  -- 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..*]
;