HRP1990

Transparent Table Customizing Table
26 Fields 1 CDS Views

DB Table for Infotype 1990

HRP1990 is an SAP database table in S/4HANA. DB Table for Infotype 1990. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DFS_PositionNATO view from BASIC

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plvar PLVAR Plan version
KEY otype OTYPE Object type
KEY objid HROBJID Object ID
KEY subty SUBTYP Subtype
KEY istat ISTAT_D Planning status
KEY begda BEGDATUM Start date
KEY endda ENDDATUM End Date
KEY langu LANGU Language
KEY filler DUMMY_9 Dummy length 9
KEY seqnr SEQNR IT record no.
infty INFOTYP Infotype
otjid OTJID Obj.type/obj.ID
aedtm AEDTM Changed on
uname USRNAME User Name
reasn REASN Reason
histo HISTO Historical rec.
itxnr ITXNR Text Module
naton /ISDFPS/NATON NATO Pos. ID
natod /ISDFPS/NATOD NATO Rank
rotc1 /ISDFPS/ROTCOD NATO Code
rotc2 /ISDFPS/ROTCOD NATO Code
rotc3 /ISDFPS/ROTCOD NATO Code
rotc4 /ISDFPS/ROTCOD NATO Code
rotc5 /ISDFPS/ROTCOD NATO Code
rotc6 /ISDFPS/ROTCOD NATO Code

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.

-- DB Table for Infotype 1990
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRP1990 (
    MANDT,   -- Client [MANDT]
    PLVAR,   -- Plan version [PLVAR]
    OTYPE,   -- Object type [OTYPE]
    OBJID,   -- Object ID [HROBJID]
    SUBTY,   -- Subtype [SUBTYP]
    ISTAT,   -- Planning status [ISTAT_D]
    BEGDA,   -- Start date [BEGDATUM]
    ENDDA,   -- End Date [ENDDATUM]
    LANGU,   -- Language [LANGU]
    FILLER,  -- Dummy length 9 [DUMMY_9]
    SEQNR,   -- IT record no. [SEQNR]
    INFTY,   -- Infotype [INFOTYP]
    OTJID,   -- Obj.type/obj.ID [OTJID]
    AEDTM,   -- Changed on [AEDTM]
    UNAME,   -- User Name [USRNAME]
    REASN,   -- Reason [REASN]
    HISTO,   -- Historical rec. [HISTO]
    ITXNR,   -- Text Module [ITXNR]
    NATON,   -- NATO Pos. ID [/ISDFPS/NATON]
    NATOD,   -- NATO Rank [/ISDFPS/NATOD]
    ROTC1,   -- NATO Code [/ISDFPS/ROTCOD]
    ROTC2,   -- NATO Code [/ISDFPS/ROTCOD]
    ROTC3,   -- NATO Code [/ISDFPS/ROTCOD]
    ROTC4,   -- NATO Code [/ISDFPS/ROTCOD]
    ROTC5,   -- NATO Code [/ISDFPS/ROTCOD]
    ROTC6,   -- NATO Code [/ISDFPS/ROTCOD]
    PRIMARY KEY (MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, LANGU, FILLER, SEQNR)
);

Learn More