I_ES_SIIAccountingDocType

DDL: I_ES_SIIACCOUNTINGDOCTYPE Type: view_entity BASIC
10 Fields 1 Data Sources

Spain SII Accounting Document Types

I_ES_SIIAccountingDocType is a Basic CDS View that provides data about "Spain SII Accounting Document Types" in SAP S/4HANA. It reads from 1 data source (fiessii_doctype) and exposes 10 fields with key fields CompanyCode, AccountingDocumentType.

Data Sources (1)

SourceAliasJoin Type
fiessii_doctype SIIAccDocType from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Spain SII Accounting Document Types view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode fiessii_doctype bukrs Value
KEY AccountingDocumentType fiessii_doctype blart Rep. rec. doc. type
ES_SIITaxRegimeCode fiessii_doctype tax_regime Tax Regime Scenario
ES_SIIInvoiceTypeCode fiessii_doctype inv_type SAF-T Inv. Type
ES_SIIIsThirdPartyInvoice fiessii_doctype third_party Issued byThird Party
ES_SIIInvoiceNumberSourceCode fiessii_doctype invnum_src1 Source Inv. No.
ES_SIIInvcNmbrSourceFieldName fiessii_doctype invnum_fld1 Field Inv. No.
ES_SIIInvcEndNumberSourceCode fiessii_doctype invnum_src2 Source Inv. End No.
ES_SIIInvcEndNmbrSrceFldName fiessii_doctype invnum_fld2 Field Inv. End. No.
ES_SIIReversalHandlingCode fiessii_doctype inv_typerev Handling of Reversal

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_SIIAccountingDocType.
-- 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_SIIAccountingDocType AS
SELECT
  SIIAccDocType.bukrs AS CompanyCode,
  SIIAccDocType.blart AS AccountingDocumentType,
  SIIAccDocType.tax_regime AS ES_SIITaxRegimeCode,
  SIIAccDocType.inv_type AS ES_SIIInvoiceTypeCode,
  SIIAccDocType.third_party AS ES_SIIIsThirdPartyInvoice,
  SIIAccDocType.invnum_src1 AS ES_SIIInvoiceNumberSourceCode,
  SIIAccDocType.invnum_fld1 AS ES_SIIInvcNmbrSourceFieldName,
  SIIAccDocType.invnum_src2 AS ES_SIIInvcEndNumberSourceCode,
  SIIAccDocType.invnum_fld2 AS ES_SIIInvcEndNmbrSrceFldName,
  SIIAccDocType.inv_typerev AS ES_SIIReversalHandlingCode
FROM fiessii_doctype AS SIIAccDocType
;

Learn More