E071K_STR
Key Entries with String Fields of Requests/Tasks
E071K_STR is an SAP database table in S/4HANA. Key Entries with String Fields of Requests/Tasks. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ATOV_STRG_KEY_IN_OPEN_REQUEST | view | from | ATO: String Key in Customizing Request | |
| SXCO_TR_KEY_ENTRY | view_entity | union | XCO Transport: Key entry |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | trkorr | TRKORR | Request/Task | |||
| KEY | pgmid | PGMID | Program ID | |||
| KEY | object | TROBJTYPE | Object Type | |||
| KEY | objname | TABNAME | Table Name | |||
| KEY | as4pos | DDPOSITION | Dictionary: Line item | |||
| mastertype | TROBJTYPE | Object Type | ||||
| mastername | SOBJ_NAME | Object Name | ||||
| viewname | VIEWNAME | View Name | ||||
| objfunc | UPDID | Do not use | ||||
| tabkey | CTS_STRING | String Key | ||||
| sortflag | FLAG | Indicator | ||||
| flag | FLAG | Indicator | ||||
| lang | SPRAS | Language | ||||
| activity | TRACTIVITY | IMG Activity | ||||
| key_lens | CTS_SSTRING | CTS: Short String |
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.
-- Key Entries with String Fields of Requests/Tasks
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE E071K_STR (
TRKORR, -- Request/Task [TRKORR]
PGMID, -- Program ID [PGMID]
OBJECT, -- Object Type [TROBJTYPE]
OBJNAME, -- Table Name [TABNAME]
AS4POS, -- Dictionary: Line item [DDPOSITION]
MASTERTYPE, -- Object Type [TROBJTYPE]
MASTERNAME, -- Object Name [SOBJ_NAME]
VIEWNAME, -- View Name [VIEWNAME]
OBJFUNC, -- Do not use [UPDID]
TABKEY, -- String Key [CTS_STRING]
SORTFLAG, -- Indicator [FLAG]
FLAG, -- Indicator [FLAG]
LANG, -- Language [SPRAS]
ACTIVITY, -- IMG Activity [TRACTIVITY]
KEY_LENS, -- CTS: Short String [CTS_SSTRING]
PRIMARY KEY (TRKORR, PGMID, OBJECT, OBJNAME, AS4POS)
);
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