I_CADocContainerCorrespnc

DDL: I_CADOCCONTAINERCORRESPNC Type: view_entity BASIC
9 Fields 1 Data Sources 1 Associations

Document Container Correspondence

I_CADocContainerCorrespnc is a Basic CDS View that provides data about "Document Container Correspondence" in SAP S/4HANA. It reads from 1 data source (dfkkdcc) and exposes 9 fields with key fields CADocumentContainerUUID, CACorrespondenceType, CACorrespondence, CADocCtnCorrespncSqncNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkdcc dfkkdcc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CACorrespondenceType _CorrespondenceType $projection.CACorrespondenceType = _CorrespondenceType.CACorrespondenceType

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Container Correspondence view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CADocumentContainerUUID ident Tree Structure
KEY CACorrespondenceType cotyp Destin. Type
KEY CACorrespondence cokey Correspond. Key
KEY CADocCtnCorrespncSqncNumber seqno Tab Seq. No.
CorrespondencePrintDate copri Print Date
CorrespondenceCreationDate crdat Generation Time
CorrespondenceCreationTime crtim Time
_DocContainer _DocContainer
_CorrespondenceType _CorrespondenceType

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_CADocContainerCorrespnc.
-- 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_CADocContainerCorrespnc AS
SELECT
  ident AS CADocumentContainerUUID,
  cotyp AS CACorrespondenceType,
  cokey AS CACorrespondence,
  seqno AS CADocCtnCorrespncSqncNumber,
  copri AS CorrespondencePrintDate,
  crdat AS CorrespondenceCreationDate,
  crtim AS CorrespondenceCreationTime
FROM dfkkdcc
LEFT OUTER JOIN I_CACorrespondenceType AS _CorrespondenceType ON CACorrespondenceType = _CorrespondenceType.CACorrespondenceType  -- association [1..1]
;

Learn More