R_ES_EDCTaxAuthSIITaxable

DDL: R_ES_EDCTAXAUTHSIITAXABLE Type: view_entity COMPOSITE Package: GLO-EDO-ES-SII-EDC
14 Fields 3 Data Sources

Spain SII Tax Auth Item for Taxable

R_ES_EDCTaxAuthSIITaxable is a Composite CDS View that provides data about "Spain SII Tax Auth Item for Taxable" in SAP S/4HANA. It reads from 3 data sources (I_TaxAuthorityDocument, I_EDCRelation, R_ES_TaxAuthoritySIITaxable) and exposes 14 fields. Part of development package GLO-EDO-ES-SII-EDC.

Data Sources (3)

SourceAliasJoin Type
I_TaxAuthorityDocument _EDCTaxAuthDocument inner
I_EDCRelation EDCRelation from
R_ES_TaxAuthoritySIITaxable TATaxItem inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Spain SII Tax Auth Item for Taxable view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
EDCRepresentationType I_EDCRelation EDCRepresentationType Rep. Type
EDCRepresentationKey R_ES_TaxAuthoritySIITaxable EDCRepresentationKey UUID
ES_EDocSIISalesNonResident R_ES_TaxAuthoritySIITaxable ES_EDocSIISalesNonResident Sales to Non-Residen
ES_EDocSIITaxClassification R_ES_TaxAuthoritySIITaxable ES_EDocSIITaxClassification Tax Classification
CompanyCode I_EDCRelation EDCCompany Value
EDCTaxRate R_ES_TaxAuthoritySIITaxable EDCTaxRate
EDCTaxableAmount R_ES_TaxAuthoritySIITaxable EDCTaxableAmount Taxable Amount
EDCTaxAmount R_ES_TaxAuthoritySIITaxable EDCTaxAmount Tax Amt in Rptg Crcy
ES_EDocSIIEqualizationRate R_ES_TaxAuthoritySIITaxable ES_EDocSIIEqualizationRate
ES_EDocSIIEqualizationAmount R_ES_TaxAuthoritySIITaxable ES_EDocSIIEqualizationAmount BSI: Tax class amoun
EDCCurrency R_ES_TaxAuthoritySIITaxable EDCCurrency Valuation Crcy
EDCType I_EDCRelation EDCType Consistency Scen.
EDCRecordUUID I_EDCRelation EDCRecordUUID Consistency GUID
EDCCommonKey I_EDCRelation EDCCommonKey Common Key

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 R_ES_EDCTaxAuthSIITaxable.
-- 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 R_ES_EDCTaxAuthSIITaxable AS
SELECT
  EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  TATaxItem.EDCRepresentationKey AS EDCRepresentationKey,
  TATaxItem.ES_EDocSIISalesNonResident AS ES_EDocSIISalesNonResident,
  TATaxItem.ES_EDocSIITaxClassification AS ES_EDocSIITaxClassification,
  EDCRelation.EDCCompany AS CompanyCode,
  TATaxItem.EDCTaxRate AS EDCTaxRate,
  TATaxItem.EDCTaxableAmount AS EDCTaxableAmount,
  TATaxItem.EDCTaxAmount AS EDCTaxAmount,
  TATaxItem.ES_EDocSIIEqualizationRate AS ES_EDocSIIEqualizationRate,
  TATaxItem.ES_EDocSIIEqualizationAmount AS ES_EDocSIIEqualizationAmount,
  TATaxItem.EDCCurrency AS EDCCurrency,
  EDCRelation.EDCType AS EDCType,
  EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  EDCRelation.EDCCommonKey AS EDCCommonKey
FROM I_EDCRelation AS EDCRelation
INNER JOIN I_TaxAuthorityDocument AS _EDCTaxAuthDocument ON /* join condition not captured in parsed metadata */
INNER JOIN R_ES_TaxAuthoritySIITaxable AS TATaxItem ON /* join condition not captured in parsed metadata */
;

Learn More