I_SDMassChgCkptSlsSchdLnChg

DDL: I_SDMASSCHGCKPTSLSSCHDLNCHG Type: view BASIC Package: SD_CHANGE_COCKPIT_CMN_VDM
12 Fields 1 Data Sources 2 Associations

Mass Chg of Sls Doc Sched Line Change

I_SDMassChgCkptSlsSchdLnChg is a Basic CDS View that provides data about "Mass Chg of Sls Doc Sched Line Change" in SAP S/4HANA. It reads from 1 data source (I_SDMassChgCkptSlsSchdLnChgBsc) and exposes 12 fields with key field SlsDocMassChangeRequestUUID. It has 2 associations to related views. Part of development package SD_CHANGE_COCKPIT_CMN_VDM.

Data Sources (1)

SourceAliasJoin Type
I_SDMassChgCkptSlsSchdLnChgBsc I_SDMassChgCkptSlsSchdLnChgBsc from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_SDMassChgCkptChgSlsDoc _ChangeSalesDocument $projection.SlsDocMassChangeRequestUUID = _ChangeSalesDocument.SlsDocMassChangeRequestUUID
[1..1] I_SDMassChgCkptMassChgReqBsc _ChangeRequest $projection.SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISDMCCCHGSLINE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Mass Chg of Sls Doc Sched Line Change view
VDM.viewType #BASIC view
ObjectModel.representativeKey SlsDocMassChangeRequestUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID SlsDocMassChangeRequestUUID Job ID
SlsDocMassChgActionCategory SlsDocMassChgActionCategory Action Category
SlsDocMassChgActionID SlsDocMassChgActionID Action
ScheduleLineCategory ScheduleLineCategory Sched.Line Cat.
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine Delivery Block
_ChangeSalesDocument _ChangeSalesDocument
_ChangeRequest _ChangeRequest
_ScheduleLineCategory _ScheduleLineCategory
_DeliveryBlockReason _DeliveryBlockReason
_ChangeActionCategory _ChangeActionCategory
_ChangeActionID _ChangeActionID

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_SDMassChgCkptSlsSchdLnChg.
-- 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 I_SDMassChgCkptSlsSchdLnChg AS
SELECT
  SlsDocMassChangeRequestUUID,
  SlsDocMassChgActionCategory,
  SlsDocMassChgActionID,
  ScheduleLineCategory,
  RequestedDeliveryDate,
  DelivBlockReasonForSchedLine
FROM I_SDMassChgCkptSlsSchdLnChgBsc
LEFT OUTER JOIN I_SDMassChgCkptChgSlsDoc AS _ChangeSalesDocument ON SlsDocMassChangeRequestUUID = _ChangeSalesDocument.SlsDocMassChangeRequestUUID  -- association [1..*]
LEFT OUTER JOIN I_SDMassChgCkptMassChgReqBsc AS _ChangeRequest ON SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID  -- association [1..1]
;

Learn More