EDCTAXAUTHDOCHIS

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
I_TaxAuthorityDocumentHistory view_entity from BASIC Tax Authority Document History

Fields (17)

KeyField Data ElementDescription DomainTypeLength
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)
);