R_ES_EDCTaxAuthSIIExempt

DDL: R_ES_EDCTAXAUTHSIIEXEMPT Type: view_entity COMPOSITE Package: GLO-EDO-ES-SII-EDC
10 Fields 2 Data Sources

Spain SII Consistency Tax Authority Exempt items

R_ES_EDCTaxAuthSIIExempt is a Composite CDS View that provides data about "Spain SII Consistency Tax Authority Exempt items" in SAP S/4HANA. It reads from 2 data sources (I_EDCRelation, R_ES_TaxAuthoritySIIExempt) and exposes 10 fields. Part of development package GLO-EDO-ES-SII-EDC.

Data Sources (2)

SourceAliasJoin Type
I_EDCRelation EDCRelation from
R_ES_TaxAuthoritySIIExempt TATaxItem inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Spain SII Consistency Tax Authority Exempt items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
EDCRepresentationType I_EDCRelation EDCRepresentationType Rep. Type
EDCRepresentationKey R_ES_TaxAuthoritySIIExempt EDCRepresentationKey UUID
ES_EDocSIISalesNonResident R_ES_TaxAuthoritySIIExempt ES_EDocSIISalesNonResident Sales to Non-Residen
ExemptionReason R_ES_TaxAuthoritySIIExempt ExemptionReason Exempt. Reason
CompanyCode I_EDCRelation EDCCompany Value
EDCExemptionAmount R_ES_TaxAuthoritySIIExempt EDCExemptionAmount BSI: Tax class amoun
EDCCurrency R_ES_TaxAuthoritySIIExempt 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_EDCTaxAuthSIIExempt.
-- 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_EDCTaxAuthSIIExempt AS
SELECT
  EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  TATaxItem.EDCRepresentationKey AS EDCRepresentationKey,
  TATaxItem.ES_EDocSIISalesNonResident AS ES_EDocSIISalesNonResident,
  TATaxItem.ExemptionReason AS ExemptionReason,
  EDCRelation.EDCCompany AS CompanyCode,
  TATaxItem.EDCExemptionAmount AS EDCExemptionAmount,
  TATaxItem.EDCCurrency AS EDCCurrency,
  EDCRelation.EDCType AS EDCType,
  EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  EDCRelation.EDCCommonKey AS EDCCommonKey
FROM I_EDCRelation AS EDCRelation
INNER JOIN R_ES_TaxAuthoritySIIExempt AS TATaxItem ON /* join condition not captured in parsed metadata */
;

Learn More