EXT_TAX_HEADER
External Tax Header for Statutory Reporting
EXT_TAX_HEADER is an SAP database table in S/4HANA. External Tax Header for Statutory Reporting. It contains 31 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ExternalTaxHeader | view_entity | from | BASIC | Ext Tax Header for Statutory Reporting |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | header_uuid | ETTX_HEADER_UUID | Ext. Tax Header UUID | |||
| bukrs | BUKRS | Company Code | ||||
| belnr | BELNR_D | Document Number | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| monat | MONAT | Period | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awkey | AWKEY | Reference Key | ||||
| budat | BUDAT | Posting Date | ||||
| bldat | BLDAT | Document Date | ||||
| vatdate | VATDATE | Tax Reporting Date | ||||
| fulfilldate | FOT_FULFILLDATE | Tax Fulfill. Date | ||||
| blart | BLART | Document Type | ||||
| stblg | STBLG | Reversed With | ||||
| stjah | STJAH | Year | ||||
| xreversed | CO_STOKZ | Reversed | ||||
| xreversing | CO_STFLG | Reversal doc. | ||||
| kursf | FIS_ABSOLUTE_EXCHANGERATE | Absolute Exchange Rate | ||||
| xblnr | XBLNR | Reference | ||||
| xblnr_alt | FIS_XBLNR_ALT_ALPHA | Alternative Reference Document | ||||
| bktxt | BKTXT | Doc.Header Text | ||||
| bukrs_sender | BUKRS_SENDER | Sender CoCode | ||||
| belnr_sender | BELNR_SENDER | Sender Doc.No. | ||||
| gjahr_sender | GJAHR_SENDER | Sender FiscalYr | ||||
| logsystem_sender | LOGSYSTEM_SENDER | Sender Log Sys. | ||||
| bstat | BSTAT_D | Document Status | ||||
| created_at | ABP_CREATION_TSTMPL | Created On | ||||
| created_by | ABP_CREATION_USER | Created By | ||||
| local_last_changed_at | ABP_LOCINST_LASTCHANGE_TSTMPL | Changed On | ||||
| last_changed_at | ABP_LASTCHANGE_TSTMPL | Changed On | ||||
| changed_by | ABP_LASTCHANGE_USER | Changed By |
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.
-- External Tax Header for Statutory Reporting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EXT_TAX_HEADER (
MANDT, -- Client [MANDT]
HEADER_UUID, -- Ext. Tax Header UUID [ETTX_HEADER_UUID]
BUKRS, -- Company Code [BUKRS]
BELNR, -- Document Number [BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
MONAT, -- Period [MONAT]
AWTYP, -- Ref. procedure [AWTYP]
AWKEY, -- Reference Key [AWKEY]
BUDAT, -- Posting Date [BUDAT]
BLDAT, -- Document Date [BLDAT]
VATDATE, -- Tax Reporting Date [VATDATE]
FULFILLDATE, -- Tax Fulfill. Date [FOT_FULFILLDATE]
BLART, -- Document Type [BLART]
STBLG, -- Reversed With [STBLG]
STJAH, -- Year [STJAH]
XREVERSED, -- Reversed [CO_STOKZ]
XREVERSING, -- Reversal doc. [CO_STFLG]
KURSF, -- Absolute Exchange Rate [FIS_ABSOLUTE_EXCHANGERATE]
XBLNR, -- Reference [XBLNR]
XBLNR_ALT, -- Alternative Reference Document [FIS_XBLNR_ALT_ALPHA]
BKTXT, -- Doc.Header Text [BKTXT]
BUKRS_SENDER, -- Sender CoCode [BUKRS_SENDER]
BELNR_SENDER, -- Sender Doc.No. [BELNR_SENDER]
GJAHR_SENDER, -- Sender FiscalYr [GJAHR_SENDER]
LOGSYSTEM_SENDER, -- Sender Log Sys. [LOGSYSTEM_SENDER]
BSTAT, -- Document Status [BSTAT_D]
CREATED_AT, -- Created On [ABP_CREATION_TSTMPL]
CREATED_BY, -- Created By [ABP_CREATION_USER]
LOCAL_LAST_CHANGED_AT, -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
LAST_CHANGED_AT, -- Changed On [ABP_LASTCHANGE_TSTMPL]
CHANGED_BY, -- Changed By [ABP_LASTCHANGE_USER]
PRIMARY KEY (MANDT, HEADER_UUID)
);
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