I_SDMassChgCkptMassChgReqLgBsc

DDL: I_SDMASSCHGCKPTMASSCHGREQLGBSC Type: view BASIC Package: SD_CHANGE_COCKPIT_CMN_VDM
14 Fields 1 Data Sources 1 Associations

Mass Chg of Sls Doc Chg Req Log Basic

I_SDMassChgCkptMassChgReqLgBsc is a Basic CDS View that provides data about "Mass Chg of Sls Doc Chg Req Log Basic" in SAP S/4HANA. It reads from 1 data source (sdmcc_joblog) and exposes 14 fields with key fields SlsDocMassChangeRequestUUID, SalesDocument, SalesDocumentItem, ScheduleLine, SlsDocMassChgReqLogMsgNumber. It has 1 association to related views. Part of development package SD_CHANGE_COCKPIT_CMN_VDM.

Data Sources (1)

SourceAliasJoin Type
sdmcc_joblog sdmcc_joblog from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SDMassChgCkptMassChgReqBsc _ChangeRequest $projection.SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Mass Chg of Sls Doc Chg Req Log Basic view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ISDMCCMCHGLOGB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID slsdocmasschangerequestuuid Job ID
KEY SalesDocument salesdocument SD Document
KEY SalesDocumentItem salesdocumentitem Sales Document Item
KEY ScheduleLine scheduleline Schedule Line
KEY SlsDocMassChgReqLogMsgNumber slsdocmasschgreqlogmsgnumber Message Number
KEY SlsDocMassChgReqLogMsgClass slsdocmasschgreqlogmsgclass Message Class
SlsDocMassChgReqLogMsgType slsdocmasschgreqlogmsgtype Message Type
SlsDocMassChgReqLgMsgVarbl1Txt slsdocmasschgreqlgmsgvarbl1txt Message Variable
SlsDocMassChgReqLgMsgVarbl2Txt slsdocmasschgreqlgmsgvarbl2txt Message Variable
SlsDocMassChgReqLgMsgVarbl3Txt slsdocmasschgreqlgmsgvarbl3txt Message Variable
SlsDocMassChgReqLgMsgVarbl4Txt slsdocmasschgreqlgmsgvarbl4txt Message Variable
SlsDocMassChangeReqItmStatus slsdocmasschangereqitmstatus Job Item Status
SlsDocMassChgReqLgIsMnllyCmplt slsdocmasschgreqlgismnllycmplt Mnlly Cmplt
_ChangeRequest _ChangeRequest

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_SDMassChgCkptMassChgReqLgBsc.
-- 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_SDMassChgCkptMassChgReqLgBsc AS
SELECT
  SlsDocMassChangeRequestUUID,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  SlsDocMassChgReqLogMsgNumber,
  SlsDocMassChgReqLogMsgClass,
  SlsDocMassChgReqLogMsgType,
  SlsDocMassChgReqLgMsgVarbl1Txt,
  SlsDocMassChgReqLgMsgVarbl2Txt,
  SlsDocMassChgReqLgMsgVarbl3Txt,
  SlsDocMassChgReqLgMsgVarbl4Txt,
  SlsDocMassChangeReqItmStatus,
  SlsDocMassChgReqLgIsMnllyCmplt
FROM sdmcc_joblog
LEFT OUTER JOIN I_SDMassChgCkptMassChgReqBsc AS _ChangeRequest ON SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID  -- association [1..1]
;

Learn More