DRAW
Document Info Record
DRAW is an SAP database table in S/4HANA. Document Info Record. It contains 42 fields. 16 CDS views read from this table.
CDS Views using this table (16)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCLM_BAM_DM_ATTR | view | from | Active Company Code List of FI | |
| I_BkRelshpDocBkAcctAttch | view | inner | BASIC | Shared Attachment of Bank Account |
| I_BOMReleasedDocuments | view | from | BASIC | Released data for material documents |
| I_CstrtSwMatlCstrt | view | left_outer | BASIC | Software Material with Constriant Data |
| I_DocInfoRecdDocumentPart | view | from | BASIC | Document Part Value Help |
| I_DocInfoRecdDocumentVersion | view | from | BASIC | Document Version Value Help |
| I_DocumentInfoRecordDetail | view | from | BASIC | Basic details of a Document Info Record - Text |
| I_DocumentInfoRecordDocPrt | view | from | BASIC | Document Info Record Document Part |
| I_DocumentInfoRecordDocPrtVH | view | from | BASIC | Document Info Record Document Part VH |
| I_DocumentInfoRecordDocVersion | view | from | BASIC | Document Info Record Document Version |
| I_DocumentInfoRecordDocVersVH | view | from | BASIC | Document Info Record Document Version VH |
| I_DocumentInfoRecordReserve | view | from | BASIC | Document Info Record Reserved fields |
| I_DocumentPRTByInternalKey | view_entity | inner | BASIC | Document PRT by internal key |
| P_Swdocver | view | from | BASIC | |
| shsm_drad_draw | view | inner | ||
| SHSM_DRAW | view | from |
Fields (42)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | dokar | dokar | Document Type | |||
| KEY | doknr | doknr | Document | |||
| KEY | dokvr | dokvr | Doc. Version | |||
| KEY | doktl | doktl_d | Document Part | |||
| dwnam | dwnam | User | ||||
| dokst | dokst | Document Status | ||||
| labor | labor | Lab/Office | ||||
| aennr | daenr | Change Number | ||||
| werka | werka | Plant | ||||
| loedk | loedk | Deletion ind. | ||||
| cadkz | cadkz | CAD Indicator | ||||
| prenr | prenr | Document | ||||
| prevr | prevr | Sup. doc. ver. | ||||
| pretl | pretl | Sup. Doc. Part | ||||
| prear | prear | Sup. doc. type | ||||
| begru | begru | AuthorizGroup | ||||
| filep | filep | Original | ||||
| dttrg | dttrg | Data Carrier | ||||
| dappl | dappl | Applic. | ||||
| filep1 | filep | Original | ||||
| dttrg1 | dttrg | Data Carrier | ||||
| dappl1 | dappl | Applic. | ||||
| vrldat | vrldat | Due Date | ||||
| vprior | vprior | Prior. | ||||
| res1 | resdraw | Reserve | ||||
| res2 | resdraw | Reserve | ||||
| res3 | resdraw | Reserve | ||||
| res4 | resdraw | Reserve | ||||
| mrk_filep | filep | Original | ||||
| mrk_dttrg | dttrg | Data Carrier | ||||
| mrk_filep1 | filep | Original | ||||
| mrk_dttrg1 | dttrg | Data Carrier | ||||
| adatum | adatum | Output date | ||||
| doknr_vl | doknr_vl | DSource Doc. | ||||
| doktl_vl | doktl_vl | Source doc. part | ||||
| dokvr_vl | dokvr_vl | Source version | ||||
| filelen | orln | FileLgt. | ||||
| filelen1 | orln | FileLgt. | ||||
| cm_relevance | de_cm_relevance_flag | CM Relevant | ||||
| cm_fixed | dms_cm_fixed | Fixed | ||||
| document_info_record_key | document_info_record_key | DIR Key Concatenated |
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.
-- Document Info Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRAW (
MANDT, -- Client [mandt]
DOKAR, -- Document Type [dokar]
DOKNR, -- Document [doknr]
DOKVR, -- Doc. Version [dokvr]
DOKTL, -- Document Part [doktl_d]
DWNAM, -- User [dwnam]
DOKST, -- Document Status [dokst]
LABOR, -- Lab/Office [labor]
AENNR, -- Change Number [daenr]
WERKA, -- Plant [werka]
LOEDK, -- Deletion ind. [loedk]
CADKZ, -- CAD Indicator [cadkz]
PRENR, -- Document [prenr]
PREVR, -- Sup. doc. ver. [prevr]
PRETL, -- Sup. Doc. Part [pretl]
PREAR, -- Sup. doc. type [prear]
BEGRU, -- AuthorizGroup [begru]
FILEP, -- Original [filep]
DTTRG, -- Data Carrier [dttrg]
DAPPL, -- Applic. [dappl]
FILEP1, -- Original [filep]
DTTRG1, -- Data Carrier [dttrg]
DAPPL1, -- Applic. [dappl]
VRLDAT, -- Due Date [vrldat]
VPRIOR, -- Prior. [vprior]
RES1, -- Reserve [resdraw]
RES2, -- Reserve [resdraw]
RES3, -- Reserve [resdraw]
RES4, -- Reserve [resdraw]
MRK_FILEP, -- Original [filep]
MRK_DTTRG, -- Data Carrier [dttrg]
MRK_FILEP1, -- Original [filep]
MRK_DTTRG1, -- Data Carrier [dttrg]
ADATUM, -- Output date [adatum]
DOKNR_VL, -- DSource Doc. [doknr_vl]
DOKTL_VL, -- Source doc. part [doktl_vl]
DOKVR_VL, -- Source version [dokvr_vl]
FILELEN, -- FileLgt. [orln]
FILELEN1, -- FileLgt. [orln]
CM_RELEVANCE, -- CM Relevant [de_cm_relevance_flag]
CM_FIXED, -- Fixed [dms_cm_fixed]
DOCUMENT_INFO_RECORD_KEY, -- DIR Key Concatenated [document_info_record_key]
PRIMARY KEY (MANDT, DOKAR, DOKNR, DOKVR, DOKTL)
);
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