P_DFS_PositionNATO

Baisic Private View of Position NATO | view: PDFSPOSNATO | Extraction: Not supported | Component: Force Element (S/4)

Tables used: HRP1990

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (1)
🔗 Relations (14)

Column Name	Description
DfsPositionPlanVersion FK	Plan Version
DfsPositionObjectType FK	Object Type
DfsPositionID FK	Object ID
DfsPositionSubType FK	Subtype
DfsPositionPlngStatus FK	Planning Status
DfsPositionValdtyStartDate	Start Date
DfsPositionValdtyEndDate	End Date
LanguageCode FK	Language Key

Column Name	Description

Column Name	Description

Column Name	Description
DfsPositionValdtyStartDate	Start Date
DfsPositionValdtyEndDate	End Date

Column Name	Description

Column Name	Description	Domain name
DfsPositionNATOIdentifier	NATO Position ID	/ISDFPS/NATON

Master Data Relations	Join Conditions
Object ID Client Object ID Plan Version Object Type	`P_DFS_POSITIONNATO.MANDT == PLOGI.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONID == PLOGI.OBJID` `P_DFS_POSITIONNATO.DFSPOSITIONPLANVERSION == PLOGI.PLVAR` `P_DFS_POSITIONNATO.DFSPOSITIONOBJECTTYPE == PLOGI.OTYPE`
Infotype Client Infotype	`P_DFS_POSITIONNATO.MANDT == T778T.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONINFOTYPE == T778T.INFTY`
NATO Rank Client NATO Rank	`P_DFS_POSITIONNATO.MANDT == T77HRFPM_ADTKEY.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONNATORANK == T77HRFPM_ADTKEY.ADTKEY`
NATO Rotation Client ? NATO Rotation	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION1 == /ISDFPS/NATOROT.ROTCOD`
NATO Rotation Client NATO Rotation ?	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION2 == /ISDFPS/NATOROT.ROTCOD` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA`
NATO Rotation Client ? NATO Rotation	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION3 == /ISDFPS/NATOROT.ROTCOD`
NATO Rotation Client ? NATO Rotation	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION4 == /ISDFPS/NATOROT.ROTCOD`
NATO Rotation Client ? NATO Rotation	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION5 == /ISDFPS/NATOROT.ROTCOD`
NATO Rotation Client NATO Rotation ?	`P_DFS_POSITIONNATO.MANDT == /ISDFPS/NATOROT.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONNATOROTATION6 == /ISDFPS/NATOROT.ROTCOD` `P_DFS_POSITIONNATO.[column in domain "MOLGA"] == /ISDFPS/NATOROT.MOLGA`
Object Type Client Object Type	`P_DFS_POSITIONNATO.MANDT == T778O.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONOBJECTTYPE == T778O.OTYPE`
Plan Version Client Plan Version	`P_DFS_POSITIONNATO.MANDT == T778P.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONPLANVERSION == T778P.PLVAR`
Planning Status Client Planning Status	`P_DFS_POSITIONNATO.MANDT == T778S.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONPLNGSTATUS == T778S.ISTAT`
Subtype Client Subtype Infotype	`P_DFS_POSITIONNATO.MANDT == T778U.MANDT` `P_DFS_POSITIONNATO.DFSPOSITIONSUBTYPE == T778U.SUBTY` `P_DFS_POSITIONNATO.DFSPOSITIONINFOTYPE == T778U.INFTY`
Foreign Key: Language	`P_DFS_POSITIONNATO.LANGUAGECODE == T002.SPRAS`