TDWS

Transparent Table Customizing Table
30 Fields 5 CDS Views

Document Status

TDWS is an SAP database table in S/4HANA. Document Status. It contains 30 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BOMReleasedDocuments view inner BASIC Released data for material documents
I_DocInfoRecdDocumentStatus view from BASIC Document Status
I_DocInfoRecdStatusText view from BASIC Document Status Description
I_DocumentInfoRecordDocStatus view from BASIC Document Info Record Document Status
I_DocumentInfoRecordDocStsVH view from BASIC Document Info Record StatusValueHelp

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dokar dokar Document Type
KEY dokst dokst Document Status
prfaw prfaw Fld sel.
dosar dosar Status type
objpk objpk Object check
frknz frknz Released ind.
svor1 svor1 Prev. 1
svor2 svor2 Prev. 2
svor3 svor3 Prev. 3
svor4 svor4 Prev. 4
svor5 svor5 Prev. 5
svor6 svor6 Prev. 6
frtae frtae Change complete
audit1 audit Content Version
wfaufgabe wfaufgabe Workflow task
statexit statexit Program exit
statform statform Form routine
otype otype Object type
objid objektid Object ID
cv_immedt cv_immedt Immediately
dlock dlock Distr. Lock
signstrat signstrat Signat. Strategy
checkin_flag dms_checkin_flag Check in
cc_hist_req cc_hist_req History reqmt
checkin_req dms_checkin_req Checked In
only_one_version only_one_version Version
delete_version del_vers Delete Inactive Vrs
obsolete cv_obsolete Obsolete Status
configdeprecationcode config_deprecation_code Validity

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 Status
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TDWS (
    MANDT,                  -- Client [mandt]
    DOKAR,                  -- Document Type [dokar]
    DOKST,                  -- Document Status [dokst]
    PRFAW,                  -- Fld sel. [prfaw]
    DOSAR,                  -- Status type [dosar]
    OBJPK,                  -- Object check [objpk]
    FRKNZ,                  -- Released ind. [frknz]
    SVOR1,                  -- Prev. 1 [svor1]
    SVOR2,                  -- Prev. 2 [svor2]
    SVOR3,                  -- Prev. 3 [svor3]
    SVOR4,                  -- Prev. 4 [svor4]
    SVOR5,                  -- Prev. 5 [svor5]
    SVOR6,                  -- Prev. 6 [svor6]
    FRTAE,                  -- Change complete [frtae]
    AUDIT1,                 -- Content Version [audit]
    WFAUFGABE,              -- Workflow task [wfaufgabe]
    STATEXIT,               -- Program exit [statexit]
    STATFORM,               -- Form routine [statform]
    OTYPE,                  -- Object type [otype]
    OBJID,                  -- Object ID [objektid]
    CV_IMMEDT,              -- Immediately [cv_immedt]
    DLOCK,                  -- Distr. Lock [dlock]
    SIGNSTRAT,              -- Signat. Strategy [signstrat]
    CHECKIN_FLAG,           -- Check in [dms_checkin_flag]
    CC_HIST_REQ,            -- History reqmt [cc_hist_req]
    CHECKIN_REQ,            -- Checked In [dms_checkin_req]
    ONLY_ONE_VERSION,       -- Version [only_one_version]
    DELETE_VERSION,         -- Delete Inactive Vrs [del_vers]
    OBSOLETE,               -- Obsolete Status [cv_obsolete]
    CONFIGDEPRECATIONCODE,  -- Validity [config_deprecation_code]
    PRIMARY KEY (MANDT, DOKAR, DOKST)
);

Learn More