Which tables does C_EDCDocumentList use?

C_EDCDocumentList reads from 3 data source(s): I_CountryText, I_EDCRecords, R_EDCType.

How many fields does C_EDCDocumentList have?

C_EDCDocumentList has 59 fields. Key fields: EDCRecordUUID.

C_EDCDocumentList

DDL: C_EDCDOCUMENTLIST Type: view_entity CONSUMPTION

EDC Consistency List

C_EDCDocumentList is a Consumption CDS View that provides data about "EDC Consistency List" in SAP S/4HANA. It reads from 3 data sources (I_CountryText, I_EDCRecords, R_EDCType) and exposes 59 fields with key field EDCRecordUUID. It has 7 associations to related views. It is exposed through 2 OData services (EDC_CHECK, EDC_PROCESS).

Data Sources (3)

Source	Alias	Join Type
I_CountryText	_CountryText	inner
I_EDCRecords	_EDCRecords	from
R_EDCType	_EDCType	inner

Associations (7)

Cardinality	Target	Alias	Condition
[1..*]	I_EDCRelation	_EDCRelation	`$projection.EDCRecordUUID = _EDCRelation.EDCRecordUUID`
[0..1]	R_EDCElectronicDoc	_ElectronicDoc	`_EDCRelationElectronicDocument.EDCRepresentationKey = _ElectronicDoc.ElectronicDocUUID`
[1..1]	C_CompanyCodeValueHelp	_CompanyCodeValueHelp	`$projection.EDCCompany = _CompanyCodeValueHelp.CompanyCode`
[1..1]	R_EDCMetaStatusText	_EDCMetaStatusText	`$projection.EDCMetaStatus = _EDCMetaStatusText.EDCMetaStatus and _EDCMetaStatusText.Language = $session.system_language`
[1..1]	I_TaxAuthorityDocument	_TaxAuthorityDocument	`_EDCRelationTaxAuthDocument.EDCRepresentationKey = _TaxAuthorityDocument.EDCTaxAuthRecordUUID`
[1..1]	I_JournalEntry	_JournalEntry	`_EDCAccountingDocRelation.CompanyCode = _JournalEntry.CompanyCode and _EDCAccountingDocRelation.AccountingDocument = _JournalEntry.AccountingDocument and _EDCAccountingDocRelation.FiscalYear = _JournalEntry.FiscalYear`
[1..1]	I_EDCBusinessPartner	_EDCBusinessPartner	`$projection.EDCRecordUUID = _EDCBusinessPartner.EDCRecordUUID`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.query.implementedBy	ABAP:CL_EDC_CDS_UNMANAGED_QUERY	view
EndUserText.label	EDC Consistency List	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

OData Services (2)

Service	Binding	Version	Contract	Release
EDC_CHECK	UI_EDC_CHECK_O2	V2	C1	NOT_RELEASED
EDC_PROCESS	UI_EDC_PROCESS_O2	V2	C1	NOT_RELEASED

Fields (59)

