HRP1000

Transparent Table Customizing Table
22 Fields 51 CDS Views

Infotype 1000 DB Table

HRP1000 is an SAP database table in S/4HANA. Infotype 1000 DB Table. It contains 22 fields. 51 CDS views read from this table.

CDS Views using this table (51)

ViewTypeJoinVDMDescription
/SAM4U/BTL_L_PRICING_TENANT view from Pricing for Tenant
hriq_cds_st_sc view inner
I_AcademicEventBooking view inner COMPOSITE Academic Event Booking Data
I_ChangeRecordAccCtrlCntxtText view from BASIC Access Control Context Text
I_DocInfoRecordAccCtrlCntxtT view_entity from BASIC Access Control Context - Text
I_FrcElmntOrgTextDEX view_entity from BASIC Force Element Name Extractor
I_HCMCourse view_entity from BASIC Available Courses
I_HCMCourseLocation view_entity from BASIC Location
I_HCMObject view from BASIC HCM Object
I_InsurClmOrganization view from BASIC Basis View für Tabelle HRP1000
I_LogAccMContextText view from BASIC Access Control Context Text
I_MDGovWrkflwOrg view from BASIC MDG Change Req Wrkflw Procsr Org Details
I_MfgQualificationGroup view inner BASIC Display HR Qualification Group and its Catalog
I_OrgManagementPositionText view from BASIC Table for Position with Text
I_PersonWorkAgrmtJobText view from BASIC Person Work Agreement Jobs with Text
I_ResponsibleSalesOrgUnitIDVH view inner BASIC Sales Organization Unit
I_SrvcMgmtOrganizationUnit view from BASIC Service Management Organizational Unit
I_SrvcMgmtOrganizationUnitText view from BASIC Srvc Mgmt Organizational Unit - Text
I_SubscrpnMassProcgSlsOrgUnt view_entity inner BASIC Sales Organization Unit
I_TMOrganizationalUnitText view from BASIC Organizational Unit Text
I_TransportationGnrcOrgUnitTxt view_entity from BASIC Transportation Org Unit - Text
P_DFS_ObjectName view from BASIC
P_FrcElmntOrgName view from BASIC
P_J_PDOBJECT view from BASIC
P_MfgQualification view from BASIC
P_MfgQualificationGroupList view inner BASIC
P_PDOBJECT view from BASIC
P_PDOBJECT_001 view from BASIC
P_PMDepartmentResponsibleBasic view_entity inner BASIC
P_PMPositionResponsibleBasic view_entity inner BASIC
P_RespyMgmtOrgUnitBPRelshp view from BASIC
P_RespyMgmtTeamHeaderMainObj view from BASIC
P_RespyMgmtTeamOrgUnitName view from BASIC
PiqCds_AcademicEventData view left_outer Academic Event Data
PiqCds_AcademicEventLocation view left_outer Academic Event Location Data
PiqCds_AcademicEventModule view left_outer Academic Event Module Relationship Data
PiqCds_AcademicEventPackage view left_outer Academic Event Package Relationship Data
PiqCds_AcademicHoldData view left_outer Academic Hold Data
PiqCds_AcdmcEventBookingData view inner Academic Event Booking Data
PiqCds_GradingData view inner Grading/appraisal information
PiqCds_ModuleBookingData view left_outer Module Data
PiqCds_OrgUnitPrograms view inner Programs in an organizational unit/department
PiqCds_OrgUnitPrograms view left_outer Programs in an organizational unit/department
PiqCds_ProgramStudy view inner Get study objects for program of study
PiqCds_ProgramStudy view left_outer Get study objects for program of study
PiqCds_ProgressionData view inner Progression Data
PiqCds_SpecializationStudy view left_outer Get Study for Specialization
PiqCds_StudentData view left_outer Student Data CDS VIew
PiqCds_StudyProgram view left_outer Get Study Objects for Program of Study
PiqCds_StudyStudentAdmission view inner Get students for a study object
PiqCds_StudyStudentRegn view inner Get Students for a Study Object

Fields (22)

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
aedtm AEDTM Changed on
uname USRNAME User Name
reasn REASN Reason
histo HISTO Historical rec.
itxnr ITXNR Text Module
short SHORT_D Object abbr.
stext STEXT Name
gdate GDATE Delimit date
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.

-- Infotype 1000 DB Table
-- 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]
    AEDTM,     -- Changed on [AEDTM]
    UNAME,     -- User Name [USRNAME]
    REASN,     -- Reason [REASN]
    HISTO,     -- Historical rec. [HISTO]
    ITXNR,     -- Text Module [ITXNR]
    SHORT,     -- Object abbr. [SHORT_D]
    STEXT,     -- Name [STEXT]
    GDATE,     -- Delimit date [GDATE]
    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