TXRG_MIGRATION

Transparent Table Application Table
19 Fields 1 CDS Views

Tax Register Migration

TXRG_MIGRATION is an SAP database table in S/4HANA. Tax Register Migration. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TaxRegisterMigration view_entity from BASIC Tax Register Migration

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY migration_uuid UUID UUID
migration_id TXRG_MIGRATION_ID Task ID
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
taxation_type TXRG_TXN_TYPE Taxation Type
migration_status TXRG_MIGRATION_STATUS Status
posting_from BUDAT Posting Date
posting_to BUDAT Posting Date
tax_reporting_date_type TXRG_DEFAULT_REPORTING_DATE Source of Tax Reporting Date
tax_fulfilment_date_type TXRG_DEFAULT_FULFILMENT_DATE Source of Tax Fulfilment Date
scheduled_for_date_time TXRG_MIGRATION_DATETIME Migration Start
job_name BTCJOB Job Name
job_count BTCJOBCNT Job No.
log_handle TXRG_MIGRATION_LOGHANDLE Migration Log Handle
trace_id TXRG_MIGRATION_TRACE_ID Trace ID
created_by TXRG_MIGRATION_CREATEDBY Created By
created_at TXRG_MIGRATION_CREATEDAT Created On
last_changed_by TXRG_MIGRATION_LASTCHANGEDBY Last Changed By
last_changed_at TXRG_MIGRATION_LASTCHANGEDAT 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 Register Migration
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TXRG_MIGRATION (
    MANDT,                     -- Client [MANDT]
    MIGRATION_UUID,            -- UUID [UUID]
    MIGRATION_ID,              -- Task ID [TXRG_MIGRATION_ID]
    TAX_COUNTRY,               -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    TAXATION_TYPE,             -- Taxation Type [TXRG_TXN_TYPE]
    MIGRATION_STATUS,          -- Status [TXRG_MIGRATION_STATUS]
    POSTING_FROM,              -- Posting Date [BUDAT]
    POSTING_TO,                -- Posting Date [BUDAT]
    TAX_REPORTING_DATE_TYPE,   -- Source of Tax Reporting Date [TXRG_DEFAULT_REPORTING_DATE]
    TAX_FULFILMENT_DATE_TYPE,  -- Source of Tax Fulfilment Date [TXRG_DEFAULT_FULFILMENT_DATE]
    SCHEDULED_FOR_DATE_TIME,   -- Migration Start [TXRG_MIGRATION_DATETIME]
    JOB_NAME,                  -- Job Name [BTCJOB]
    JOB_COUNT,                 -- Job No. [BTCJOBCNT]
    LOG_HANDLE,                -- Migration Log Handle [TXRG_MIGRATION_LOGHANDLE]
    TRACE_ID,                  -- Trace ID [TXRG_MIGRATION_TRACE_ID]
    CREATED_BY,                -- Created By [TXRG_MIGRATION_CREATEDBY]
    CREATED_AT,                -- Created On [TXRG_MIGRATION_CREATEDAT]
    LAST_CHANGED_BY,           -- Last Changed By [TXRG_MIGRATION_LASTCHANGEDBY]
    LAST_CHANGED_AT,           -- Last Changed On [TXRG_MIGRATION_LASTCHANGEDAT]
    PRIMARY KEY (MANDT, MIGRATION_UUID)
);

Learn More