R_SlsDocMassChgRequestTP

DDL: R_SLSDOCMASSCHGREQUESTTP Type: view_entity TRANSACTIONAL
45 Fields 1 Data Sources 8 Associations

Mass Chg of Sls Doc Request RAP Facade

R_SlsDocMassChgRequestTP is a Transactional CDS View that provides data about "Mass Chg of Sls Doc Request RAP Facade" in SAP S/4HANA. It reads from 1 data source (I_SDMassChgCkptMassChgReq) and exposes 45 fields with key field SlsDocMassChangeRequestUUID. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDMassChgCkptMassChgReq SalesDocumentMassChangeRequest from

Associations (8)

CardinalityTargetAliasCondition
[0..*] R_SlsDocMassChgReqErrorLogTP _ChangeRequestErrorLog
[0..*] R_SlsDocMassChgReqSuccessLogTP _ChangeRequestSuccessLog
[0..*] R_SlsDocMassChgReqDocumentTP _ChangeRequestDocument
[0..1] R_SlsDocMassChgReqHdrChangeTP _ChangeRequestHeader
[0..1] R_SlsDocMassChgReqItemChangeTP _ChangeRequestItem
[0..1] R_SlsDocMassChgReqSchdLnChgTP _ChangeRequestScheduleLine
[0..1] R_SlsDocMassChgReqPartChangeTP _ChangeRequestPartner
[0..*] R_SlsDocMassChgReqFieldListTP _ChangeRequestFieldList

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mass Chg of Sls Doc Request RAP Facade view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey SlsDocMassChangeRequestUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name SalesDocumentMassChangeRequest view
Metadata.ignorePropagatedAnnotations true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID SlsDocMassChangeRequestUUID Job ID
SlsDocMassChangeJobName SlsDocMassChangeJobName Job Name
NumberOfSlsDocMassChgErrorLg NumberOfSlsDocMassChgErrorLg
NumberOfSlsDocMassChgSuccessLg NumberOfSlsDocMassChgSuccessLg
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
usedasetagfieldSDDocumentCategory
SlsDocMassChgEntityType SlsDocMassChgEntityType Entity Type
SlsDocMassChgEntityLevel SlsDocMassChgEntityLevel Entity Level
SlsDocMassChgActionCategory SlsDocMassChgActionCategory Action Category
SlsDocMassChgActionID SlsDocMassChgActionID Action
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
_ChangeRequestErrorLog _ChangeRequestErrorLog
_ChangeRequestSuccessLog _ChangeRequestSuccessLog
_ChangeRequestDocument _ChangeRequestDocument
_ChangeRequestHeader _ChangeRequestHeader
_ChangeRequestItem _ChangeRequestItem
_ChangeRequestScheduleLine _ChangeRequestScheduleLine
_ChangeRequestPartner _ChangeRequestPartner
_ChangeRequestFieldList _ChangeRequestFieldList
_ChangeRequestLog _ChangeRequestLog
_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 R_SlsDocMassChgRequestTP.
-- 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 R_SlsDocMassChgRequestTP AS
SELECT
  SlsDocMassChangeRequestUUID,
  SlsDocMassChangeJobName,
  NumberOfSlsDocMassChgErrorLg,
  NumberOfSlsDocMassChgSuccessLg,
  ApplicationJobName,
  ApplicationJob,
  SlsDocMassChangeReqStatus,
  SlsDocMassChangeRequestRefUUID,
  CreatedByUser,
  TimeZoneID,
  SlsDocMassChgReqPlndStrtDte,
  SlsDocMassChgReqPlndStrtTme,
  SlsDocMassChgReqCompltnDte,
  SlsDocMassChgReqCompltnTme,
  LastChangedByUser,
  LastChangeDateTime,
  SlsDocMassChgEntityType,
  SlsDocMassChgEntityLevel,
  SlsDocMassChgActionCategory,
  SlsDocMassChgActionID,
  SlsDocMassChgReqLogMsgNumber,
  SlsDocMassChgReqLogMsgClass,
  SlsDocMassChgReqLogMsgType,
  SlsDocMassChgReqLgMsgVarbl1Txt,
  SlsDocMassChgReqLgMsgVarbl2Txt,
  SlsDocMassChgReqLgMsgVarbl3Txt,
  SlsDocMassChgReqLgMsgVarbl4Txt,
  SlsDocMassChgReqIsMnllyCmplt
FROM I_SDMassChgCkptMassChgReq AS SalesDocumentMassChangeRequest
LEFT OUTER JOIN R_SlsDocMassChgReqErrorLogTP AS _ChangeRequestErrorLog ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsDocMassChgReqSuccessLogTP AS _ChangeRequestSuccessLog ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsDocMassChgReqDocumentTP AS _ChangeRequestDocument ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsDocMassChgReqHdrChangeTP AS _ChangeRequestHeader ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SlsDocMassChgReqItemChangeTP AS _ChangeRequestItem ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SlsDocMassChgReqSchdLnChgTP AS _ChangeRequestScheduleLine ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SlsDocMassChgReqPartChangeTP AS _ChangeRequestPartner ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SlsDocMassChgReqFieldListTP AS _ChangeRequestFieldList ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More