/ISDFPS/FOROTH SAP (Attributes of Additional Relationships) Table details
Dictionary Type: Table
Description: Attributes of Additional Relationships
Description: Attributes of Additional Relationships
ABAP Code to SELECT data from /ISDFPS/FOROTH
Related tables to /ISDFPS/FOROTH
Access table /ISDFPS/FOROTH
Related tables to /ISDFPS/FOROTH
Access table /ISDFPS/FOROTH
Table field list including key, data, relationships and ABAP select examples
/ISDFPS/FOROTH is a standard SAP Table which is used to store Attributes of Additional Relationships data and is available within R/3 SAP systems depending on the version and release level.
The /ISDFPS/FOROTH table consists of various fields, each holding specific information or linking keys about Attributes of Additional Relationships data available in SAP. These include FRGUID (Material Assignment ID), FRCNT (Internal Counter for Relationships), BEGDA (Start Date), VALID_FROM (Start Time).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /ISDFPS/FOROTH table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| FRGUID | Material Assignment ID | /ISDFPS/FRGUID | CHAR | 32 | /ISDFPS/FOROTHID | SYSUUID_C | |||
| FRCNT | Internal Counter for Relationships | /ISDFPS/FRCNT | NUMC | 6 | NUMC6 | ||||
| BEGDA | Start Date | /ISDFPS/BEGDATUM | DATS | 8 | DATUM | BEG | |||
| VALID_FROM | Start Time | /ISDFPS/BEGZT | TIMS | 6 | /ISDFPS/TIMES4 | ||||
| ENDDA | End Date | /ISDFPS/ENDDATUM | DATS | 8 | DATUM | END | |||
| VALID_TO | End Time | /ISDFPS/ENDZT | TIMS | 6 | /ISDFPS/TIMES4 | ||||
| VALID_TIMEZONE | Valid Time Zone | /ISDFPS/VALID_TIMEZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
| ORIGIN_TIMEZONE | Original Time Zone | /ISDFPS/ORIGIN_TIMEZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
| ISTAT | Planning Status | /ISDFPS/ISTAT | CHAR | 1 | Assigned to domain | ISTAT | |||
| DGUID | Distribution Assignment ID | /ISDFPS/DGUID | CHAR | 32 | SYSUUID_C | ||||
| TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | /ISDFPS/TIMSTMP | DEC | 15 | TZNTSTMPS | ||||
| CREADAT | Date of Application | /ISDFPS/CREADAT | DATS | 8 | DATS | ||||
| CREABY | Created by | /ISDFPS/CREABY | CHAR | 12 | USNAM | ||||
| CHNGDAT | Last Changed on | /ISDFPS/CHNGDAT | DATS | 8 | DATS | ||||
| CHNGBY | Last Changed by | /ISDFPS/CHNGBY | CHAR | 12 | USNAM | ||||
| LOGSYS | Logical System | /ISDFPS/LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | /ISDFPS/ALE_SYNC_SYSTEM | |
| RELAT | Relationship Between Objects | RELAT | CHAR | 3 | Assigned to domain | RELAT | |||
| PRIOX | Priority | PRIOX | CHAR | 2 | CHAR2 | ||||
| DEFAULT_REL | Indicator for Default Support Relationship | /ISDFPS/DEFAULT_REL | CHAR | 1 | CHAR1 |
| Key field | Non-key field |
How do I retrieve data from SAP table /ISDFPS/FOROTH using ABAP code
The following ABAP code Example will allow you to do a basic selection on /ISDFPS/FOROTH to SELECT all data from the tableDATA: WA_/ISDFPS/FOROTH TYPE /ISDFPS/FOROTH.
SELECT SINGLE *
FROM /ISDFPS/FOROTH
INTO CORRESPONDING FIELDS OF WA_/ISDFPS/FOROTH
WHERE...
How to access SAP table /ISDFPS/FOROTH
Within an ECC or HANA version of SAP you can also view further information about /ISDFPS/FOROTH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects