RFDT
Buchhaltungs-Daten ( INDX-Struktur )
RFDT is an SAP database table in S/4HANA. Buchhaltungs-Daten ( INDX-Struktur ). It contains 13 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CAMassActivityRun | view | from | BASIC | Mass Activity Run |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | relid | sychar02 | CHAR02 data element for SYST | |||
| KEY | srtfd | sychar22 | Character 22 | |||
| KEY | srtf2 | sybin4 | BIN4 data element for SYST | |||
| loekz | sychar01 | CHAR01 data element for SYST | ||||
| sperr | sychar01 | CHAR01 data element for SYST | ||||
| aedat | sydats | (8-character) Date for SYST | ||||
| usera | username | User Name | ||||
| pgmid | progname | Program Name | ||||
| begdt | sydats | (8-character) Date for SYST | ||||
| enddt | sydats | (8-character) Date for SYST | ||||
| clustr | sybin2 | BIN2 data element for SYST | ||||
| clustd | indx_clust | Data |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Buchhaltungs-Daten ( INDX-Struktur )
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFDT (
MANDT, -- Client [mandt]
RELID, -- CHAR02 data element for SYST [sychar02]
SRTFD, -- Character 22 [sychar22]
SRTF2, -- BIN4 data element for SYST [sybin4]
LOEKZ, -- CHAR01 data element for SYST [sychar01]
SPERR, -- CHAR01 data element for SYST [sychar01]
AEDAT, -- (8-character) Date for SYST [sydats]
USERA, -- User Name [username]
PGMID, -- Program Name [progname]
BEGDT, -- (8-character) Date for SYST [sydats]
ENDDT, -- (8-character) Date for SYST [sydats]
CLUSTR, -- BIN2 data element for SYST [sybin2]
CLUSTD, -- Data [indx_clust]
PRIMARY KEY (MANDT, RELID, SRTFD, SRTF2)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA