I_ES_TaxAuthDocumentRelation

DDL: I_ES_TAXAUTHDOCUMENTRELATION Type: view_entity BASIC

I_ES_TaxAuthDocumentRelation is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_ES_TaxAuthorityDocument) and exposes 25 fields with key fields EDCTaxAuthRecordUUID, EDCTaxAuthSqncNmbr.

Data Sources (1)

SourceAliasJoin Type
I_ES_TaxAuthorityDocument _TaxAuthDoc from

Annotations (5)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY EDCTaxAuthRecordUUID I_ES_TaxAuthorityDocument EDCTaxAuthRecordUUID
KEY EDCTaxAuthSqncNmbr I_ES_TaxAuthorityDocument EDCTaxAuthSqncNmbr
EDCCompany I_ES_TaxAuthorityDocument EDCCompany
EDCCountry I_ES_TaxAuthorityDocument EDCCountry
EDCCommonKey I_ES_TaxAuthorityDocument EDCCommonKey
EDCTaxAuthDocumentKey I_ES_TaxAuthorityDocument EDCTaxAuthDocumentKey
EDCDocumentPeriod I_ES_TaxAuthorityDocument EDCDocumentPeriod
EDCTaxAuthDocumentType I_ES_TaxAuthorityDocument EDCTaxAuthDocumentType
EDCBusinessPartnerID I_ES_TaxAuthorityDocument EDCBusinessPartnerID
EDCTaxAuthStatus I_ES_TaxAuthorityDocument EDCTaxAuthStatus
EDCStatusChangeDate I_ES_TaxAuthorityDocument EDCStatusChangeDate
EDCApplicationLogID I_ES_TaxAuthorityDocument EDCApplicationLogID
EDCCreatedByUser I_ES_TaxAuthorityDocument EDCCreatedByUser
EDCCreatedOnDateTime I_ES_TaxAuthorityDocument EDCCreatedOnDateTime
EDCChangedByUser I_ES_TaxAuthorityDocument EDCChangedByUser
EDCChangedOnDateTime I_ES_TaxAuthorityDocument EDCChangedOnDateTime
EDCCompanyName I_ES_TaxAuthorityDocument EDCCompanyName
ES_ElectronicDocSIIDeclarerTIN I_ES_TaxAuthorityDocument ES_ElectronicDocSIIDeclarerTIN
ES_EDCReportingPeriod I_ES_TaxAuthorityDocument ES_EDCReportingPeriod
ES_EDCReportingYear I_ES_TaxAuthorityDocument ES_EDCReportingYear
EDCTaxFulfillmentDate I_ES_TaxAuthorityDocument EDCTaxFulfillmentDate
EDCType _EdcRelation EDCType
EDCRepresentationType _EdcRelation EDCRepresentationType
EDCRepresentationKey _EdcRelation EDCRepresentationKey
EDCRecordUUID _EdcRelation EDCRecordUUID

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_TaxAuthDocumentRelation.
-- 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_TaxAuthDocumentRelation AS
SELECT
  _TaxAuthDoc.EDCTaxAuthRecordUUID AS EDCTaxAuthRecordUUID,
  _TaxAuthDoc.EDCTaxAuthSqncNmbr AS EDCTaxAuthSqncNmbr,
  _TaxAuthDoc.EDCCompany AS EDCCompany,
  _TaxAuthDoc.EDCCountry AS EDCCountry,
  _TaxAuthDoc.EDCCommonKey AS EDCCommonKey,
  _TaxAuthDoc.EDCTaxAuthDocumentKey AS EDCTaxAuthDocumentKey,
  _TaxAuthDoc.EDCDocumentPeriod AS EDCDocumentPeriod,
  _TaxAuthDoc.EDCTaxAuthDocumentType AS EDCTaxAuthDocumentType,
  _TaxAuthDoc.EDCBusinessPartnerID AS EDCBusinessPartnerID,
  _TaxAuthDoc.EDCTaxAuthStatus AS EDCTaxAuthStatus,
  _TaxAuthDoc.EDCStatusChangeDate AS EDCStatusChangeDate,
  _TaxAuthDoc.EDCApplicationLogID AS EDCApplicationLogID,
  _TaxAuthDoc.EDCCreatedByUser AS EDCCreatedByUser,
  _TaxAuthDoc.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _TaxAuthDoc.EDCChangedByUser AS EDCChangedByUser,
  _TaxAuthDoc.EDCChangedOnDateTime AS EDCChangedOnDateTime,
  _TaxAuthDoc.EDCCompanyName AS EDCCompanyName,
  _TaxAuthDoc.ES_ElectronicDocSIIDeclarerTIN AS ES_ElectronicDocSIIDeclarerTIN,
  _TaxAuthDoc.ES_EDCReportingPeriod AS ES_EDCReportingPeriod,
  _TaxAuthDoc.ES_EDCReportingYear AS ES_EDCReportingYear,
  _TaxAuthDoc.EDCTaxFulfillmentDate AS EDCTaxFulfillmentDate,
  _EdcRelation.EDCType AS EDCType,
  _EdcRelation.EDCRepresentationType AS EDCRepresentationType,
  _EdcRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _EdcRelation.EDCRecordUUID AS EDCRecordUUID
FROM I_ES_TaxAuthorityDocument AS _TaxAuthDoc
;