SAFTNV_CON_EXT

29 Fields 1 CDS Views

Generated Table for View

SAFTNV_CON_EXT is an SAP database table in S/4HANA. Generated Table for View. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SAFTConsolidationKey view from BASIC SAF-T Consolidation Key

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY consolidation_id SAFTN_CONSOLIDATION_ID Consolidation ID
KEY extraction_id SAFTN_EXTRACTION_ID Extraction ID
ext_test_mode SAFTN_TEST_MODE Test Mode
intca SAFTN_INTCA CtryReg ISO Code
version SAFTN_VERSION File Version
bukrs BUKRS Company Code
file_owner SAFTN_FILE_OWNER Filter Criteria
file_type SAFTN_FILE_TYPE File Type
period_type SAFTN_DECLARATION_PERIOD_TYPE Period Type
period SAFTN_DECLARATION_PERIOD Declaration Period
con_frdat SAFTN_FRDAT From Date
con_todat SAFTN_TODAT To Date
ext_module SAFTN_EXTMOD_SUBMOD Module
ext_frdat SAFTN_FRDAT From Date
ext_todat SAFTN_TODAT To Date
has_cvp_block SAFTN_CVP_BLOCK BP Blocked
con_ernam ERNAM Created By
con_erdat ERDAT Created On
con_erzet ERZET Time
ext_uname ERNAM Created By
ext_begin_date SAFTN_EXT_BEGIN_DATE Ext. Begin Date
ext_begin_time SAFTN_EXT_BEGIN_TIME Ext. Begin Time
ext_end_date SAFTN_EXT_END_DATE Ext. End Date
ext_end_time SAFTN_EXT_END_TIME Ext. End Time
ext_log_extnumber SAFTN_BALNREXT App.Log External No.
con_log_extnumber SAFTN_BALNREXT App.Log External No.
obsolete FLAG Indicator
acr_id SAFTN_ACR_ID Stat. R. Internal ID

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFTNV_CON_EXT (
    MANDT,              -- Client [MANDT]
    CONSOLIDATION_ID,   -- Consolidation ID [SAFTN_CONSOLIDATION_ID]
    EXTRACTION_ID,      -- Extraction ID [SAFTN_EXTRACTION_ID]
    EXT_TEST_MODE,      -- Test Mode [SAFTN_TEST_MODE]
    INTCA,              -- CtryReg ISO Code [SAFTN_INTCA]
    VERSION,            -- File Version [SAFTN_VERSION]
    BUKRS,              -- Company Code [BUKRS]
    FILE_OWNER,         -- Filter Criteria [SAFTN_FILE_OWNER]
    FILE_TYPE,          -- File Type [SAFTN_FILE_TYPE]
    PERIOD_TYPE,        -- Period Type [SAFTN_DECLARATION_PERIOD_TYPE]
    PERIOD,             -- Declaration Period [SAFTN_DECLARATION_PERIOD]
    CON_FRDAT,          -- From Date [SAFTN_FRDAT]
    CON_TODAT,          -- To Date [SAFTN_TODAT]
    EXT_MODULE,         -- Module [SAFTN_EXTMOD_SUBMOD]
    EXT_FRDAT,          -- From Date [SAFTN_FRDAT]
    EXT_TODAT,          -- To Date [SAFTN_TODAT]
    HAS_CVP_BLOCK,      -- BP Blocked [SAFTN_CVP_BLOCK]
    CON_ERNAM,          -- Created By [ERNAM]
    CON_ERDAT,          -- Created On [ERDAT]
    CON_ERZET,          -- Time [ERZET]
    EXT_UNAME,          -- Created By [ERNAM]
    EXT_BEGIN_DATE,     -- Ext. Begin Date [SAFTN_EXT_BEGIN_DATE]
    EXT_BEGIN_TIME,     -- Ext. Begin Time [SAFTN_EXT_BEGIN_TIME]
    EXT_END_DATE,       -- Ext. End Date [SAFTN_EXT_END_DATE]
    EXT_END_TIME,       -- Ext. End Time [SAFTN_EXT_END_TIME]
    EXT_LOG_EXTNUMBER,  -- App.Log External No. [SAFTN_BALNREXT]
    CON_LOG_EXTNUMBER,  -- App.Log External No. [SAFTN_BALNREXT]
    OBSOLETE,           -- Indicator [FLAG]
    ACR_ID,             -- Stat. R. Internal ID [SAFTN_ACR_ID]
    PRIMARY KEY (MANDT, CONSOLIDATION_ID, EXTRACTION_ID)
);

Learn More