PiqCdsHrp1001

View for HRP1001 | view: PIQ_SQL_HRP1001 | Extraction: Not supported | Component: Campus Management

Tables used: HRP1001

🔑 Keys (14)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical (1)
Other (6)
🔗 Relations (9)

Column Name	Description
ObjectType FK	Object Type
ObjectID FK	Object ID
ActivePlanVersion FK	Plan Version
RelationshipDirection	Relationship Specification	Show values
RelationshipNumber FK	Relationship Between Objects
RelationStatus FK	Planning Status
Priority	Priority
StartDate	Start Date
EndDate	End Date
VariationField	Variation Field for File PLOG
SequenceNumber	Number of Infotype Record With Same Key
Infotype FK	Infotype
ObjectTypeAndID	Concatenation of Object Type and Object ID
RelationshipSubtype FK	Subtype

Column Name	Description

Column Name	Description

Column Name	Description
StartDate	Start Date
EndDate	End Date
ChangedOn	Changed on

Column Name	Description
RelationshipDirection	Relationship Specification	Show values

Column Name	Description	Domain name
ChangedUserName	User Name	CHAR12
ChangeReason	Reason	CHAR2
HistoricalRecordFlag	Historical Record Flag	CHAR1
InfotypeTextModule	Text Module for Infotype	NUM08
WeightingPercentage	Weighting Percentage	DEC3_2
RelatedObjectID	ID of Related Object	CHAR45

Master Data Relations	Join Conditions
Plan Version Client Plan Version	`PIQCDSHRP1001.MANDT == T778P.MANDT` `PIQCDSHRP1001.ACTIVEPLANVERSION == T778P.PLVAR`
ADATA Number Client ADATA Number	`PIQCDSHRP1001.MANDT == HRIADATANR.MANDT` `PIQCDSHRP1001.ADDDATANUMBERINTID == HRIADATANR.ADATANR`
Infotype Client Infotype	`PIQCDSHRP1001.MANDT == T778T.MANDT` `PIQCDSHRP1001.INFOTYPE == T778T.INFTY`
Object ID Client Object ID Plan Version Object Type	`PIQCDSHRP1001.MANDT == PLOGI.MANDT` `PIQCDSHRP1001.OBJECTID == PLOGI.OBJID` `PIQCDSHRP1001.ACTIVEPLANVERSION == PLOGI.PLVAR` `PIQCDSHRP1001.OBJECTTYPE == PLOGI.OTYPE`
Object Type Client Object Type	`PIQCDSHRP1001.MANDT == T778O.MANDT` `PIQCDSHRP1001.OBJECTTYPE == T778O.OTYPE`
Type of Related Object Client Type of Related Object	`PIQCDSHRP1001.MANDT == T778O.MANDT` `PIQCDSHRP1001.RELATEDOBJECTTYPE == T778O.OTYPE`
Relationship Between Objects Client Relationship Between Objects	`PIQCDSHRP1001.MANDT == T778V.MANDT` `PIQCDSHRP1001.RELATIONSHIPNUMBER == T778V.RELAT`
Subtype Client Subtype Infotype	`PIQCDSHRP1001.MANDT == T778U.MANDT` `PIQCDSHRP1001.RELATIONSHIPSUBTYPE == T778U.SUBTY` `PIQCDSHRP1001.INFOTYPE == T778U.INFTY`
Planning Status Client Planning Status	`PIQCDSHRP1001.MANDT == T778S.MANDT` `PIQCDSHRP1001.RELATIONSTATUS == T778S.ISTAT`