T500P

Transparent Table Customizing Table
15 Fields 2 CDS Views

Personnel Areas

T500P is an SAP database table in S/4HANA. Personnel Areas. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FrcElmntOrgPersonnelArea view from BASIC Interface View for Personnel Area
I_HCMPersonnelArea view_entity from BASIC HCM Personnel Area

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY persa PERSA Personnel area
molga MOLGA HCM Local.
bukrs BUKRS Company Code
name1 PBTXT PA text
name2 NAME2 Name 2
stras STRAS Street/House
pfach PFACH PO Box
pstlz PSTLZ Postal Code
ort01 ORT01 City
land1 LAND1 Country/Reg.
regio REGIO Region
counc COUNC County Code
cityc CITYC City Code
adrnr ADRNR Address

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.

-- Personnel Areas
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T500P (
    MANDT,  -- Client [MANDT]
    PERSA,  -- Personnel area [PERSA]
    MOLGA,  -- HCM Local. [MOLGA]
    BUKRS,  -- Company Code [BUKRS]
    NAME1,  -- PA text [PBTXT]
    NAME2,  -- Name 2 [NAME2]
    STRAS,  -- Street/House [STRAS]
    PFACH,  -- PO Box [PFACH]
    PSTLZ,  -- Postal Code [PSTLZ]
    ORT01,  -- City [ORT01]
    LAND1,  -- Country/Reg. [LAND1]
    REGIO,  -- Region [REGIO]
    COUNC,  -- County Code [COUNC]
    CITYC,  -- City Code [CITYC]
    ADRNR,  -- Address [ADRNR]
    PRIMARY KEY (MANDT, PERSA)
);

Learn More