EDCTAXAUTHDOCHIS
Tax Authority Document History
EDCTAXAUTHDOCHIS is an SAP database table in S/4HANA. Tax Authority Document History. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TaxAuthorityDocumentHistory | view_entity | from | BASIC | Tax Authority Document History |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | record_guid | EDC_RECORD_GUID | Record GUID | |||
| KEY | seq_nr | EDC_SEQUENCE_NUMBER | Tax Auth Rec Seq No | |||
| bukrs | BUKRS | Company Code | ||||
| country | LAND | Country/Region | ||||
| common_key | EDC_COMMON_KEY | Common Key | ||||
| document_key | EDC_DOCUMENT_KEY | Doc Key | ||||
| document_period | EDC_DOCUMENT_PERIOD | Document Period | ||||
| document_type | EDC_DOCUMENT_TYPE | Tax Auth Doc Type | ||||
| bptaxid | BU_ID_NUMBER | ID Number | ||||
| status | EDC_DOC_STATUS | Doc Status | ||||
| status_change_date | EDC_STATUS_CHANGE_DATE | Status Changed on | ||||
| appl_log_id | BALNREXT | External ID | ||||
| created_by | EDC_CREATE_USER | Created By | ||||
| created_on | EDC_CREATE_TIMESTAMP | Record Created On | ||||
| changed_by | EDC_CHANGE_USER | Last Changed By | ||||
| changed_on | EDC_CHANGE_TIMESTAMP | Last Changed On |
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.
-- Tax Authority Document History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDCTAXAUTHDOCHIS (
MANDT, -- Client [MANDT]
RECORD_GUID, -- Record GUID [EDC_RECORD_GUID]
SEQ_NR, -- Tax Auth Rec Seq No [EDC_SEQUENCE_NUMBER]
BUKRS, -- Company Code [BUKRS]
COUNTRY, -- Country/Region [LAND]
COMMON_KEY, -- Common Key [EDC_COMMON_KEY]
DOCUMENT_KEY, -- Doc Key [EDC_DOCUMENT_KEY]
DOCUMENT_PERIOD, -- Document Period [EDC_DOCUMENT_PERIOD]
DOCUMENT_TYPE, -- Tax Auth Doc Type [EDC_DOCUMENT_TYPE]
BPTAXID, -- ID Number [BU_ID_NUMBER]
STATUS, -- Doc Status [EDC_DOC_STATUS]
STATUS_CHANGE_DATE, -- Status Changed on [EDC_STATUS_CHANGE_DATE]
APPL_LOG_ID, -- External ID [BALNREXT]
CREATED_BY, -- Created By [EDC_CREATE_USER]
CREATED_ON, -- Record Created On [EDC_CREATE_TIMESTAMP]
CHANGED_BY, -- Last Changed By [EDC_CHANGE_USER]
CHANGED_ON, -- Last Changed On [EDC_CHANGE_TIMESTAMP]
PRIMARY KEY (MANDT, RECORD_GUID, SEQ_NR)
);
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