I_ES_EDCElectronicDocRelation

DDL: I_ES_EDCELECTRONICDOCRELATION Type: view_entity COMPOSITE Package: GLO-EDO-ES-SII-EDC

Spain eDoc and Source Doc Relationship

I_ES_EDCElectronicDocRelation is a Composite CDS View that provides data about "Spain eDoc and Source Doc Relationship" in SAP S/4HANA. It reads from 3 data sources (I_ElectronicDoc, I_EDCRelation, I_ES_ElectronicDocAccountDoc) and exposes 28 fields with key fields EDCType, EDCRepresentationType, EDCRepresentationKey. Part of development package GLO-EDO-ES-SII-EDC.

3 data source(s) 28 fields

Data Sources (3)

SourceAliasJoin Type
I_ElectronicDoc _CustElectronicDoc inner
I_EDCRelation _EdcRelation from
I_ES_ElectronicDocAccountDoc _SourceDoc inner

Annotations (7)

NameValueLevelField
EndUserText.label Spain eDoc and Source Doc Relationship view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCRelation EDCType
KEY EDCRepresentationType I_EDCRelation EDCRepresentationType
KEY EDCRepresentationKey I_EDCRelation EDCRepresentationKey
EDCRecordUUID I_EDCRelation EDCRecordUUID
EDCCommonKey I_EDCRelation EDCCommonKey
EDCCompany I_EDCRelation EDCCompany
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
ElectronicDocMetaStatus I_ElectronicDoc ElectronicDocMetaStatus
CompanyName I_ES_ElectronicDocAccountDoc CompanyName
ES_ElectronicDocSIIIssuerIdn I_ES_ElectronicDocAccountDoc ES_ElectronicDocSIIIssuerIdn
FiscalYear I_ES_ElectronicDocAccountDoc FiscalYear
FiscalPeriod I_ES_ElectronicDocAccountDoc FiscalPeriod
TaxFulfillmentDate I_ES_ElectronicDocAccountDoc TaxFulfillmentDate 
@EndUserText.label: 'Spain eDoc and Source Doc Relationship'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #X,
  sizeCategory: #XXL
  }
define view entity I_ES_EDCElectronicDocRelation
  as select from I_EDCRelation                as _EdcRelation
    inner join   I_ElectronicDoc              as _CustElectronicDoc on _EdcRelation.EDCRepresentationKey = _CustElectronicDoc.ElectronicDocUUID
    inner join   I_ES_ElectronicDocAccountDoc as _SourceDoc         on _SourceDoc.ElectronicDocUUID = _CustElectronicDoc.ElectronicDocUUID

{
  key _EdcRelation.EDCType                              as EDCType,
  key _EdcRelation.EDCRepresentationType                as EDCRepresentationType,
  key _EdcRelation.EDCRepresentationKey                 as EDCRepresentationKey,
      _EdcRelation.EDCRecordUUID                        as EDCRecordUUID,
      _EdcRelation.EDCCommonKey                         as EDCCommonKey,
      _EdcRelation.EDCCompany                           as EDCCompany,
      
      _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,
      _CustElectronicDoc.ElectronicDocMetaStatus        as ElectronicDocMetaStatus,

      _SourceDoc.CompanyName                            as CompanyName,
      _SourceDoc.ES_ElectronicDocSIIIssuerIdn           as ES_ElectronicDocSIIIssuerIdn,
      _SourceDoc.FiscalYear                             as FiscalYear,
      _SourceDoc.FiscalPeriod                           as FiscalPeriod,
      _SourceDoc.TaxFulfillmentDate                     as TaxFulfillmentDate

}
where
      _EdcRelation.EDCRepresentationType      = 'EDOCUMENT'
  and _CustElectronicDoc.ElectronicDocCountry = 'ES'

Learn More