I_BusinessArea

DDL: I_BUSINESSAREA SQL: IFIBUSAREA Type: view BASIC Package: FINS_BUSINESS_AREA_VDM

Business Area

I_BusinessArea (Basic)

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

BusinessArea · Accounting and Financial Close

I_BusinessArea is a Basic CDS View (Dimension) that provides data about "Business Area" in SAP S/4HANA. It reads from 1 data source (tgsb) and exposes 3 fields with key field BusinessArea. It has 2 associations to related views. It is exposed through 21 OData services (ASQL_F2242, ASQL_F3991, ASQL_F4173A, ...). Part of development package FINS_BUSINESS_AREA_VDM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A-2CL
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
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

Documentation

Data Sources (1)

SourceAliasJoin Type
tgsb tgsb from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BusinessAreaText _Text $projection.BusinessArea = _Text.BusinessArea
[0..*] I_BusinessAreaHierNode _BusinessAreaHierNode $projection.BusinessArea = _BusinessAreaHierNode.BusinessArea

Annotations (20)

NameValueLevelField
EndUserText.label Business Area view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIBUSAREA view
ObjectModel.representativeKey BusinessArea view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.numberOfKeyFields 1 view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Search.searchable true view
AbapCatalog.preserveKey true view
ObjectModel.sapObjectNodeType.name BusinessArea view

OData Services (21)

ServiceBindingVersionContractRelease
ASQL_F2242 ASQL_F2242 C2 NOT_RELEASED
ASQL_F3991 ASQL_F3991 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4272 ASQL_F4272 C2 NOT_RELEASED
ASQL_F4423 ASQL_F4423 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F6109 ASQL_F6109 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F6990 ASQL_F6990 C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
FARR_SD_REV_CATCHUP FARR_SDB_REV_CATCHUP V2 C1 NOT_RELEASED
UI_BILLINGDOCUMENT_MANAGE UI_BILLINGDOCUMENT_MANAGE V4 C1 NOT_RELEASED
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE V4 C1 NOT_RELEASED
UI_PRELIMBILLINGDOCUMENT_F6990 UI_PRELIMBILLINGDOCUMENT_F6990 V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessArea gsber Business Area
_Text _Text
_BusinessAreaHierNode _BusinessAreaHierNode

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_BusinessArea.
-- 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: IFIBUSAREA

CREATE VIEW I_BusinessArea AS
SELECT
  gsber AS BusinessArea
FROM tgsb
LEFT OUTER JOIN I_BusinessAreaText AS _Text ON BusinessArea = _Text.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaHierNode AS _BusinessAreaHierNode ON BusinessArea = _BusinessAreaHierNode.BusinessArea  -- association [0..*]
;