I_BusinessTransactionCategory

DDL: I_BUSINESSTRANSACTIONCATEGORY SQL: IBUSTRANCAT Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Business Transaction Category

I_BusinessTransactionCategory (Basic)

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

Business Transaction Category · Accounting and Financial Close

I_BusinessTransactionCategory is a Basic CDS View (Dimension) that provides data about "Business Transaction Category" in SAP S/4HANA. It reads from 1 data source (finsc_bttype) and exposes 5 fields with key field BusinessTransactionCategory. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Configuration Data
Data CategoryDimension
Purpose
This CDS view is designed to represent the business transaction categories within a financial system. It provides a structured way to access and analyze data related to different types of business transactions, including their categorization and period control attributes. The view is intended to be used as a dimension in analytical scenarios, allowing for data extraction and analysis. This CDS view provides the data to answer the following business questions: What are the different business transaction categories available in the system? Which business transactions are subject to period control? Is period control specific to a ledger for each business transaction category? Are business transactions checked by the leading ledger? What are the textual descriptions associated with each business transaction category? 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 corresponding restriction types must be set to read access. For a list of restriction types please see Authorizations in Analytics for Universal Journal . These restriction types are maintained in the Maintain Business Roles app.

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

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

Documentation

Data Sources (1)

SourceAliasJoin Type
finsc_bttype finsc_bttype from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusTransactionCategoryText _Text $projection.BusinessTransactionCategory = _Text.BusinessTransactionCategory

Annotations (17)

NameValueLevelField
ObjectModel.representativeKey BusinessTransactionCategory view
EndUserText.label Business Transaction Category view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IBUSTRANCAT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BusinessTransactionCategory Business Transaction Category
BusTransIsSubjToPerdControl xperiodcontrol Indicator: Bus. Trnsctn. can be relevant for Period Control
PeriodControlIsLedgerSpecific xperiodbyledger Indicator : Update by Ledger
PeriodIsCheckedByLeadingLedger xperiodbyleadingledger Indicator (obsolete): Check Period by Leading/Given Ledger
_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_BusinessTransactionCategory.
-- 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: IBUSTRANCAT

CREATE VIEW I_BusinessTransactionCategory AS
SELECT
  cast(bttype as fis_bttype preserving type ) AS BusinessTransactionCategory,
  xperiodcontrol AS BusTransIsSubjToPerdControl,
  xperiodbyledger AS PeriodControlIsLedgerSpecific,
  xperiodbyleadingledger AS PeriodIsCheckedByLeadingLedger
FROM finsc_bttype
LEFT OUTER JOIN I_BusTransactionCategoryText AS _Text ON BusinessTransactionCategory = _Text.BusinessTransactionCategory  -- association [0..*]
;

Learn More