I_AccountingDocumentType

DDL: I_ACCOUNTINGDOCUMENTTYPE SQL: IFIACCDOCTYPE Type: view BASIC Package: FINS_JOURNAL_ENTRY_TYPE_VDM
8 Fields 1 Data Sources 1 Associations 8 OData Services

Journal Entry Type

I_AccountingDocumentType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_AccountingDocumentType is a Basic CDS View (Dimension) that provides data about "Journal Entry Type" in SAP S/4HANA. It reads from 1 data source (t003) and exposes 8 fields with key field AccountingDocumentType. It has 1 association to related views. It is exposed through 8 OData services (ASQL_F2547, ASQL_F2547A, ASQL_F2720, ...). Part of development package FINS_JOURNAL_ENTRY_TYPE_VDM.

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view provides the prerequisites for answering the following business questions: How many accounting document types are defined? Which number range is assigned to the accounting document type? Which authorization group is assigned to the accounting document type? Which exchange rate type is assigned to the accounting document type? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The following restriction type must be set to read access: BEGRU_BKPF_BLA (Authorization Groups for Journal Entry Document Type)

Structure
Further important fields Important fields in this view include the following: AccountingDocumentType AccountingDocumentNumberRange AuthorizationGroup ExchangeRateType AllowedFinancialAccountTypes

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-IS-2CL
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the master data of accounting document types. The attributes of the accounting document type business entity include the document type, the assigned number range, the authorization group, and the exchange rate type.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>How many accounting document types are defined?</p> </li> <li> <p>Which number range is assigned to the accounting document type?</p> </li> <li> <p>Which authorization group is assigned to the accounting document type?</p> </li> <li> <p>Which exchange rate type is assigned to the accounting document type?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t003 t003 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AccountingDocumentTypeText _Text $projection.AccountingDocumentType = _Text.AccountingDocumentType

Annotations (19)

NameValueLevelField
EndUserText.label Journal Entry Type view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IFIACCDOCTYPE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey AccountingDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F2547 ASQL_F2547 C2 NOT_RELEASED
ASQL_F2547A ASQL_F2547A C2 NOT_RELEASED
ASQL_F2720 ASQL_F2720 C2 NOT_RELEASED
ASQL_F4670A ASQL_F4670A C2 NOT_RELEASED
UI_ACCRUALS_MANAGE UI_ACCRUALS_MANAGE V2 C1 NOT_RELEASED
UI_CRCYADJUSTMENT_VERIFY UI_CRCYADJUSTMENT_VER V4 C1 NOT_RELEASED
UI_JOURNALENTRY_VERIFY UI_JOURNALENTRY_VER V4 C1 NOT_RELEASED
UI_PURCHASEORDERACCRS_DISPLAY UI_PURCHASEORDERACCRS_DSP V2 C1 NOT_RELEASED

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocumentType Rep. rec. doc. type
AccountingDocumentNumberRange numkr Number range Orders
AuthorizationGroup brgru Authorization Group
ExchangeRateType kurst Exchange Rate Type for Determining the Proposed Rate
AllowedFinancialAccountTypes koars Account Types Allowed
CustomerPostingIsAllowed Customer Posting Is Allowed
SupplierPostingIsAllowed Supplier Posting Is Allowed
_Text _Text

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_AccountingDocumentType.
-- 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.
-- SQL view name: IFIACCDOCTYPE

CREATE VIEW I_AccountingDocumentType AS
SELECT
  cast ( blart as farp_blart preserving type ) AS AccountingDocumentType,
  numkr AS AccountingDocumentNumberRange,
  brgru AS AuthorizationGroup,
  kurst AS ExchangeRateType,
  koars AS AllowedFinancialAccountTypes,
  cast( xkoad as fis_xkoad preserving type ) AS CustomerPostingIsAllowed,
  cast( xkoak as fis_xkoak preserving type ) AS SupplierPostingIsAllowed
FROM t003
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _Text ON AccountingDocumentType = _Text.AccountingDocumentType  -- association [0..*]
;

Learn More