SFSG_Q_JOIN - Query Joins
Query Joins information is stored in SAP table SFSG_Q_JOIN.
It is part of development package SFSG_RP in software component BC-SRV-FSI. This development package consists of objects that can be grouped under "Fast Search Repository".
It is part of development package SFSG_RP in software component BC-SRV-FSI. This development package consists of objects that can be grouped under "Fast Search Repository".
Fields for table SFSG_Q_JOIN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | SFSG_DEF_KEY | 0 | |||
| DEF_NAME | Search Definition Name of Generic Fast Search | X | SFSG_DEFINITION_NAME | CHAR | 25 | SFSG_DEF_D |
| AS4LOCAL | Activation State of Repository Object | X | AS4LOCAL | CHAR | 1 | |
| J_ID | GUID in 'RAW' format | X | GUID_16 | RAW | 16 | |
| .INCLUDE | SFSG_QB_JOIN | 0 | ||||
| J_NO | INT4 | 4 | ||||
| LEFT_TABLE_NAME | Table | SFSG_QB_TABNAME | CHAR | 30 | ||
| LEFT_TABLE_ATTR | STRG | 8 | ||||
| RIGHT_TABLE_NAME | Table | SFSG_QB_TABNAME | CHAR | 30 | ||
| RIGHT_TABLE_ATTR | STRG | 8 | ||||
| JOIN_TYPE | Type of Join | SFSG_JOIN_TYPE | CHAR | 1 | ||
| JOIN_NAME | Replication Framework - Join-Name | SFSRFW_JOIN_NAME | CHAR | 10 |