I_EDCElectronicDocRelation

DDL: I_EDCELECTRONICDOCRELATION Type: view_entity BASIC

eDocument Consistency Relationship

I_EDCElectronicDocRelation is a Basic CDS View that provides data about "eDocument Consistency Relationship" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 21 fields.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc _CustElectronicDoc from

Annotations (7)

NameValueLevelField
EndUserText.label eDocument Consistency Relationship view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view

Fields (21)

KeyFieldSource TableSource FieldDescription
ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID
ElectronicDocSequenceNmbr I_ElectronicDoc ElectronicDocSequenceNmbr
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode
ElectronicDocCountry I_ElectronicDoc ElectronicDocCountry
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey
ElectronicDocType I_ElectronicDoc ElectronicDocType
ElectronicDocProcessStatus I_ElectronicDoc ElectronicDocProcessStatus
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate
ElectronicDocLastChangeDate I_ElectronicDoc ElectronicDocLastChangeDate
ElectronicDocLastChangeTime I_ElectronicDoc ElectronicDocLastChangeTime
ElectronicDocPostingDate I_ElectronicDoc ElectronicDocPostingDate
ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess
ElectronicDocCreatedByUser I_ElectronicDoc ElectronicDocCreatedByUser
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime
ElectronicDocSrceCreatedByUser I_ElectronicDoc ElectronicDocSrceCreatedByUser
EDCType _EdcRelation EDCType
EDCRepresentationType _EdcRelation EDCRepresentationType
EDCRepresentationKey _EdcRelation EDCRepresentationKey
EDCRecordUUID _EdcRelation EDCRecordUUID
EDCCommonKey _EdcRelation EDCCommonKey 
@EndUserText.label: 'eDocument Consistency Relationship'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #A,
  sizeCategory: #XXL
  }
define view entity I_EDCElectronicDocRelation
  as select from           I_ElectronicDoc as _CustElectronicDoc
    left outer to one join I_EDCRelation   as _EdcRelation on  _EdcRelation.EDCRepresentationKey  = _CustElectronicDoc.ElectronicDocUUID
                                                           and _EdcRelation.EDCRepresentationType = 'EDOCUMENT'
{
  _CustElectronicDoc.ElectronicDocUUID              as ElectronicDocUUID,
  _CustElectronicDoc.ElectronicDocSequenceNmbr      as ElectronicDocSequenceNmbr,
  _CustElectronicDoc.ElectronicDocCompanyCode       as ElectronicDocCompanyCode,
  _CustElectronicDoc.ElectronicDocCountry           as ElectronicDocCountry,
  _CustElectronicDoc.ElectronicDocSourceType        as ElectronicDocSourceType,
  _CustElectronicDoc.ElectronicDocSourceKey         as ElectronicDocSourceKey,
  _CustElectronicDoc.ElectronicDocType              as ElectronicDocType,
  _CustElectronicDoc.ElectronicDocProcessStatus     as ElectronicDocProcessStatus,
  _CustElectronicDoc.ElectronicDocCreationDate      as ElectronicDocCreationDate,
  _CustElectronicDoc.ElectronicDocLastChangeDate    as ElectronicDocLastChangeDate,
  _CustElectronicDoc.ElectronicDocLastChangeTime    as ElectronicDocLastChangeTime,
  _CustElectronicDoc.ElectronicDocPostingDate       as ElectronicDocPostingDate,
  _CustElectronicDoc.ElectronicDocProcess           as ElectronicDocProcess,
  _CustElectronicDoc.ElectronicDocCreatedByUser     as ElectronicDocCreatedByUser,
  _CustElectronicDoc.ElectronicDocCreationTime      as ElectronicDocCreationTime,
  _CustElectronicDoc.ElectronicDocSrceCreatedByUser as ElectronicDocSrceCreatedByUser,
  _EdcRelation.EDCType                              as EDCType,
  _EdcRelation.EDCRepresentationType                as EDCRepresentationType,
  _EdcRelation.EDCRepresentationKey                 as EDCRepresentationKey,
  _EdcRelation.EDCRecordUUID                        as EDCRecordUUID,
  _EdcRelation.EDCCommonKey                         as EDCCommonKey

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EDCRELATION",
"I_ELECTRONICDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More