I_SDMassChgCkptMassChgReqLog

DDL: I_SDMASSCHGCKPTMASSCHGREQLOG Type: view BASIC
22 Fields 1 Data Sources 1 Associations

Mass Chg of Sls Doc Chg Req Job Log

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

Data Sources (1)

SourceAliasJoin Type
I_SDMassChgCkptMassChgReqLgBsc I_SDMassChgCkptMassChgReqLgBsc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument

Annotations (11)

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

Fields (22)

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
SalesDocumentType _SalesDocument SalesDocumentType Sales Doc. Type
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocument OrganizationDivision Org. Division
SlsDocMassChgReqLgIsMnllyCmplt SlsDocMassChgReqLgIsMnllyCmplt Mnlly Cmplt
_SalesDocument _SalesDocument
_SalesDocumentType _SalesDocument _SalesDocumentType
_DistributionChannel _SalesDocument _DistributionChannel
_OrganizationDivision _SalesDocument _OrganizationDivision
_SalesOrganization _SalesDocument _SalesOrganization

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_SDMassChgCkptMassChgReqLog.
-- 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_SDMassChgCkptMassChgReqLog AS
SELECT
  SlsDocMassChangeRequestUUID,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  SlsDocMassChgReqLogMsgNumber,
  SlsDocMassChgReqLogMsgClass,
  SlsDocMassChgReqLogMsgType,
  SlsDocMassChgReqLgMsgVarbl1Txt,
  SlsDocMassChgReqLgMsgVarbl2Txt,
  SlsDocMassChgReqLgMsgVarbl3Txt,
  SlsDocMassChgReqLgMsgVarbl4Txt,
  SlsDocMassChangeReqItmStatus,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  SlsDocMassChgReqLgIsMnllyCmplt,
  _SalesDocument._SalesDocumentType AS _SalesDocumentType,
  _SalesDocument._DistributionChannel AS _DistributionChannel,
  _SalesDocument._OrganizationDivision AS _OrganizationDivision,
  _SalesDocument._SalesOrganization AS _SalesOrganization
FROM I_SDMassChgCkptMassChgReqLgBsc
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
;

Learn More