HRPAD506

Transparent Table Application Table
26 Fields 3 CDS Views

Additional Data for PAD506

HRPAD506 is an SAP database table in S/4HANA. Additional Data for PAD506. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
PiqCds_GradingData view inner Grading/appraisal information
PiqCds_ModuleBkgOffers view inner Offerings of a module
PiqCds_ModuleBookingData view left_outer Module Data

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY adatanr HRADATANR ADATA number
smstatus PIQSMSTATUS Booking Status
storreason PIQSTORREASON Canc. Reason
stordate PIQSTORDATE Canc.Date
cpattemp PIQCPATTEMP Attm. credits
cpgained PIQCPGAINED Earned Credits
cpunit PIQCPUNIT Credit Type
norm_val PIQSCALE_NORM_VAL Standard Value
bookdate PIQDATE Booking Date
booktime PIQWAITL_TIME Booking Time
smrating PIQSMRATING Assess. Method
chargefree PIQCHARGE Free of Charge
transferflag PIQTRANSFER Transferred
packnumber PIQSLNUM Event Package
varid PIQVARID Sess. Variant
perid PIQPERID Acad. Session
peryr PIQPERYR Acad. Year
alt_scaleid PIQSCALE_ID Scale ID
id PIQMODREG_ID Module Bkg ID
bookreason PIQBOOKREASON Booking Reason
annulment PIQMODREG_ANNULMENT Exclusion
lockflag PIQAWLOCKFLAG Change Lock
cobok PIQPEPE_COBOK Cond. Bkg
booking_subgroup_id PIQBOOKING_SUBGROUP_ID Booking SubGroup ID
attno_tw PIQATTNO_TW Attempt Number

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.

-- Additional Data for PAD506
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRPAD506 (
    MANDT,                -- Client [MANDT]
    ADATANR,              -- ADATA number [HRADATANR]
    SMSTATUS,             -- Booking Status [PIQSMSTATUS]
    STORREASON,           -- Canc. Reason [PIQSTORREASON]
    STORDATE,             -- Canc.Date [PIQSTORDATE]
    CPATTEMP,             -- Attm. credits [PIQCPATTEMP]
    CPGAINED,             -- Earned Credits [PIQCPGAINED]
    CPUNIT,               -- Credit Type [PIQCPUNIT]
    NORM_VAL,             -- Standard Value [PIQSCALE_NORM_VAL]
    BOOKDATE,             -- Booking Date [PIQDATE]
    BOOKTIME,             -- Booking Time [PIQWAITL_TIME]
    SMRATING,             -- Assess. Method [PIQSMRATING]
    CHARGEFREE,           -- Free of Charge [PIQCHARGE]
    TRANSFERFLAG,         -- Transferred [PIQTRANSFER]
    PACKNUMBER,           -- Event Package [PIQSLNUM]
    VARID,                -- Sess. Variant [PIQVARID]
    PERID,                -- Acad. Session [PIQPERID]
    PERYR,                -- Acad. Year [PIQPERYR]
    ALT_SCALEID,          -- Scale ID [PIQSCALE_ID]
    ID,                   -- Module Bkg ID [PIQMODREG_ID]
    BOOKREASON,           -- Booking Reason [PIQBOOKREASON]
    ANNULMENT,            -- Exclusion [PIQMODREG_ANNULMENT]
    LOCKFLAG,             -- Change Lock [PIQAWLOCKFLAG]
    COBOK,                -- Cond. Bkg [PIQPEPE_COBOK]
    BOOKING_SUBGROUP_ID,  -- Booking SubGroup ID [PIQBOOKING_SUBGROUP_ID]
    ATTNO_TW,             -- Attempt Number [PIQATTNO_TW]
    PRIMARY KEY (MANDT, ADATANR)
);

Learn More