FDC_D_DFT_HDR
Header Table for drafts
FDC_D_DFT_HDR is an SAP database table in S/4HANA. Header Table for drafts. It contains 10 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FACVD_CLRIT_05 | view | left_outer | Open items of incoming payment for manual clearing | |
| FACVD_CLRIT_06 | view | left_outer | Open items of outgoing payment for manual clearing | |
| Facvd_Dft_Wli | view | from | Draft of Accounting Document Header | |
| facvd_Uplddoc_All | view | from | Uploaded Documents | |
| farvd_bs_it_02 | view_entity | left_outer | Bank Statement Items | |
| P_Arbanktransactiondocitem_07 | view | left_outer | COMPOSITE |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | FDC_DFT_KEY | RAW16 | |||
| usera | USERNAME | User Name | ||||
| crea_date_time | TIMESTAMPL | Time Stamp | ||||
| status | CHAR1 | Single-Character Flag | ||||
| type_code | FDC_DFT_TYPE_CODE | Daft Type | ||||
| id | FDC_DRAFT_ID | Temp. ID | ||||
| tcode | TCODE | Transaction Code | ||||
| cpudt | DATS | Date | ||||
| cputm | TIMS | Field of type TIMS |
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.
-- Header Table for drafts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDC_D_DFT_HDR (
MANDT, -- Client [MANDT]
DB_KEY, -- RAW16 [FDC_DFT_KEY]
USERA, -- User Name [USERNAME]
CREA_DATE_TIME, -- Time Stamp [TIMESTAMPL]
STATUS, -- Single-Character Flag [CHAR1]
TYPE_CODE, -- Daft Type [FDC_DFT_TYPE_CODE]
ID, -- Temp. ID [FDC_DRAFT_ID]
TCODE, -- Transaction Code [TCODE]
CPUDT, -- Date [DATS]
CPUTM, -- Field of type TIMS [TIMS]
PRIMARY KEY (MANDT, DB_KEY)
);
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