T811H
Allocation: Datenfeldbeschreibung
T811H is an SAP database table in S/4HANA. Allocation: Datenfeldbeschreibung. It contains 60 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AllocDataFldDesc | view | from | BASIC | Allocations Data Field Descriptions |
Fields (60)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | tab | tabname | Table Name | |||
| KEY | fname | fvalueal | Data Field | |||
| dafl1 | dafld | Value Field | ||||
| dafl2 | dafld | Value Field | ||||
| dafl3 | dafld | Value Field | ||||
| dafl4 | dafld | Value Field | ||||
| dafl5 | dafld | Value Field | ||||
| ftype | rwftype | Key Figure Cat. | ||||
| gsize | gsize | Number fields | ||||
| per00 | per00 | Period 00 | ||||
| maxpe | maxpe | Max. period | ||||
| pefld | pefld | Period field | ||||
| cnt | cnt | Counter value | ||||
| adfld | adfld | Addit. Field | ||||
| adval | adval | Value Add. Fld | ||||
| cufld | cufld | Unit | ||||
| cform | cform | Calculatn rout. | ||||
| goffs | goffs | Group offset | ||||
| ptype1 | paratype | Parameter type | ||||
| plength1 | paralength | Parameter lngth | ||||
| ptype2 | paratype | Parameter type | ||||
| plength2 | paralength | Parameter lngth | ||||
| ptype3 | paratype | Parameter type | ||||
| plength3 | paralength | Parameter lngth | ||||
| pname1 | paranam | Parameter | ||||
| pname2 | paranam | Parameter | ||||
| pname3 | paranam | Parameter | ||||
| addtb1 | rwtabname | Table | ||||
| addtb2 | rwtabname | Table | ||||
| addtb3 | rwtabname | Table | ||||
| addtb4 | rwtabname | Table | ||||
| addtb5 | rwtabname | Table | ||||
| cposition | cposition | Time of calc. | ||||
| coperands | coperands | No. operands | ||||
| cform2 | cform2 | Issue routine | ||||
| pclass | pclass | Format Group | ||||
| decimals | fdecimals | Decimal places | ||||
| cufld2 | cufld | Unit | ||||
| seqnr | queryseqnr | Eval.sequ. | ||||
| average | average | Stat.Key Figure | ||||
| rc_field1 | fdnam | Field | ||||
| rc_field2 | fdnam | Field | ||||
| rc_field3 | fdnam | Field | ||||
| rc_field4 | fdnam | Field | ||||
| rc_field5 | fdnam | Field | ||||
| rc_field6 | fdnam | Field | ||||
| rc_field7 | fdnam | Field | ||||
| rc_field8 | fdnam | Field | ||||
| rc_field9 | fdnam | Field | ||||
| rc_field10 | fdnam | Field | ||||
| rc_act_field1 | kalc_rc_act | RC_ACT | ||||
| rc_act_field2 | kalc_rc_act | RC_ACT | ||||
| rc_act_field3 | kalc_rc_act | RC_ACT | ||||
| rc_act_field4 | kalc_rc_act | RC_ACT | ||||
| rc_act_field5 | kalc_rc_act | RC_ACT | ||||
| rc_act_field6 | kalc_rc_act | RC_ACT | ||||
| rc_act_field7 | kalc_rc_act | RC_ACT | ||||
| rc_act_field8 | kalc_rc_act | RC_ACT | ||||
| rc_act_field9 | kalc_rc_act | RC_ACT | ||||
| rc_act_field10 | kalc_rc_act | RC_ACT |
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.
-- Allocation: Datenfeldbeschreibung
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T811H (
TAB, -- Table Name [tabname]
FNAME, -- Data Field [fvalueal]
DAFL1, -- Value Field [dafld]
DAFL2, -- Value Field [dafld]
DAFL3, -- Value Field [dafld]
DAFL4, -- Value Field [dafld]
DAFL5, -- Value Field [dafld]
FTYPE, -- Key Figure Cat. [rwftype]
GSIZE, -- Number fields [gsize]
PER00, -- Period 00 [per00]
MAXPE, -- Max. period [maxpe]
PEFLD, -- Period field [pefld]
CNT, -- Counter value [cnt]
ADFLD, -- Addit. Field [adfld]
ADVAL, -- Value Add. Fld [adval]
CUFLD, -- Unit [cufld]
CFORM, -- Calculatn rout. [cform]
GOFFS, -- Group offset [goffs]
PTYPE1, -- Parameter type [paratype]
PLENGTH1, -- Parameter lngth [paralength]
PTYPE2, -- Parameter type [paratype]
PLENGTH2, -- Parameter lngth [paralength]
PTYPE3, -- Parameter type [paratype]
PLENGTH3, -- Parameter lngth [paralength]
PNAME1, -- Parameter [paranam]
PNAME2, -- Parameter [paranam]
PNAME3, -- Parameter [paranam]
ADDTB1, -- Table [rwtabname]
ADDTB2, -- Table [rwtabname]
ADDTB3, -- Table [rwtabname]
ADDTB4, -- Table [rwtabname]
ADDTB5, -- Table [rwtabname]
CPOSITION, -- Time of calc. [cposition]
COPERANDS, -- No. operands [coperands]
CFORM2, -- Issue routine [cform2]
PCLASS, -- Format Group [pclass]
DECIMALS, -- Decimal places [fdecimals]
CUFLD2, -- Unit [cufld]
SEQNR, -- Eval.sequ. [queryseqnr]
AVERAGE, -- Stat.Key Figure [average]
RC_FIELD1, -- Field [fdnam]
RC_FIELD2, -- Field [fdnam]
RC_FIELD3, -- Field [fdnam]
RC_FIELD4, -- Field [fdnam]
RC_FIELD5, -- Field [fdnam]
RC_FIELD6, -- Field [fdnam]
RC_FIELD7, -- Field [fdnam]
RC_FIELD8, -- Field [fdnam]
RC_FIELD9, -- Field [fdnam]
RC_FIELD10, -- Field [fdnam]
RC_ACT_FIELD1, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD2, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD3, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD4, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD5, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD6, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD7, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD8, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD9, -- RC_ACT [kalc_rc_act]
RC_ACT_FIELD10, -- RC_ACT [kalc_rc_act]
PRIMARY KEY (TAB, FNAME)
);
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