I_SDMassChgCkptMassChgReqBsc

DDL: I_SDMASSCHGCKPTMASSCHGREQBSC Type: view BASIC
34 Fields 1 Data Sources 7 Associations

Mass Change of Sales Doc Chg Request

I_SDMassChgCkptMassChgReqBsc is a Basic CDS View that provides data about "Mass Change of Sales Doc Chg Request" in SAP S/4HANA. It reads from 1 data source (sdmcc_jobreq) and exposes 34 fields with key field SlsDocMassChangeRequestUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
sdmcc_jobreq sdmcc_jobreq from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_SDMassChgCkptActionCategory _ChangeActionCategory $projection.SlsDocMassChgActionCategory = _ChangeActionCategory.SlsDocMassChgActionCategory
[0..1] I_SDMassChgCkptActionMaster _ChangeActionID $projection.SlsDocMassChgActionID = _ChangeActionID.SlsDocMassChgActionID
[0..1] I_SDMassChgDocumentCategory _SDDocumentCategory $projection.SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory
[0..1] I_SDMassChgCkptEntityLevel _EntityLevel $projection.SlsDocMassChgEntityLevel = _EntityLevel.SlsDocMassChgEntityLevel
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_SlsDocMassChangeReqStatus _ChangeRequestStatus $projection.SlsDocMassChangeReqStatus = _ChangeRequestStatus.SlsDocMassChangeReqStatus

Annotations (12)

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

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID slsdocmasschangerequestuuid Job ID
ApplicationJobName applicationjobname Job Name
ApplicationJob applicationjob Job No.
SlsDocMassChangeReqStatus slsdocmasschangereqstatus Job Status
SlsDocMassChangeRequestRefUUID slsdocmasschangerequestrefuuid Job ID
CreatedByUser createdbyuser User Name
TimeZoneID timezoneid Time Zone
SlsDocMassChgReqPlndStrtDte slsdocmasschgreqplndstrtdte Start Date
SlsDocMassChgReqPlndStrtTme slsdocmasschgreqplndstrttme Start Time
SlsDocMassChgReqCompltnDte slsdocmasschgreqcompltndte Execution Date
SlsDocMassChgReqCompltnTme slsdocmasschgreqcompltntme Execution Date
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
SDDocumentCategory sddocumentcategory Document Cat.
SlsDocMassChgEntityType slsdocmasschgentitytype Entity Type
SlsDocMassChgEntityLevel slsdocmasschgentitylevel Entity Level
SlsDocMassChgActionID slsdocmasschgactionid Action
SlsDocMassChgActionCategory slsdocmasschgactioncategory Action Category
SlsDocMassChangeJobName slsdocmasschangejobname Job Name
SlsDocMassChgReqLogMsgNumber slsdocmasschgreqlogmsgnumber Message Number
SlsDocMassChgReqLogMsgClass slsdocmasschgreqlogmsgclass Message Class
SlsDocMassChgReqLogMsgType slsdocmasschgreqlogmsgtype Message Type
SlsDocMassChgReqLgMsgVarbl1Txt slsdocmasschgreqlgmsgvarbl1txt Message Variable
SlsDocMassChgReqLgMsgVarbl2Txt slsdocmasschgreqlgmsgvarbl2txt Message Variable
SlsDocMassChgReqLgMsgVarbl3Txt slsdocmasschgreqlgmsgvarbl3txt Message Variable
SlsDocMassChgReqLgMsgVarbl4Txt slsdocmasschgreqlgmsgvarbl4txt Message Variable
SlsDocMassChgReqIsMnllyCmplt slsdocmasschgreqismnllycmplt Mnlly Cmplt
_ChangeActionCategory _ChangeActionCategory
_ChangeActionID _ChangeActionID
_SDDocumentCategory _SDDocumentCategory
_EntityLevel _EntityLevel
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ChangeRequestStatus _ChangeRequestStatus

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_SDMassChgCkptMassChgReqBsc.
-- 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_SDMassChgCkptMassChgReqBsc AS
SELECT
  SlsDocMassChangeRequestUUID,
  ApplicationJobName,
  ApplicationJob,
  SlsDocMassChangeReqStatus,
  SlsDocMassChangeRequestRefUUID,
  CreatedByUser,
  TimeZoneID,
  SlsDocMassChgReqPlndStrtDte,
  SlsDocMassChgReqPlndStrtTme,
  SlsDocMassChgReqCompltnDte,
  SlsDocMassChgReqCompltnTme,
  LastChangedByUser,
  LastChangeDateTime,
  SDDocumentCategory,
  SlsDocMassChgEntityType,
  SlsDocMassChgEntityLevel,
  SlsDocMassChgActionID,
  SlsDocMassChgActionCategory,
  SlsDocMassChangeJobName,
  SlsDocMassChgReqLogMsgNumber,
  SlsDocMassChgReqLogMsgClass,
  SlsDocMassChgReqLogMsgType,
  SlsDocMassChgReqLgMsgVarbl1Txt,
  SlsDocMassChgReqLgMsgVarbl2Txt,
  SlsDocMassChgReqLgMsgVarbl3Txt,
  SlsDocMassChgReqLgMsgVarbl4Txt,
  SlsDocMassChgReqIsMnllyCmplt
FROM sdmcc_jobreq
LEFT OUTER JOIN I_SDMassChgCkptActionCategory AS _ChangeActionCategory ON SlsDocMassChgActionCategory = _ChangeActionCategory.SlsDocMassChgActionCategory  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptActionMaster AS _ChangeActionID ON SlsDocMassChgActionID = _ChangeActionID.SlsDocMassChgActionID  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptEntityLevel AS _EntityLevel ON SlsDocMassChgEntityLevel = _EntityLevel.SlsDocMassChgEntityLevel  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SlsDocMassChangeReqStatus AS _ChangeRequestStatus ON SlsDocMassChangeReqStatus = _ChangeRequestStatus.SlsDocMassChangeReqStatus  -- association [0..1]
;

Learn More