I_DFS_PositionNATOTP

Transactional Processing View for Position NATO | view: IDFSPOSNATOTP | Extraction: Not supported | Component: Force Element (S/4)

Tables used: HRP1990

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical
Other (2)
🔗 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
DfsPositionValdtyStartDateFoEd	Start Date
DfsPositionValdtyEndDateFoEd	End Date

Column Name	Description

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

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