HRP1000

Transparent Table Customizing Table
14 Fields 15 CDS Views

DB-Tabelle zum Infotyp 1000

HRP1000 is an SAP database table in S/4HANA. DB-Tabelle zum Infotyp 1000. It contains 14 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
/SAM4U/BTL_L_PRICING_TENANT view from Pricing for Tenant
I_ChangeRecordAccCtrlCntxtText view from BASIC Access Control Context Text
I_InsurClmOrganization view from BASIC Basis View für Tabelle HRP1000
I_LogAccMContextText view from BASIC Access Control Context Text
I_MfgQualificationGroup view inner BASIC Display HR Qualification Group and its Catalog
I_OrgManagementPositionText view from BASIC Table for Position with Text
I_SrvcMgmtOrganizationUnit view_entity from BASIC Service Management Organizational Unit
I_SrvcMgmtOrganizationUnitText view_entity from BASIC Srvc Mgmt Organizational Unit - Text
P_MfgQualification view from BASIC Display HR Qualifications data
P_MfgQualificationGroupList view inner BASIC Display list of Qualification Group and Catalog
P_PDOBJECT view from BASIC PD Object
P_PDOBJECT_001 view from BASIC PD Object
P_RespyMgmtOrgUnitBPRelshp view from BASIC basic View to get Org Unit and BP Relationship
P_RespyMgmtTeamHeaderMainObj view from BASIC Team Header Main Object
P_RespyMgmtTeamOrgUnitName view from BASIC Obsolete - Organizational Unit Name

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY plvar plvar Plan version
KEY otype otype Object type
KEY objid hrobjid Object ID
KEY istat istat_d Planning status
KEY begda begdatum Start date
KEY endda enddatum End Date
KEY langu langu Language
KEY seqnr seqnr IT record no.
otjid otjid Obj.type/obj.ID
infty infotyp Infotype
mc_short hr_mcshort Object abbr.
mc_stext hr_mcstext Name
mc_seark hr_mcseark Search term

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-Tabelle zum Infotyp 1000
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRP1000 (
    MANDT,     -- Client [mandt]
    PLVAR,     -- Plan version [plvar]
    OTYPE,     -- Object type [otype]
    OBJID,     -- Object ID [hrobjid]
    ISTAT,     -- Planning status [istat_d]
    BEGDA,     -- Start date [begdatum]
    ENDDA,     -- End Date [enddatum]
    LANGU,     -- Language [langu]
    SEQNR,     -- IT record no. [seqnr]
    OTJID,     -- Obj.type/obj.ID [otjid]
    INFTY,     -- Infotype [infotyp]
    MC_SHORT,  -- Object abbr. [hr_mcshort]
    MC_STEXT,  -- Name [hr_mcstext]
    MC_SEARK,  -- Search term [hr_mcseark]
    PRIMARY KEY (MANDT, PLVAR, OTYPE, OBJID, ISTAT, BEGDA, ENDDA, LANGU, SEQNR)
);

Learn More