fiscds_adrp

DDL: FISVD_ADRP_OFFICE SQL: FISV_ADRP Type: view Package: FINS_FIS_GL
20 Fields 1 Data Sources

User Office Data

fiscds_adrp is a CDS View that provides data about "User Office Data" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 20 fields with key field bname. Part of development package FINS_FIS_GL.

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FISV_ADRP view
EndUserText.label User Office Data view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY bname usr21 bname User name
persnumber adcp persnumber Person Number
addrnumber adcp addrnumber Address Number
name_first adrp name_first First Name
name_last adrp name_last Last Name
name_text adrp name_text Full Name
title adrp title View Title
title_aca1 adrp title_aca1 Academic Title
department adcp department Department
function adcp function Unit Func.
building adcp building Building code
floor adcp floor Floor
roomnumber adcp roomnumber Room Number
id_code adcp id_code Short name
ih_mail adcp ih_mail Internal mail
deflt_comm adcp deflt_comm Comm. Method
tel_number adcp tel_number Telephone
tel_extens adcp tel_extens Extension
fax_number adcp fax_number Fax Number
fax_extens adcp fax_extens Extension

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 fiscds_adrp.
-- 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: FISV_ADRP

CREATE VIEW fiscds_adrp AS
SELECT
  usr21.bname AS bname,
  adcp.persnumber AS persnumber,
  adcp.addrnumber AS addrnumber,
  adrp.name_first AS name_first,
  adrp.name_last AS name_last,
  adrp.name_text AS name_text,
  adrp.title AS title,
  adrp.title_aca1 AS title_aca1,
  adcp.department AS department,
  adcp.function AS function,
  adcp.building AS building,
  adcp.floor AS floor,
  adcp.roomnumber AS roomnumber,
  adcp.id_code AS id_code,
  adcp.ih_mail AS ih_mail,
  adcp.deflt_comm AS deflt_comm,
  adcp.tel_number AS tel_number,
  adcp.tel_extens AS tel_extens,
  adcp.fax_number AS fax_number,
  adcp.fax_extens AS fax_extens
FROM usr21
;

Learn More