I_AccountAssignmentTypeT

DDL: I_ACCOUNTASSIGNMENTTYPET SQL: IFIACTASSGNMT Type: view BASIC
5 Fields 1 Data Sources

Account Assignment Type - Text

I_AccountAssignmentTypeT (Basic)

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

Accounting and Financial Close

I_AccountAssignmentTypeT is a Basic CDS View that provides data about "Account Assignment Type - Text" in SAP S/4HANA. It reads from 1 data source (tbo01) and exposes 5 fields with key fields Language, AccountAssignmentType.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesData Source for Data Extraction, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Search
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tbo01 tbo01 from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIACTASSGNMT view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Account Assignment Type - Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey AccountAssignmentType view
VDM.viewType #BASIC view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY AccountAssignmentType Object type
AccountAssignmentTypeName FIS_ACCASTY_TXT20
AccountAssignmentTypeDesc FIS_ACCASTY_TXT60
AcctAsgtTypeLanguageDependent Three-character, language-dependent value for object type

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_AccountAssignmentTypeT.
-- 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: IFIACTASSGNMT

CREATE VIEW I_AccountAssignmentTypeT AS
SELECT
  spras AS Language,
  cast(obart as j_obart preserving type ) AS AccountAssignmentType,
  cast(txt20 as fis_accasty_txt20 preserving type ) AS AccountAssignmentTypeName,
  cast (txt60 as fis_accasty_txt60 preserving type ) AS AccountAssignmentTypeDesc,
  cast(obart_ld as fis_j_obart3 preserving type ) AS AcctAsgtTypeLanguageDependent
FROM tbo01
;

Learn More