FISCDS_ADRP

CDS View
13 Fields

User Office Data

FISCDS_ADRP is a CDS View in S/4HANA. User Office Data. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY addrnumber AddressId 1
KEY bname UserKey 1
building Building 1
department Department 1
floor Floor 1
function FunctionalTitleName 1
id_code CorrespondenceShortName 1
ih_mail InhouseMail 1
name_first FirstName 1
name_last LastName 1
name_text PersonFullName 1
roomnumber RoomNumber 1
title title 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- User Office Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FISCDS_ADRP (
    ADDRNUMBER,
    BNAME,
    BUILDING,
    DEPARTMENT,
    FLOOR,
    FUNCTION,
    ID_CODE,
    IH_MAIL,
    NAME_FIRST,
    NAME_LAST,
    NAME_TEXT,
    ROOMNUMBER,
    TITLE,
    PRIMARY KEY (ADDRNUMBER, BNAME)
);

Learn More