HRP1706

Transparent Table Customizing Table
25 Fields 2 CDS Views

DB table for infotype 1706

HRP1706 is an SAP database table in S/4HANA. DB table for infotype 1706. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FEE_CDS_ST view left_outer
PiqCds_StudentData view left_outer Student Data CDS VIew

Fields (25)

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 varyf VARYF Variation field
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
stfeecat PIQSTFEECAT Fee Category
bencat PIQBENCAT Benefit Cat.
pdisct1 PIQPDISCT1 Disc./Sur. 1
pdisct2 PIQPDISCT2 Disc./Sur. 2
pdisct3 PIQPDISCT3 Disc./Sur. 3
pdisct4 PIQPDISCT4 Disc./Sur. 4
pdisct5 PIQPDISCT5 Disc./Sur. 5
pdisct6 PIQPDISCT6 Disc./Sur. 6

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 1706
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRP1706 (
    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]
    VARYF,     -- Variation field [VARYF]
    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]
    STFEECAT,  -- Fee Category [PIQSTFEECAT]
    BENCAT,    -- Benefit Cat. [PIQBENCAT]
    PDISCT1,   -- Disc./Sur. 1 [PIQPDISCT1]
    PDISCT2,   -- Disc./Sur. 2 [PIQPDISCT2]
    PDISCT3,   -- Disc./Sur. 3 [PIQPDISCT3]
    PDISCT4,   -- Disc./Sur. 4 [PIQPDISCT4]
    PDISCT5,   -- Disc./Sur. 5 [PIQPDISCT5]
    PDISCT6,   -- Disc./Sur. 6 [PIQPDISCT6]
    PRIMARY KEY (MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, VARYF, SEQNR)
);

Learn More