I_EDCELECTRONICDOCACCTGDOC

CDS View

Electronic Document Consistency Acc Doc

I_EDCELECTRONICDOCACCTGDOC is a CDS View in S/4HANA. Electronic Document Consistency Acc Doc. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_ES_EDCSalesInvoiceSIITaxItem view_entity from COMPOSITE Spain SII Customer Inv TaxLines
R_ES_EDCSuplrInvcSIITaxLine view_entity from COMPOSITE Spain Supplier Invoice Tax lines

Fields (5)

KeyField CDS FieldsUsed in Views
EDCCommonKey EDCCommonKey 2
EDCRecordUUID EDCRecordUUID 2
EDCRepresentationKey EDCRepresentationKey 2
EDCRepresentationType EDCRepresentationType 2
EDCType EDCType 2 
@AbapCatalog.sqlViewName: 'IEDCEDOCACC'
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Electronic Document Consistency Acc Doc'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #A,
  sizeCategory: #XXL
  }
define view I_EDCElectronicDocAcctgDoc  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'
                                                           and _CustElectronicDoc.ElectronicDocSourceType = 'FI_INVOICE'
{
  _CustElectronicDoc.ElectronicDocUUID              as ElectronicDocUUID,
  _CustElectronicDoc.ElectronicDocSequenceNmbr      as ElectronicDocSequenceNmbr,
  _CustElectronicDoc.ElectronicDocCompanyCode       as ElectronicDocCompanyCode,
  _CustElectronicDoc.ElectronicDocCountry           as ElectronicDocCountry,
  _CustElectronicDoc.ElectronicDocSourceType        as ElectronicDocSourceType,
  cast(substring(_CustElectronicDoc.ElectronicDocSourceKey, 5, 10) as belnr_d) as AccountingDocument,
  cast(substring(_CustElectronicDoc.ElectronicDocSourceKey, 15, 4) as gjahr)   as FiscalYear,
  _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,
  _EdcRelation.EDCType                              as EDCType,
  _EdcRelation.EDCRepresentationType                as EDCRepresentationType,
  _EdcRelation.EDCRepresentationKey                 as EDCRepresentationKey,
  _EdcRelation.EDCRecordUUID                        as EDCRecordUUID,
  _EdcRelation.EDCCommonKey                         as EDCCommonKey

}

Learn More