Key	Field	Source Table	Source Field	Description
KEY	EDCRecordUUID	I_EDCRecords	EDCRecordUUID	Consistency Unique Identifier
	EDCRunID	I_EDCRecords	EDCRunID
	EDCCompany	I_EDCRecords	EDCCompany
	EDCCommercialKey	I_EDCRecords	EDCCommercialKey
	EDCMetaStatus	I_EDCRecords	EDCMetaStatus
	EDCCreatedByUser	I_EDCRecords	EDCCreatedByUser
	EDCCreatedOnDateTime	I_EDCRecords	EDCCreatedOnDateTime
	EDCChangedByUser	I_EDCRecords	EDCChangedByUser
	EDCChangedOnDateTime	I_EDCRecords	EDCChangedOnDateTime
	EDCCheckDateTime	I_EDCRecords	EDCCheckDateTime
	EDCNumberOfExecutedChecks
	EDCNumberOfTotalChecks
	EDCNumberOfInProcessResults
	EDCNumberOfAllResults
	EDCNumberOfRelevantChecks
	EDCCommercialNavLink
	EDCOrganizationalUnit	I_EDCRecords	EDCOrganizationalUnit
	EDCOrganizationalUnitValue	I_EDCRecords	EDCOrganizationalUnitValue
	EDCSqncNmbr	I_EDCRecords	EDCSqncNmbr
	EDCType	I_EDCRecords	EDCType
	BusinessPartner	_EDCBusinessPartner	BusinessPartner	Business Partner
	ElectronicDocPostingDate	_ElectronicDoc	ElectronicDocPostingDate
	ElectronicDocCreationDate	_ElectronicDoc	ElectronicDocCreationDate
	ElectronicDocUUID	_ElectronicDoc	ElectronicDocUUID
	ElectronicDocSourceType	_ElectronicDoc	ElectronicDocSourceType
	ElectronicDocSourceTypeText	_ElectronicDoc	ElectronicDocSourceTypeText
	ElectronicDocType	_ElectronicDoc	ElectronicDocType
	ElectronicDocTypeText	_ElectronicDoc	ElectronicDocTypeText
	ElectronicDocProcessStatus	_ElectronicDoc	ElectronicDocProcessStatus
	ElectronicDocProcess	_ElectronicDoc	ElectronicDocProcess
	ElectronicDocProcessText	_ElectronicDoc	ElectronicDocProcessText
	ElectronicDocStatus	_ElectronicDoc	ElectronicDocStatus
	ElectronicDocSourceKey	_ElectronicDoc	ElectronicDocSourceKey
	ElectronicDocMetaStatus	_ElectronicDoc	ElectronicDocMetaStatus
	ElectronicDocProcStatusText	_ElectronicDoc	ElectronicDocProcStatusText
	AccountingDocument	_JournalEntry	AccountingDocument
	FiscalYear	_JournalEntry	FiscalYear
	AccountingDocumentType	_JournalEntry	AccountingDocumentType
	DocumentDate	_JournalEntry	DocumentDate
	PostingDate	_JournalEntry	PostingDate	Journal Entry Posting Date
	FiscalPeriod	_JournalEntry	FiscalPeriod
	AccountingDocumentCreationDate	_JournalEntry	AccountingDocumentCreationDate
	CreationTime	_JournalEntry	CreationTime
	DocumentReferenceID	_JournalEntry	DocumentReferenceID
	ReverseDocument	_JournalEntry	ReverseDocument	Reversal Document
	TransactionCurrency	_JournalEntry	TransactionCurrency
	TaxReportingDate	_JournalEntry	TaxReportingDate	Tax Reporting Date in Jrnl Entry
	TaxFulfillmentDate	_JournalEntry	TaxFulfillmentDate
	IsReversal	_JournalEntry	IsReversal
	EDCDocumentPeriod	_TaxAuthorityDocument	EDCDocumentPeriod
	EDCTaxAuthDocumentKey	_TaxAuthorityDocument	EDCTaxAuthDocumentKey
	EDCTaxAuthDocumentType	_TaxAuthorityDocument	EDCTaxAuthDocumentType
	EDCBusinessPartnerID	_TaxAuthorityDocument	EDCBusinessPartnerID
	EDCTaxAuthStatusText	_TaxAuthorityDocument	EDCTaxAuthStatusText
	CountryShortName	I_CountryText	CountryShortName
	_EDCRelation		_EDCRelation
	CompanyCodeName	_CompanyCodeValueHelp	CompanyCodeName
	EDCMetaStatusText	_EDCMetaStatusText	EDCMetaStatusText
	EDCCountry	R_EDCType	EDCCountry

