C_SlsDocMassChgRequestTP

DDL: C_SLSDOCMASSCHGREQUESTTP Type: view_entity CONSUMPTION
30 Fields 1 Data Sources

Sales Document Mass Change Request

C_SlsDocMassChgRequestTP is a Consumption CDS View that provides data about "Sales Document Mass Change Request" in SAP S/4HANA. It reads from 1 data source (R_SlsDocMassChgRequestTP) and exposes 30 fields with key field SlsDocMassChangeRequestUUID.

Data Sources (1)

SourceAliasJoin Type
R_SlsDocMassChgRequestTP R_SlsDocMassChgRequestTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Sales Document Mass Change Request view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SlsDocMassChangeRequestUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name SlsDocMassChangeRequest view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID SlsDocMassChangeRequestUUID Job ID
SlsDocMassChangeJobName SlsDocMassChangeJobName Job Name
NumberOfSlsDocMassChgErrorLg NumberOfSlsDocMassChgErrorLg
NumberOfSlsDocMassChgSuccessLg NumberOfSlsDocMassChgSuccessLg
SDDocumentCategory SDDocumentCategory Document Cat.
SlsDocMassChgEntityLevel SlsDocMassChgEntityLevel Entity Level
SlsDocMassChgEntityType SlsDocMassChgEntityType Entity Type
SlsDocMassChgActionCategory SlsDocMassChgActionCategory Action Category
SlsDocMassChgActionID SlsDocMassChgActionID Action
SlsDocMassChangeReqStatus SlsDocMassChangeReqStatus Job Status
SlsDocMassChangeRequestRefUUID SlsDocMassChangeRequestRefUUID Job ID
CreatedByUser CreatedByUser User Name
UserDescription _CreatedByUser UserDescription Full Name
SlsDocMassChgReqPlndStrtDte SlsDocMassChgReqPlndStrtDte Start Date
SlsDocMassChgReqPlndStrtDteTme SlsDocMassChgReqPlndStrtDteTme
SlsDocMassChgReqIsMnllyCmplt SlsDocMassChgReqIsMnllyCmplt Mnlly Cmplt
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
virtualUICT_SDDocumentCategoryboole_d
virtualSlsDocItemMassChgIsHiddenboole_d
virtualSlsDocMassChgReqErrMsgCritltyint1
char80
LastChangeDateTime LastChangeDateTime Timestamp
_ChangeRequestLog _ChangeRequestLog
_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 C_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 C_SlsDocMassChgRequestTP AS
SELECT
  SlsDocMassChangeRequestUUID,
  SlsDocMassChangeJobName,
  NumberOfSlsDocMassChgErrorLg,
  NumberOfSlsDocMassChgSuccessLg,
  SDDocumentCategory,
  SlsDocMassChgEntityLevel,
  SlsDocMassChgEntityType,
  SlsDocMassChgActionCategory,
  SlsDocMassChgActionID,
  SlsDocMassChangeReqStatus,
  SlsDocMassChangeRequestRefUUID,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserDescription,
  SlsDocMassChgReqPlndStrtDte,
  SlsDocMassChgReqPlndStrtDteTme,
  SlsDocMassChgReqIsMnllyCmplt,
  SlsDocMassChgReqLogMsgNumber,
  SlsDocMassChgReqLogMsgClass,
  SlsDocMassChgReqLogMsgType,
  SlsDocMassChgReqLgMsgVarbl1Txt,
  SlsDocMassChgReqLgMsgVarbl2Txt,
  SlsDocMassChgReqLgMsgVarbl3Txt,
  SlsDocMassChgReqLgMsgVarbl4Txt,
  virtual UICT_SDDocumentCategory : boole_d AS virtualUICT_SDDocumentCategoryboole_d,
  virtual SlsDocItemMassChgIsHidden : boole_d AS virtualSlsDocItemMassChgIsHiddenboole_d,
  virtual SlsDocMassChgReqErrMsgCritlty : int1 AS virtualSlsDocMassChgReqErrMsgCritltyint1,
  virtual SlsDocMassChangeReqInfoDesc : abap.char(80) AS char80,
  LastChangeDateTime
FROM R_SlsDocMassChgRequestTP
;

Learn More