HRP1950

DB Table for Infotype 1950 | #masterdata | Component: Structures Workbench

🔑 Keys (10)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical
Other (11)
🔗 Relations (18)

Column Name	Description
MANDT FK	Client
PLVAR FK	Plan Version
OTYPE FK	Object Type
OBJID FK	Object ID
SUBTY FK	Subtype
ISTAT FK	Planning Status
BEGDA	Start Date
ENDDA	End Date
VARYF	Variation Field for File PLOG
SEQNR	Number of Infotype Record With Same Key

Column Name	Description

Column Name	Description

Column Name	Description
BEGDA	Start Date
ENDDA	End Date
AEDTM	Changed on

Column Name	Description

Column Name	Description	Domain name
OTJID	Concatenation of Object Type and Object ID	CHAR10
UNAME	User Name	CHAR12
REASN	Reason	CHAR2
HISTO	Historical Record Flag	CHAR1
ITXNR	Text Module for Infotype	NUM08
AGENCY	Agency
BRANCHS_ID	Branch Addition
SC	Symbol Code
UIC	UIC Number	NUMC06
DFS_UIC	UIC for Characteristics
UIC_PARAGRAPH	UIC Paragraph for Characteristics

Master Data Relations	Join Conditions
Activity Code for Characteristics Activity Code for Characteristics Organizational Area	`HRP1950.MANDT == DFS_FE_ACTIVITY.MANDT` `HRP1950.ACTIVITY_CODE == DFS_FE_ACTIVITY.ACTIVITY_CODE` `HRP1950.SERVICE_ID == DFS_FE_ACTIVITY.ORG_AREA`
Branch Country/Region Key Branch Client Organizational Area	`HRP1950.OWNER_NATION == /ISDFPS/CBRANCH.OWNER_NATION` `HRP1950.BRANCH_ID == /ISDFPS/CBRANCH.BRANCH_ID` `HRP1950.MANDT == /ISDFPS/CBRANCH.MANDT` `HRP1950.SERVICE_ID == /ISDFPS/CBRANCH.SERVICE_ID`
Usage Type	`HRP1950.MANDT == /ISDFPS/CCTYPE.MANDT` `HRP1950.CASE_TYPE == /ISDFPS/CCTYPE.CASE_TYPE`
Structure Type Structure Type Client Country/Region Key Organizational Area Structure Level	`HRP1950.FORCE_LEVEL == /ISDFPS/CFLEVEL.FORCE_LEVEL` `HRP1950.MANDT == /ISDFPS/CFLEVEL.MANDT` `HRP1950.OWNER_NATION == /ISDFPS/CFLEVEL.OWNER_NATION` `HRP1950.SERVICE_ID == /ISDFPS/CFLEVEL.SERVICE_ID` `HRP1950.LEVEL_GROUP == /ISDFPS/CFLEVEL.LEVEL_GROUP`
Infotype	`HRP1950.MANDT == T778T.MANDT` `HRP1950.INFTY == T778T.INFTY`
Planning Status	`HRP1950.MANDT == T778S.MANDT` `HRP1950.ISTAT == T778S.ISTAT`
Structure Type Structure Level Organizational Area Type	`HRP1950.MANDT == /ISDFPS/CLGROUP.MANDT` `HRP1950.LEVEL_GROUP == /ISDFPS/CLGROUP.LEVEL_GROUP` `HRP1950.SERVICE_TYPE == /ISDFPS/CLGROUP.SERVICE_TYPE`
Client	`HRP1950.MANDT == T000.MANDT`
Object ID Object Type Plan Version Client Object ID	`HRP1950.OTYPE == PLOGI.OTYPE` `HRP1950.PLVAR == PLOGI.PLVAR` `HRP1950.MANDT == PLOGI.MANDT` `HRP1950.OBJID == PLOGI.OBJID`
Object Type	`HRP1950.MANDT == T778O.MANDT` `HRP1950.OTYPE == T778O.OTYPE`
Country/Region Key Country/Region Key Client	`HRP1950.OWNER_NATION == T005.LAND1` `HRP1950.MANDT == T005.MANDT`
Plan Version	`HRP1950.MANDT == T778P.MANDT` `HRP1950.PLVAR == T778P.PLVAR`
Priority for Characteristics Organizational Area Priority for Characteristics Client	`HRP1950.SERVICE_ID == DFS_FE_PRIORITY.ORG_AREA` `HRP1950.PRIORITY_KEY == DFS_FE_PRIORITY.PRIORITY_KEY` `HRP1950.MANDT == DFS_FE_PRIORITY.MANDT`
Object ID ? ? Client Object ID	`HRP1950.[column in domain "OTYPE"] == PLOGI.OTYPE` `HRP1950.[column in domain "PLVAR"] == PLOGI.PLVAR` `HRP1950.MANDT == PLOGI.MANDT` `HRP1950.REF_OBJID == PLOGI.OBJID`
Sensitivity for Characteristics	`HRP1950.MANDT == DFS_FE_SENSTVTY.MANDT` `HRP1950.SENSITIVITY_KEY == DFS_FE_SENSTVTY.SENSITIVITY_KEY`
Organizational Area Country/Region Key Organizational Area Client	`HRP1950.OWNER_NATION == /ISDFPS/CSERV.OWNER_NATION` `HRP1950.SERVICE_ID == /ISDFPS/CSERV.SERVICE_ID` `HRP1950.MANDT == /ISDFPS/CSERV.MANDT`
Organizational Area Type Organizational Area Type Client	`HRP1950.SERVICE_TYPE == /ISDFPS/CLSERV.SERVICE_TYPE` `HRP1950.MANDT == /ISDFPS/CLSERV.MANDT`
Service Type for Characteristics Service Type for Characteristics Client Organizational Area	`HRP1950.SRVC_TYPE == DFS_FE_SERVICE.SRVC_TYPE` `HRP1950.MANDT == DFS_FE_SERVICE.MANDT` `HRP1950.SERVICE_ID == DFS_FE_SERVICE.ORG_AREA`