I_ES_TaxAuthDocumentEDocCheck

DDL: I_ES_TAXAUTHDOCUMENTEDOCCHECK Type: view_entity COMPOSITE
43 Fields 1 Data Sources

Tax Auth Document Vs eDocument

I_ES_TaxAuthDocumentEDocCheck is a Composite CDS View that provides data about "Tax Auth Document Vs eDocument" in SAP S/4HANA. It reads from 1 data source (I_ES_TaxAuthDocumentRelation) and exposes 43 fields with key fields EDCType, EDCRepresentationType, EDCRepresentationKey.

Data Sources (1)

SourceAliasJoin Type
I_ES_TaxAuthDocumentRelation _TaxAuthDocRelation from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Tax Auth Document Vs eDocument view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_ES_TaxAuthDocumentRelation EDCType
KEY EDCRepresentationType I_ES_TaxAuthDocumentRelation EDCRepresentationType
KEY EDCRepresentationKey I_ES_TaxAuthDocumentRelation EDCRepresentationKey
EDCTaxAuthRecordUUID I_ES_TaxAuthDocumentRelation EDCTaxAuthRecordUUID
EDCTaxAuthSqncNmbr I_ES_TaxAuthDocumentRelation EDCTaxAuthSqncNmbr
EDCCompany I_ES_TaxAuthDocumentRelation EDCCompany
EDCCountry I_ES_TaxAuthDocumentRelation EDCCountry
EDCCommonKey I_ES_TaxAuthDocumentRelation EDCCommonKey
EDCTaxAuthDocumentKey I_ES_TaxAuthDocumentRelation EDCTaxAuthDocumentKey
EDCTaxAuthDocumentType I_ES_TaxAuthDocumentRelation EDCTaxAuthDocumentType
EDCBusinessPartnerID I_ES_TaxAuthDocumentRelation EDCBusinessPartnerID
EDCTaxAuthStatus I_ES_TaxAuthDocumentRelation EDCTaxAuthStatus
EDCStatusChangeDate I_ES_TaxAuthDocumentRelation EDCStatusChangeDate
EDCApplicationLogID I_ES_TaxAuthDocumentRelation EDCApplicationLogID
EDCCreatedByUser I_ES_TaxAuthDocumentRelation EDCCreatedByUser
EDCCreatedOnDateTime I_ES_TaxAuthDocumentRelation EDCCreatedOnDateTime
EDCChangedByUser I_ES_TaxAuthDocumentRelation EDCChangedByUser
EDCChangedOnDateTime I_ES_TaxAuthDocumentRelation EDCChangedOnDateTime
EDCCompanyName I_ES_TaxAuthDocumentRelation EDCCompanyName
ES_ElectronicDocSIIDeclarerTIN I_ES_TaxAuthDocumentRelation ES_ElectronicDocSIIDeclarerTIN
ES_EDCReportingYear I_ES_TaxAuthDocumentRelation ES_EDCReportingYear
ES_EDCReportingPeriod I_ES_TaxAuthDocumentRelation ES_EDCReportingPeriod
EDCTaxFulfillmentDate I_ES_TaxAuthDocumentRelation EDCTaxFulfillmentDate
EDCRecordUUID I_ES_TaxAuthDocumentRelation EDCRecordUUID
ElectronicDocUUID _CustElectronicDoc ElectronicDocUUID
ElectronicDocSequenceNmbr _CustElectronicDoc ElectronicDocSequenceNmbr
ElectronicDocCompanyCode _CustElectronicDoc ElectronicDocCompanyCode
ElectronicDocCountry _CustElectronicDoc ElectronicDocCountry
ElectronicDocSourceType _CustElectronicDoc ElectronicDocSourceType
ElectronicDocSourceKey _CustElectronicDoc ElectronicDocSourceKey
ElectronicDocType _CustElectronicDoc ElectronicDocType
ElectronicDocProcessStatus _CustElectronicDoc ElectronicDocProcessStatus
ElectronicDocCreatedByUser _CustElectronicDoc ElectronicDocCreatedByUser
ElectronicDocCreationDate _CustElectronicDoc ElectronicDocCreationDate
ElectronicDocCreationTime _CustElectronicDoc ElectronicDocCreationTime
ElectronicDocSrceCreatedByUser _CustElectronicDoc ElectronicDocSrceCreatedByUser
ElectronicDocProcess
ElectronicDocMetaStatus _CustElectronicDoc ElectronicDocMetaStatus
CompanyName _CustElectronicDoc CompanyName Text
ES_ElectronicDocSIIIssuerIdn _CustElectronicDoc ES_ElectronicDocSIIIssuerIdn
FiscalYear _CustElectronicDoc FiscalYear G/L Fiscal Year
FiscalPeriod _CustElectronicDoc FiscalPeriod Tax period
TaxFulfillmentDate _CustElectronicDoc TaxFulfillmentDate Tax Settlement Date

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_ES_TaxAuthDocumentEDocCheck.
-- 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_ES_TaxAuthDocumentEDocCheck AS
SELECT
  _TaxAuthDocRelation.EDCType AS EDCType,
  _TaxAuthDocRelation.EDCRepresentationType AS EDCRepresentationType,
  _TaxAuthDocRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _TaxAuthDocRelation.EDCTaxAuthRecordUUID AS EDCTaxAuthRecordUUID,
  _TaxAuthDocRelation.EDCTaxAuthSqncNmbr AS EDCTaxAuthSqncNmbr,
  _TaxAuthDocRelation.EDCCompany AS EDCCompany,
  _TaxAuthDocRelation.EDCCountry AS EDCCountry,
  _TaxAuthDocRelation.EDCCommonKey AS EDCCommonKey,
  _TaxAuthDocRelation.EDCTaxAuthDocumentKey AS EDCTaxAuthDocumentKey,
  _TaxAuthDocRelation.EDCTaxAuthDocumentType AS EDCTaxAuthDocumentType,
  _TaxAuthDocRelation.EDCBusinessPartnerID AS EDCBusinessPartnerID,
  _TaxAuthDocRelation.EDCTaxAuthStatus AS EDCTaxAuthStatus,
  _TaxAuthDocRelation.EDCStatusChangeDate AS EDCStatusChangeDate,
  _TaxAuthDocRelation.EDCApplicationLogID AS EDCApplicationLogID,
  _TaxAuthDocRelation.EDCCreatedByUser AS EDCCreatedByUser,
  _TaxAuthDocRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _TaxAuthDocRelation.EDCChangedByUser AS EDCChangedByUser,
  _TaxAuthDocRelation.EDCChangedOnDateTime AS EDCChangedOnDateTime,
  _TaxAuthDocRelation.EDCCompanyName AS EDCCompanyName,
  _TaxAuthDocRelation.ES_ElectronicDocSIIDeclarerTIN AS ES_ElectronicDocSIIDeclarerTIN,
  _TaxAuthDocRelation.ES_EDCReportingYear AS ES_EDCReportingYear,
  _TaxAuthDocRelation.ES_EDCReportingPeriod AS ES_EDCReportingPeriod,
  _TaxAuthDocRelation.EDCTaxFulfillmentDate AS EDCTaxFulfillmentDate,
  _TaxAuthDocRelation.EDCRecordUUID AS EDCRecordUUID,
  _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.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  _CustElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _CustElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  _CustElectronicDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  coalesce( _CustElectronicDoc.ElectronicDocProcess, ' ' ) AS ElectronicDocProcess,
  _CustElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _CustElectronicDoc.CompanyName AS CompanyName,
  _CustElectronicDoc.ES_ElectronicDocSIIIssuerIdn AS ES_ElectronicDocSIIIssuerIdn,
  _CustElectronicDoc.FiscalYear AS FiscalYear,
  _CustElectronicDoc.FiscalPeriod AS FiscalPeriod,
  _CustElectronicDoc.TaxFulfillmentDate AS TaxFulfillmentDate
FROM I_ES_TaxAuthDocumentRelation AS _TaxAuthDocRelation
;

Learn More