I_CAMstrDataDistrRecdWthObject

DDL: I_CAMSTRDATADISTRRECDWTHOBJECT SQL: ICAMDRECDWTHOBJ Type: view BASIC Package: FKK_MA
30 Fields 1 Data Sources

Master Data Distribution - Distrib. Records w/ Distrib. Data

I_CAMstrDataDistrRecdWthObject is a Basic CDS View that provides data about "Master Data Distribution - Distrib. Records w/ Distrib. Data" in SAP S/4HANA. It reads from 1 data source (I_CAMasterDataDistrObject) and exposes 30 fields with key fields CAMasterDataDistrObjectType, CAMasterDataDistrObject, CreationDateTime, CARatingArea, CAMasterDataDistrObjectXML. Part of development package FKK_MA.

Data Sources (1)

SourceAliasJoin Type
I_CAMasterDataDistrObject I_CAMasterDataDistrObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICAMDRECDWTHOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Master Data Distribution - Distrib. Records w/ Distrib. Data view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CAMasterDataDistrObjectType CAMasterDataDistrObjectType Object Type
KEY CAMasterDataDistrObject CAMasterDataDistrObject Distribution Obj. ID
KEY CreationDateTime CreationDateTime Timestamp
KEY CARatingArea CARatingArea Rating Area ID
KEY CAMasterDataDistrObjectXML CAMasterDataDistrObjectXML XML Object
KEY CAMasterDataDistrObjIsObsolete CAMasterDataDistrObjIsObsolete TRUE
KEY CAMasterDataDistrObjIsProcd CAMasterDataDistrObjIsProcd TRUE
CAMasterDataDistrObjectRef I_CAMasterDataDistrObject CAMasterDataDistrObjectRef UUID
CAMasterDataDistrRecdObjType CAMasterDataDistrRecdObjType
CAMasterDataDistrRecord CAMasterDataDistrRecord
CAMasterDataDistrRecordType CAMasterDataDistrRecordType
CAMasterDataDistrIsObsolete CAMasterDataDistrIsObsolete
CreationDate I_CAMasterDataDistrRecord CreationDate Time Stamp
CreationTime I_CAMasterDataDistrRecord CreationTime Time of Change
CAMstrDataDistrRecdExectdActn CAMstrDataDistrRecdExectdActn
CAMasterDataParentDistrObjType CAMasterDataParentDistrObjType
CAMasterDataParentDistrObjRef CAMasterDataParentDistrObjRef
SystemMessageType SystemMessageType Message type
SystemMessageClass SystemMessageClass Message ID
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
SystemMessageText SystemMessageText Message Text
SystemMsgsAreStoredSeparately SystemMsgsAreStoredSeparately
CAMasterDataDistrHasRatingArea CAMasterDataDistrHasRatingArea
CAMasterDataDepdntDistrObjType CAMasterDataDepdntDistrObjType
CAMasterDataDepdntDistrObj CAMasterDataDepdntDistrObj
CAMasterDataDistrRatingArea CAMasterDataDistrRatingArea

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_CAMstrDataDistrRecdWthObject.
-- 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.
-- SQL view name: ICAMDRECDWTHOBJ

CREATE VIEW I_CAMstrDataDistrRecdWthObject AS
SELECT
  CAMasterDataDistrObjectType,
  CAMasterDataDistrObject,
  CreationDateTime,
  CARatingArea,
  CAMasterDataDistrObjectXML,
  CAMasterDataDistrObjIsObsolete,
  CAMasterDataDistrObjIsProcd,
  I_CAMasterDataDistrObject.CAMasterDataDistrObjectRef AS CAMasterDataDistrObjectRef,
  CAMasterDataDistrRecdObjType,
  CAMasterDataDistrRecord,
  CAMasterDataDistrRecordType,
  CAMasterDataDistrIsObsolete,
  I_CAMasterDataDistrRecord.CreationDate AS CreationDate,
  I_CAMasterDataDistrRecord.CreationTime AS CreationTime,
  CAMstrDataDistrRecdExectdActn,
  CAMasterDataParentDistrObjType,
  CAMasterDataParentDistrObjRef,
  SystemMessageType,
  SystemMessageClass,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageText,
  SystemMsgsAreStoredSeparately,
  CAMasterDataDistrHasRatingArea,
  CAMasterDataDepdntDistrObjType,
  CAMasterDataDepdntDistrObj,
  CAMasterDataDistrRatingArea
FROM I_CAMasterDataDistrObject
;

Learn More