I_CAMasterDataDistrObject

DDL: I_CAMASTERDATADISTROBJECT SQL: ICAMDDISTROBJ Type: view BASIC
16 Fields 1 Data Sources

Data on Distribution Object

I_CAMasterDataDistrObject is a Basic CDS View that provides data about "Data on Distribution Object" in SAP S/4HANA. It reads from 1 data source (dfkk_cc_do) and exposes 16 fields with key fields CAMasterDataDistrObjectType, CAMasterDataDistrObject.

Data Sources (1)

SourceAliasJoin Type
dfkk_cc_do dfkk_cc_do from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICAMDDISTROBJ 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 Data on Distribution Object view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CAMasterDataDistrObjectType do_objtype Object Type
KEY CAMasterDataDistrObject do_objid Distribution Obj. ID
CAProviderContract Distribution Obj. ID
CreationDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
CARatingArea rating_area Rating Area ID
CAMasterDataDistrObjectXML xml XML Object
CAMasterDataDistrObjIsObsolete obsolete TRUE
CAMasterDataDistrObjIsProcd processed TRUE
CAMasterDataDistrObjectStatus status Workflow Status
CAMasterDataDistrObjectRef obj_guid UUID
CreationDate erdat Entered On
CreationTime ertim Time
CAOldRatingArea rating_area_old Rating Area
CARatingAreaHasChanged rating_area_change Rating Area Change
CAClrfctnIsCompleted change_incomplete TRUE
_CARatingArea _CARatingArea

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_CAMasterDataDistrObject.
-- 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: ICAMDDISTROBJ

CREATE VIEW I_CAMasterDataDistrObject AS
SELECT
  do_objtype AS CAMasterDataDistrObjectType,
  do_objid AS CAMasterDataDistrObject,
  cast(do_objid as vtkey_kk) AS CAProviderContract,
  timestamp AS CreationDateTime,
  rating_area AS CARatingArea,
  xml AS CAMasterDataDistrObjectXML,
  obsolete AS CAMasterDataDistrObjIsObsolete,
  processed AS CAMasterDataDistrObjIsProcd,
  status AS CAMasterDataDistrObjectStatus,
  obj_guid AS CAMasterDataDistrObjectRef,
  erdat AS CreationDate,
  ertim AS CreationTime,
  rating_area_old AS CAOldRatingArea,
  rating_area_change AS CARatingAreaHasChanged,
  change_incomplete AS CAClrfctnIsCompleted
FROM dfkk_cc_do
;

Learn More