SAP PIQ_SQL_HRP1001 table - Generated Table for View details in SAP


SAP PIQ_SQL_HRP1001 table summary

Object Name: PIQ_SQL_HRP1001
Dictionary Type: Table view
Description: Generated Table for View


Field list for PIQ_SQL_HRP1001 table on an S/4 SAP system

Details
PIQ_SQL_HRP1001-CLIENT table field - Client

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

PIQ_SQL_HRP1001-OBJECTTYPE table field - Object Type

Description: Object Type
Field Name: OBJECTTYPE
Data Element: OTYPE
Data Type: CHAR
length (Dec): 2(0)
Check table: T778O
Conversion Routine:
Domain Name: OTYPE
MemoryID: POT
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTTYPE

PIQ_SQL_HRP1001-OBJECTID table field - Object ID

Description: Object ID
Field Name: OBJECTID
Data Element: HROBJID
Data Type: NUMC
length (Dec): 8(0)
Check table: PLOGI
Conversion Routine:
Domain Name: HROBJID
MemoryID: PON
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTID

PIQ_SQL_HRP1001-ACTIVEPLANVERSION table field - Plan Version

Description: Plan Version
Field Name: ACTIVEPLANVERSION
Data Element: PLVAR
Data Type: CHAR
length (Dec): 2(0)
Check table: T778P
Conversion Routine:
Domain Name: PLVAR
MemoryID: POP
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTIVEPLANVERSION

PIQ_SQL_HRP1001-RELATIONSHIPDIRECTION table field - Relationship Specification

Description: Relationship Specification
Field Name: RELATIONSHIPDIRECTION
Data Element: RSIGN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RSIGN
MemoryID:
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIONSHIPDIRECTION

PIQ_SQL_HRP1001-RELATIONSHIPNUMBER table field - Relationship Between Objects

Description: Relationship Between Objects
Field Name: RELATIONSHIPNUMBER
Data Element: RELAT
Data Type: CHAR
length (Dec): 3(0)
Check table: T778V
Conversion Routine:
Domain Name: RELAT
MemoryID:
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIONSHIPNUMBER

PIQ_SQL_HRP1001-RELATIONSTATUS table field - Planning Status

Description: Planning Status
Field Name: RELATIONSTATUS
Data Element: ISTAT_D
Data Type: CHAR
length (Dec): 1(0)
Check table: T778S
Conversion Routine:
Domain Name: ISTAT
MemoryID: PST
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIONSTATUS

PIQ_SQL_HRP1001-PRIORITY table field - Priority

Description: Priority
Field Name: PRIORITY
Data Element: PRIOX
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRIORITY

PIQ_SQL_HRP1001-STARTDATE table field - Start Date

Description: Start Date
Field Name: STARTDATE
Data Element: BEGDATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID: BEG
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STARTDATE

PIQ_SQL_HRP1001-ENDDATE table field - End Date

Description: End Date
Field Name: ENDDATE
Data Element: ENDDATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID: END
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENDDATE

PIQ_SQL_HRP1001-VARIATIONFIELD table field - Variation Field for File PLOG

Description: Variation Field for File PLOG
Field Name: VARIATIONFIELD
Data Element: VARYF
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VARIATIONFIELD

PIQ_SQL_HRP1001-SEQUENCENUMBER table field - Number of Infotype Record With Same Key

Description: Number of Infotype Record With Same Key
Field Name: SEQUENCENUMBER
Data Element: SEQNR
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUM03
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEQUENCENUMBER

PIQ_SQL_HRP1001-INFOTYPE table field - Infotype

Description: Infotype
Field Name: INFOTYPE
Data Element: INFOTYP
Data Type: CHAR
length (Dec): 4(0)
Check table: T778T
Conversion Routine:
Domain Name: INFOTYP
MemoryID:
AppClass: PP
SHLP: HRBAS00INFTY
SHLP Field: INFTY
ConvExit:

See all SAP tables containing field INFOTYPE

PIQ_SQL_HRP1001-OBJECTTYPEANDID table field - Concatenation of Object Type and Object ID

Description: Concatenation of Object Type and Object ID
Field Name: OBJECTTYPEANDID
Data Element: OTJID
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTTYPEANDID

PIQ_SQL_HRP1001-RELATIONSHIPSUBTYPE table field - Subtype

Description: Subtype
Field Name: RELATIONSHIPSUBTYPE
Data Element: SUBTYP
Data Type: CHAR
length (Dec): 4(0)
Check table: T778U
Conversion Routine:
Domain Name: SUBTYP
MemoryID:
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIONSHIPSUBTYPE

PIQ_SQL_HRP1001-CHANGEDON table field - Changed on

Description: Changed on
Field Name: CHANGEDON
Data Element: AEDTM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGEDON

PIQ_SQL_HRP1001-CHANGEDUSERNAME table field - User Name

Description: User Name
Field Name: CHANGEDUSERNAME
Data Element: USRNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGEDUSERNAME

PIQ_SQL_HRP1001-CHANGEREASON table field - Reason

Description: Reason
Field Name: CHANGEREASON
Data Element: REASN
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGEREASON

PIQ_SQL_HRP1001-HISTORICALRECORDFLAG table field - Historical Record Flag

Description: Historical Record Flag
Field Name: HISTORICALRECORDFLAG
Data Element: HISTO
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HISTORICALRECORDFLAG

PIQ_SQL_HRP1001-INFOTYPETEXTMODULE table field - Text Module for Infotype

Description: Text Module for Infotype
Field Name: INFOTYPETEXTMODULE
Data Element: ITXNR
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: NUM08
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INFOTYPETEXTMODULE

PIQ_SQL_HRP1001-WEIGHTINGPERCENTAGE table field - Weighting Percentage

Description: Weighting Percentage
Field Name: WEIGHTINGPERCENTAGE
Data Element: PROZT
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DEC3_2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WEIGHTINGPERCENTAGE

PIQ_SQL_HRP1001-RELATEDOBJECTTYPE table field - Type of Related Object

Description: Type of Related Object
Field Name: RELATEDOBJECTTYPE
Data Element: SCLAS
Data Type: CHAR
length (Dec): 2(0)
Check table: T778O
Conversion Routine:
Domain Name: OTYPE
MemoryID:
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATEDOBJECTTYPE

PIQ_SQL_HRP1001-RELATEDOBJECTID table field - ID of Related Object

Description: ID of Related Object
Field Name: RELATEDOBJECTID
Data Element: SOBID
Data Type: CHAR
length (Dec): 45(0)
Check table:
Conversion Routine:
Domain Name: CHAR45
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATEDOBJECTID

PIQ_SQL_HRP1001-ADDDATANUMBERINTID table field - ADATA Number

Description: ADATA Number
Field Name: ADDDATANUMBERINTID
Data Element: HRADATANR
Data Type: CHAR
length (Dec): 32(0)
Check table: HRIADATANR
Conversion Routine:
Domain Name: HRADATANR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDDATANUMBERINTID


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table