EXT_TAX_HEADER_D

Transparent Table Application Table
38 Fields 2 CDS Views

Draft table for entity R_EXTERNALTAXHEADERTP

EXT_TAX_HEADER_D is an SAP database table in S/4HANA. Draft table for entity R_EXTERNALTAXHEADERTP. It contains 38 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExternalTaxHeaderDraft view_entity from BASIC Ext Tax Header - Draft
R_ExternalTaxHeaderDraft view_entity from BASIC Ext Tax Header for Statry Rptng - Draft

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY externaltaxheaderuuid ETTX_HEADER_UUID Ext. Tax Header UUID
KEY companycode BUKRS Company Code
KEY accountingdocument BELNR_D Document Number
KEY fiscalyear GJAHR Fiscal Year
KEY draftuuid SDRAFT_UUID Draft Document ID
fiscalperiod FINS_FISCALPERIOD Fiscal Period
referencedocumenttype AWTYP Ref. procedure
originalreferencedocument AWKEY Reference Key
postingdate BUDAT Posting Date
documentdate BLDAT Document Date
taxreportingdate VATDATE Tax Reporting Date
taxfulfillmentdate FOT_FULFILLDATE Tax Fulfill. Date
accountingdocumenttype BLART Document Type
reversedocument STBLG Reversed With
reversedocumentfiscalyear STJAH Year
isreversed CO_STOKZ Reversed
isreversal CO_STFLG Reversal doc.
absoluteexchangerate FIS_ABSOLUTE_EXCHANGERATE Absolute Exchange Rate
documentreferenceid XBLNR Reference
alternativereferencedocument FIS_XBLNR_ALT_ALPHA Alternative Reference Document
accountingdocumentheadertext BKTXT Doc.Header Text
sendercompanycode BUKRS_SENDER Sender CoCode
senderaccountingdocument BELNR_SENDER Sender Doc.No.
senderfiscalyear GJAHR_SENDER Sender FiscalYr
senderlogicalsystem LOGSYSTEM_SENDER Sender Log Sys.
accountingdocumentcategory BSTAT_D Document Status
creationdatetime ABP_CREATION_TSTMPL Created On
createdbyuser ABP_CREATION_USER Created By
loclinstancelastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_EXTERNALTAXHEADERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EXT_TAX_HEADER_D (
    MANDT,                           -- Client [MANDT]
    EXTERNALTAXHEADERUUID,           -- Ext. Tax Header UUID [ETTX_HEADER_UUID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    ACCOUNTINGDOCUMENT,              -- Document Number [BELNR_D]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    FISCALPERIOD,                    -- Fiscal Period [FINS_FISCALPERIOD]
    REFERENCEDOCUMENTTYPE,           -- Ref. procedure [AWTYP]
    ORIGINALREFERENCEDOCUMENT,       -- Reference Key [AWKEY]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    DOCUMENTDATE,                    -- Document Date [BLDAT]
    TAXREPORTINGDATE,                -- Tax Reporting Date [VATDATE]
    TAXFULFILLMENTDATE,              -- Tax Fulfill. Date [FOT_FULFILLDATE]
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [BLART]
    REVERSEDOCUMENT,                 -- Reversed With [STBLG]
    REVERSEDOCUMENTFISCALYEAR,       -- Year [STJAH]
    ISREVERSED,                      -- Reversed [CO_STOKZ]
    ISREVERSAL,                      -- Reversal doc. [CO_STFLG]
    ABSOLUTEEXCHANGERATE,            -- Absolute Exchange Rate [FIS_ABSOLUTE_EXCHANGERATE]
    DOCUMENTREFERENCEID,             -- Reference [XBLNR]
    ALTERNATIVEREFERENCEDOCUMENT,    -- Alternative Reference Document [FIS_XBLNR_ALT_ALPHA]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [BKTXT]
    SENDERCOMPANYCODE,               -- Sender CoCode [BUKRS_SENDER]
    SENDERACCOUNTINGDOCUMENT,        -- Sender Doc.No. [BELNR_SENDER]
    SENDERFISCALYEAR,                -- Sender FiscalYr [GJAHR_SENDER]
    SENDERLOGICALSYSTEM,             -- Sender Log Sys. [LOGSYSTEM_SENDER]
    ACCOUNTINGDOCUMENTCATEGORY,      -- Document Status [BSTAT_D]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    LOCLINSTANCELASTCHANGEDATETIME,  -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, EXTERNALTAXHEADERUUID, COMPANYCODE, ACCOUNTINGDOCUMENT, FISCALYEAR, DRAFTUUID)
);

Learn More