/ACCGO/T_SNPHD1

Transparent Table Application Table
46 Fields 4 CDS Views

Contract Header

/ACCGO/T_SNPHD1 is an SAP database table in S/4HANA. Contract Header. It contains 46 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ContractSnapshotHeaderLevel view from BASIC ACM Contract Snapshot for Header Level
I_TrdgContrSnapshotProcStatus view from BASIC Trading Contract Processing Status
P_TradingContractSnapshot view from BASIC
P_TrdgContractSnapShotData view from BASIC Contract Header Data

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY document_id /ACCGO/E_SNAP_ID Snapshot ID
KEY application /ACCGO/E_SNP_APPLICATION Snapshot Application
KEY timestamp /ACCGO/E_SNP_TMPSTMP Snapshot Timestamp
tkonn_ex TKONN_EX Ext. Identifier
btbsta BTBSTA ApplicStatus
tctyp TCTYP Contract Type
kunnr KUNAG Sold-to Party
sdwrs WAERK Doc. Currency
company_code BUKRS Company Code
erdat ERDAT Created On
tksachb TKSACHB Pers. Respons.
ernam ERNAM Created By
valid_till_date /ACCGO/E_QUOTE_VALID_TILL Valid Till
trade_office /ACCGO/E_CS_BP_TRD Trade Office
aenam AENAM Changed By
aedat AEDAT Changed On
target_price_type /ACCGO/E_TGT_PRICE_TYPE Price Type
strike_price_amount /ACCGO/E_STRIKE_PRICE Strike Price Amount
strike_price_currency /ACCGO/E_STRK_PRICE_CURR Price Currency
strike_price_per_unit /ACCGO/E_PRICE_UNIT Strike Price Unit
strike_price_uom /ACCGO/E_PRICE_UOM Strike Price UoM
dcsid_fbo TBA_DCSID DCS ID
maturity_code TBA_CONTRACT_CODE Contr. Maturity Code
fbo_expiry_date /ACCGO/E_FBO_EXPIRY_DATE FBO Expiry Date
target_contract_type TCTYP Contract Type
automatic_convert_to_contract /ACCGO/E_AMT_CONTRACT Contract
lock_instruction_type /ACCGO/E_LOCK_TYPE_INST Lock
lock_price /ACCGO/E_LOCK_PRICE Amount
lock_currency /ACCGO/E_LOCK_CURR Currency
lock_fx /ACCGO/E_LOCK_FX Fix.Ex.Rat
lock_fx_currency_from /ACCGO/E_LOCK_FX_CURR_FROM Currency
lock_fx_currency_to /ACCGO/E_LOCK_FX_CURR_TO Currency
future_lock_instruction_type /ACCGO/E_LOCK_TYPE_INST Lock
future_lock_price /ACCGO/E_LOCK_PRICE Amount
future_lock_currency /ACCGO/E_LOCK_CURR Currency
future_lock_fx /ACCGO/E_LOCK_FX Fix.Ex.Rat
future_lock_fx_currency_from /ACCGO/E_LOCK_FX_CURR_FROM Currency
future_lock_fx_currency_to /ACCGO/E_LOCK_FX_CURR_TO Currency
future_check /ACCGO/E_AMT_CONTRACT Contract
basis_check /ACCGO/E_AMT_CONTRACT Contract
output_process /ACCGO/E_OUTPUT_PROC Output Processing
signature_rel /ACCGO/E_SNP_REL_SIG Rel for Signature
signature_status /ACCGO/E_SIGNATURE_STATUS Signature Status
logically_del /ACCGO/E_LOG_DEL Logical Del
compress_atempt /ACCGO/E_COMP_ATM Comp. Attempt

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.

