I_AccountingClerk

DDL: I_ACCOUNTINGCLERK Type: view BASIC Package: FINS_ACCOUNTING_CLERK_VDM
5 Fields 1 Data Sources 1 Associations

Accounting Clerk

I_AccountingClerk (Basic)

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

Accounting Clerk · Accounting and Financial Close

I_AccountingClerk is a Basic CDS View (Dimension) that provides data about "Accounting Clerk" in SAP S/4HANA. It reads from 1 data source (t001s) and exposes 5 fields with key fields CompanyCode, AccountingClerk. It has 1 association to related views. Part of development package FINS_ACCOUNTING_CLERK_VDM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A-2CL
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities,Data Source for Search
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 the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which accounting clerks are defined for accounts receivable and accounts payable transactions?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t001s t001s from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _Company _Company.CompanyCode = $projection.CompanyCode

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFIACCCLERK view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Accounting Clerk view
ObjectModel.representativeKey AccountingClerk view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name AccountingClerk view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Company Code
KEY AccountingClerk Accounting Clerk
AccountingClerkName Name of Accounting Clerk
UserID User Name
_Company _Company

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_AccountingClerk.
-- 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_AccountingClerk AS
SELECT
  cast (bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast (busab as farp_busab preserving type ) AS AccountingClerk,
  cast (sname as farp_sname_001s preserving type ) AS AccountingClerkName,
  cast( usnam as vdm_userid preserving type ) AS UserID
FROM t001s
LEFT OUTER JOIN I_CompanyCode AS _Company ON _Company.CompanyCode = CompanyCode  -- association [0..1]
;

Learn More