C_DFS_PositionNATOTP

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

Tables used: T778S, T777S, T77HRFPM_ADTKEY, T77HRFPM_ADTKEYT, /ISDFPS/NATOROT, /ISDFPS/NATOROTT, HRP1990

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical
Other (10)
🔗 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
DfsPositionJobIdxKeyNtrlDesc	Description of Job Index Key (neutral gender)	TEXT40
DfsPositionNATORotation1Desc	Text (30 Characters)	TEXT30
DfsPositionNATORotation2Desc	Text (30 Characters)	TEXT30
DfsPositionNATORotation3Desc	Text (30 Characters)	TEXT30
DfsPositionNATORotation4Desc	Text (30 Characters)	TEXT30
DfsPositionNATORotation5Desc	Text (30 Characters)	TEXT30
DfsPositionNATORotation6Desc	Text (30 Characters)	TEXT30
DfsObjectPlngStatusName	Planning Status Name	TEXT25

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