Fields (48)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | NUMBER | n2 | 4 |
| alebn | alebn | 5 | |
| alebz | alebz | 5 | |
| AllocationFrequencyCode | AllocationFrequencyCode | 4 | |
| awkey | awkey | 5 | |
| aworg | aworg | 5 | |
| aworg_rev | aworg_rev | 5 | |
| awref_rev | awref_rev | 5 | |
| awsys | awsys | 5 | |
| awtyp | awtyp | 5 | |
| belnr_sender | belnr_sender | 5 | |
| blart | blart | 5 | |
| bldat | bldat | 5 | |
| bltxt | bltxt | 5 | |
| budat | budat | 5 | |
| cpudt | cpudt | 5 | |
| cputm | cputm | 5 | |
| ctyp1 | ctyp1 | 5 | |
| ctyp2 | ctyp2 | 5 | |
| ctyp3 | ctyp3 | 5 | |
| ctyp4 | ctyp4 | 5 | |
| delbz | delbz | 5 | |
| gjahr | k_gjahr | 5 | |
| kokrs_sender | kokrs_sender | 5 | |
| kurst | kurst | 5 | |
| kwaer | kwaer | 5 | |
| ldgrp | ldgrp | 5 | |
| logsystem | logsystem | 5 | |
| logsystem_sender | logsystem_sender | 5 | |
| MalfunctionStartDateTime | T2MalfunctionStartDateTime | 1 | |
| orgvg | orgvg | 5 | |
| perab | perab | 5 | |
| perbi | perbi | 5 | |
| refbk | refbk | 5 | |
| refbn | refbn | 5 | |
| refbt | refbt | 5 | |
| refgj | refgj | 5 | |
| reprocessing_status_code | reprocessing_status_code | 5 | |
| stflg | stflg | 5 | |
| stokz | stokz | 5 | |
| sumbz | sumbz | 5 | |
| timestmp | k_timestmp,timestmp | 5 | |
| usnam | usnam | 5 | |
| valdt | valdt | 5 | |
| varnr | varnr | 5 | |
| versn | k_versn | 5 | |
| vrgng | k_vrgng | 5 | |
| wsdat | wsdat | 5 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T2 (
NUMBER,
ALEBN,
ALEBZ,
ALLOCATIONFREQUENCYCODE,
AWKEY,
AWORG,
AWORG_REV,
AWREF_REV,
AWSYS,
AWTYP,
BELNR_SENDER,
BLART,
BLDAT,
BLTXT,
BUDAT,
CPUDT,
CPUTM,
CTYP1,
CTYP2,
CTYP3,
CTYP4,
DELBZ,
GJAHR,
KOKRS_SENDER,
KURST,
KWAER,
LDGRP,
LOGSYSTEM,
LOGSYSTEM_SENDER,
MALFUNCTIONSTARTDATETIME,
ORGVG,
PERAB,
PERBI,
REFBK,
REFBN,
REFBT,
REFGJ,
REPROCESSING_STATUS_CODE,
STFLG,
STOKZ,
SUMBZ,
TIMESTMP,
USNAM,
VALDT,
VARNR,
VERSN,
VRGNG,
WSDAT,
PRIMARY KEY (NUMBER)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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