DRAW
Document Info Record
DRAW is an SAP database table in S/4HANA. Document Info Record. It contains 43 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 (43)
| 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 | ||||
| dummy_draw_incl_eew_ps | DRAW_INCL_EEW | Data Element for Document 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.
-- 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]
DUMMY_DRAW_INCL_EEW_PS, -- Data Element for Document Data [DRAW_INCL_EEW]
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