@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.query.implementedBy:'ABAP:CL_EDC_CDS_UNMANAGED_QUERY'
@EndUserText.label: 'EDC Consistency List'
@VDM.viewType:#CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view entity C_EDCDocumentList
  as select from           I_EDCRecords               as _EDCRecords
    left outer to one join I_EDCRelation              as _EDCRelationElectronicDocument on  _EDCRecords.EDCRecordUUID                            = _EDCRelationElectronicDocument.EDCRecordUUID
                                                                                        and _EDCRelationElectronicDocument.EDCRepresentationType = 'EDOCUMENT'
                                                                                        and _EDCRecords.EDCType                                  = _EDCRelationElectronicDocument.EDCType
    left outer to one join I_EDCRelation              as _EDCRelationTaxAuthDocument    on  _EDCRecords.EDCRecordUUID                         = _EDCRelationTaxAuthDocument.EDCRecordUUID
                                                                                        and _EDCRelationTaxAuthDocument.EDCRepresentationType = 'TAXAUTHDOC'
                                                                                        and _EDCRecords.EDCType                               = _EDCRelationTaxAuthDocument.EDCType
    left outer to one join I_EDCAccountingDocRelation as _EDCAccountingDocRelation      on _EDCRecords.EDCRecordUUID = _EDCAccountingDocRelation.EDCRecordUUID
    inner join             R_EDCType                  as _EDCType                       on _EDCRecords.EDCType = _EDCType.EDCType
    inner join             I_CountryText              as _CountryText                   on  _EDCType.EDCCountry   = _CountryText.Country
                                                                                        and _CountryText.Language = $session.system_language

  association [1..*] to I_EDCRelation          as _EDCRelation          on  $projection.EDCRecordUUID = _EDCRelation.EDCRecordUUID

  association [0..1] to R_EDCElectronicDoc     as _ElectronicDoc        on  _EDCRelationElectronicDocument.EDCRepresentationKey = _ElectronicDoc.ElectronicDocUUID
  association [1..1] to C_CompanyCodeValueHelp as _CompanyCodeValueHelp on  $projection.EDCCompany = _CompanyCodeValueHelp.CompanyCode
  association [1..1] to R_EDCMetaStatusText    as _EDCMetaStatusText    on  $projection.EDCMetaStatus   = _EDCMetaStatusText.EDCMetaStatus
                                                                        and _EDCMetaStatusText.Language = $session.system_language
  association [1..1] to I_TaxAuthorityDocument as _TaxAuthorityDocument on  _EDCRelationTaxAuthDocument.EDCRepresentationKey = _TaxAuthorityDocument.EDCTaxAuthRecordUUID
  association [1..1] to I_JournalEntry         as _JournalEntry         on  _EDCAccountingDocRelation.CompanyCode        = _JournalEntry.CompanyCode
                                                                        and _EDCAccountingDocRelation.AccountingDocument = _JournalEntry.AccountingDocument
                                                                        and _EDCAccountingDocRelation.FiscalYear         = _JournalEntry.FiscalYear
  association [1..1] to I_EDCBusinessPartner   as _EDCBusinessPartner   on  $projection.EDCRecordUUID = _EDCBusinessPartner.EDCRecordUUID