-- Contract Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_SNPHD1 (
    MANDT,                          -- Client [MANDT]
    DOCUMENT_ID,                    -- Snapshot ID [/ACCGO/E_SNAP_ID]
    APPLICATION,                    -- Snapshot Application [/ACCGO/E_SNP_APPLICATION]
    TIMESTAMP,                      -- Snapshot Timestamp [/ACCGO/E_SNP_TMPSTMP]
    TKONN_EX,                       -- Ext. Identifier [TKONN_EX]
    BTBSTA,                         -- ApplicStatus [BTBSTA]
    TCTYP,                          -- Contract Type [TCTYP]
    KUNNR,                          -- Sold-to Party [KUNAG]
    SDWRS,                          -- Doc. Currency [WAERK]
    COMPANY_CODE,                   -- Company Code [BUKRS]
    ERDAT,                          -- Created On [ERDAT]
    TKSACHB,                        -- Pers. Respons. [TKSACHB]
    ERNAM,                          -- Created By [ERNAM]
    VALID_TILL_DATE,                -- Valid Till [/ACCGO/E_QUOTE_VALID_TILL]
    TRADE_OFFICE,                   -- Trade Office [/ACCGO/E_CS_BP_TRD]
    AENAM,                          -- Changed By [AENAM]
    AEDAT,                          -- Changed On [AEDAT]
    TARGET_PRICE_TYPE,              -- Price Type [/ACCGO/E_TGT_PRICE_TYPE]
    STRIKE_PRICE_AMOUNT,            -- Strike Price Amount [/ACCGO/E_STRIKE_PRICE]
    STRIKE_PRICE_CURRENCY,          -- Price Currency [/ACCGO/E_STRK_PRICE_CURR]
    STRIKE_PRICE_PER_UNIT,          -- Strike Price Unit [/ACCGO/E_PRICE_UNIT]
    STRIKE_PRICE_UOM,               -- Strike Price UoM [/ACCGO/E_PRICE_UOM]
    DCSID_FBO,                      -- DCS ID [TBA_DCSID]
    MATURITY_CODE,                  -- Contr. Maturity Code [TBA_CONTRACT_CODE]
    FBO_EXPIRY_DATE,                -- FBO Expiry Date [/ACCGO/E_FBO_EXPIRY_DATE]
    TARGET_CONTRACT_TYPE,           -- Contract Type [TCTYP]
    AUTOMATIC_CONVERT_TO_CONTRACT,  -- Contract [/ACCGO/E_AMT_CONTRACT]
    LOCK_INSTRUCTION_TYPE,          -- Lock [/ACCGO/E_LOCK_TYPE_INST]
    LOCK_PRICE,                     -- Amount [/ACCGO/E_LOCK_PRICE]
    LOCK_CURRENCY,                  -- Currency [/ACCGO/E_LOCK_CURR]
    LOCK_FX,                        -- Fix.Ex.Rat [/ACCGO/E_LOCK_FX]
    LOCK_FX_CURRENCY_FROM,          -- Currency [/ACCGO/E_LOCK_FX_CURR_FROM]
    LOCK_FX_CURRENCY_TO,            -- Currency [/ACCGO/E_LOCK_FX_CURR_TO]
    FUTURE_LOCK_INSTRUCTION_TYPE,   -- Lock [/ACCGO/E_LOCK_TYPE_INST]
    FUTURE_LOCK_PRICE,              -- Amount [/ACCGO/E_LOCK_PRICE]
    FUTURE_LOCK_CURRENCY,           -- Currency [/ACCGO/E_LOCK_CURR]
    FUTURE_LOCK_FX,                 -- Fix.Ex.Rat [/ACCGO/E_LOCK_FX]
    FUTURE_LOCK_FX_CURRENCY_FROM,   -- Currency [/ACCGO/E_LOCK_FX_CURR_FROM]
    FUTURE_LOCK_FX_CURRENCY_TO,     -- Currency [/ACCGO/E_LOCK_FX_CURR_TO]
    FUTURE_CHECK,                   -- Contract [/ACCGO/E_AMT_CONTRACT]
    BASIS_CHECK,                    -- Contract [/ACCGO/E_AMT_CONTRACT]
    OUTPUT_PROCESS,                 -- Output Processing [/ACCGO/E_OUTPUT_PROC]
    SIGNATURE_REL,                  -- Rel for Signature [/ACCGO/E_SNP_REL_SIG]
    SIGNATURE_STATUS,               -- Signature Status [/ACCGO/E_SIGNATURE_STATUS]
    LOGICALLY_DEL,                  -- Logical Del [/ACCGO/E_LOG_DEL]
    COMPRESS_ATEMPT,                -- Comp. Attempt [/ACCGO/E_COMP_ATM]
    PRIMARY KEY (MANDT, DOCUMENT_ID, APPLICATION, TIMESTAMP)
);

Learn More