{
          // Consistency Fields

          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          @EndUserText.label             : 'Consistency Unique Identifier'
  key     _EDCRecords.EDCRecordUUID,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          @UI.masked: true
          _EDCRecords.EDCRunID,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          @ObjectModel.text.element: ['CompanyCodeName']
          @UI.textArrangement: #TEXT_LAST
          _EDCRecords.EDCCompany,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCCommercialKey,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          @ObjectModel.text.element: ['EDCMetaStatusText']
          @UI.textArrangement: #TEXT_ONLY
          _EDCRecords.EDCMetaStatus,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCCreatedByUser,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCCreatedOnDateTime,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCChangedByUser,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCChangedOnDateTime,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCCheckDateTime,


          cast(0 as  abap.int8 )          as EDCNumberOfExecutedChecks,
          cast(0 as  abap.int8 )          as EDCNumberOfTotalChecks,
          cast(0 as  abap.int8 )          as EDCNumberOfInProcessResults,
          cast(0 as  abap.int8 )          as EDCNumberOfAllResults,
          cast(0 as  abap.int8 )          as EDCNumberOfRelevantChecks,
          cast( ' '  as  abap.char( 1 ) ) as EDCCommercialNavLink,

          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCOrganizationalUnit,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _EDCRecords.EDCOrganizationalUnitValue,
          _EDCRecords.EDCSqncNmbr,
          _EDCRecords.EDCType,

          @UI.fieldGroup: [{ qualifier: 'General' }]
          @EndUserText.label: 'Business Partner'
          _EDCBusinessPartner.BusinessPartner,

          //eDocument Specific Fields

          @UI.fieldGroup                 : [ { qualifier: 'EDOCUMENT'} ]
          _ElectronicDoc.ElectronicDocPostingDate,
          @UI.fieldGroup                 : [ { qualifier: 'EDOCUMENT'} ]
          _ElectronicDoc.ElectronicDocCreationDate,
          _ElectronicDoc.ElectronicDocUUID,
          @ObjectModel.text.element: ['ElectronicDocSourceTypeText']
          @UI.textArrangement: #TEXT_ONLY
          _ElectronicDoc.ElectronicDocSourceType,
          _ElectronicDoc.ElectronicDocSourceTypeText,
          @ObjectModel.text.element: ['ElectronicDocTypeText']
          @UI.textArrangement: #TEXT_ONLY
          _ElectronicDoc.ElectronicDocType,
          _ElectronicDoc.ElectronicDocTypeText,
          _ElectronicDoc.ElectronicDocProcessStatus,
          @ObjectModel.text.element: ['ElectronicDocProcessText']
          @UI.textArrangement: #TEXT_ONLY
          _ElectronicDoc.ElectronicDocProcess,
          _ElectronicDoc.ElectronicDocProcessText,
          _ElectronicDoc.ElectronicDocStatus,
          @UI.fieldGroup                 : [ { qualifier: 'General'} ]
          _ElectronicDoc.ElectronicDocSourceKey,
          _ElectronicDoc.ElectronicDocMetaStatus,
          _ElectronicDoc.ElectronicDocProcStatusText,

          //Journal Entry Fields

          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.AccountingDocument,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.FiscalYear,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.AccountingDocumentType,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.DocumentDate,
          @EndUserText.label             : 'Journal Entry Posting Date'
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.PostingDate,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.FiscalPeriod,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.AccountingDocumentCreationDate,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.CreationTime,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.DocumentReferenceID,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          @EndUserText.label             : 'Reversal Document'
          _JournalEntry.ReverseDocument,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.TransactionCurrency,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          @EndUserText.label             : 'Tax Reporting Date in Jrnl Entry'
          _JournalEntry.TaxReportingDate,
          @UI.fieldGroup                 : [ { qualifier: 'FI_INVOICE'} ]
          _JournalEntry.TaxFulfillmentDate,
          _JournalEntry.IsReversal,

          //Tax Authority Fields

          @UI.fieldGroup                 : [ { qualifier: 'TAXAUTHDOC'} ]
          _TaxAuthorityDocument.EDCDocumentPeriod,
          _TaxAuthorityDocument.EDCTaxAuthDocumentKey,
          _TaxAuthorityDocument.EDCTaxAuthDocumentType,
          _TaxAuthorityDocument.EDCBusinessPartnerID,
          _TaxAuthorityDocument.EDCTaxAuthStatusText,

          _CountryText.CountryShortName   as CountryShortName,

          // Association

          @ObjectModel.filter.enabled: false
          _EDCRelation,

          _CompanyCodeValueHelp.CompanyCodeName,

          _EDCMetaStatusText.EDCMetaStatusText,
          _EDCType.EDCCountry
}
where
  (
         _ElectronicDoc.ElectronicDocCountry =  'ES'
    and(
         _ElectronicDoc.ElectronicDocProcess is null
      or _ElectronicDoc.ElectronicDocProcess != 'ESSIIDEREG'
    )
    and(
         _JournalEntry.IsReversal            is null
      or _JournalEntry.IsReversal            is initial
    )
  )
  or(
         _ElectronicDoc.ElectronicDocCountry <> 'ES'
    or   _ElectronicDoc.ElectronicDocCountry is null
    or   _ElectronicDoc.ElectronicDocCountry is initial
  )
  and    _EDCRecords.EDCType                 != 'INGSTR1OUT'

Depth:

C_EDCDocumentList view_entity

I_EDCRecords view_entity
I_CountryText view
R_EDCType view_entity