TB2BE

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.

-- Trading Contract: Trading Contract Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TB2BE (
    MANDT,                 -- Client [MANDT]
    TCTYP,                 -- Contract Type [TCTYP]
    TDTPV,                 -- Control Grp Pur [TDTPV]
    TDTPC,                 -- Cntrl Grp Sales [TDTPC]
    STATGR,                -- Status Group [STATGR]
    TXTGR,                 -- TextDetermProc. [TXTGR]
    INCPO,                 -- ItemNoIncrement [INCPO]
    DEFWAERS,              -- Default Currncy [DEFWAERS]
    DEFKURST,              -- Def.ExRate Type [DEFKURST]
    NUMKI,                 -- NR of Int. Asst [NUMKI]
    TCUNCGR,               -- Incompleten.Grp [TCUNCGR]
    TCSACHV,               -- Suggest Person [TCSACHV]
    GBATCH,                -- BatchGeneration [GBATCH]
    TCTDID,                -- Dflt text type [TCTDID]
    WCHUN,                 -- Completen.Check [WCHUN]
    WCHQU,                 -- Quantity Check [WCHQU]
    LIVAR,                 -- List variant [LIVAR]
    KAPPL_NA,              -- Application [NA_KAPPL]
    KALSMK_MGT,            -- MessSchem.Empl. [KALSMB_MGT]
    KALSMP_MGT,            -- MsgSch.Empl.Itm [KALSMBP_MGT]
    TC_URL,                -- TradContr URL [TC_URL]
    USE_CASE,              -- Use Case Type [WB2_USE_CASE_TYPE]
    CEACT,                 -- FastDatEntry Act. [/SAPMP/CEACT]
    PDACT,                 -- Inher. Activated [/SAPMP/PDACT]
    PPROT,                 -- Inheritance Log [/SAPMP/PPROT]
    PUSER,                 -- Inhrtnce: UsrValues [/SAPMP/PUSER]
    PAUSW,                 -- Inherit.Char.Slctn. [/SAPMP/PAUSW]
    ATNAM,                 -- Characteristic [MILL_SE_ATNAM1]
    PARTNER_POP_UP,        -- Pop Up for Partner Selection [WB2_PARTNER_POP_UP]
    TCCAT,                 -- TC Category [TCCAT]
    TKONN_EX_ACT,          -- Ext. ID. Active [TKONN_EX_ACT]
    TKONN_EX_CHECK,        -- Check Ext. ID [TKONN_EX_CHECK]
    TC_CHANGE_CHECK,       -- FldCheckSchema [TC_CHANGE_CHECK]
    POFOST,                -- Determin. Type [WB2_CONTR_GROUP]
    BTBSTA_DEF_INCO,       -- DefAppStatIncom [BTBSTA_DEF_INCO]
    BTBSTA_DEF,            -- DefApplicStatus [BTBSTA_DEF]
    FOL_DOC_DIR,           -- Direct FollowOn [WB2_FOLLOW_DOC_DIRECT]
    TC_TYPE_BLOCK,         -- Type Block [WB2_TC_TYPE_BLOCK]
    PZUGR,                 -- Responsib. Grp [PZUGR]
    TCGROUP,               -- TC Group [WB2_TCGROUP]
    DELIVDEF,              -- Default DeliveryDate [WB2_DELIVDATE_DEFAULT]
    PRICE_DEFAULT,         -- Price Proposal [WB2_PRICE_DEFAULT]
    PARGR,                 -- PartnDet.Proc. [PARGR]
    CLOSING_RULE,          -- Completion Rule [WB2_CLOSING_RULE]
    WB2_BEZOB,             -- Ref. Required [WB2_BEZOB]
    ASSO_OFF,              -- Deactivate Ass. [WB2_ASSO_OFF]
    PRCHGRP,               -- PriceChnge Grp [WB2_PRCHGRP]
    BWREL,                 -- BW-Relevant [BWREL]
    PRICING_TYPE,          -- Pricing [WB2_PRICING_TYPE]
    TCVARIANT,             -- Variant [TCVARIANT]
    GTS_RELEVANT,          -- GlobalTradeServices [WB2_GTS_RELEVANT]
    EVENT_RELEVANT,        -- Events [WB2_EVENT_RELEVANT]
    LIGRU,                 -- List group [LIGRU]
    PLANT_CONTROL,         -- Plant [WB2_PLANT_CONTROL]
    PURCHASE_PLANT,        -- Additnl Setting [WB2_PURCHASE_PLANT]
    CONTEXT,               -- Context [WUF_CONTEXT]
    TYPE_USAGE,            -- Entry Type [WB2_TYPE_USAGE]
    REP_GROUP,             -- Replication Group [WB2_REPLICATION_GROUP]
    AR_OBJECT,             -- Document type [SAEOBJART]
    ITEM_HANDLING,         -- Item Number [WB2_ITEM_HANDLING]
    CHANGE_DOC,            -- Chg. Documents [WB2_CHANGE_DOC]
    DOCUMENT_INDEX,        -- Doc.Index Active [WB2_DOCUMENT_INDEX_ACTIVE]
    DOC_INDEX_DELETE,      -- Delete [WB2_DOC_INDEX_DEL_AFTER_CLOSE]
    PARTNER_HI,            -- Partner Hierarchy [WB2_PARTNER_HIERARCHY]
    BATCH_DET_ACT,         -- Batch Determin [WB2B_BATCH_DETERMINATION]
    TXZUF,                 -- Text Group [WB2_TXZUF]
    SINGLE_ORG_DATA,       -- Org. Data [WB2_SINGLE_ORG_DATA]
    CONSOL_CONTEXT,        -- Context [WB2_CONSOLIDATION_CONTEXT]
    FREEZE_GROUP,          -- Freeze Group [WB2_FREEZE_GROUP]
    CALL_OFF_PARTY,        -- Check Partner [WB2_CALL_OFF_PARTY]
    WRART,                 -- Settl Proc Type [WRART]
    LFART_C,               -- Settl Doc Type [WB2_LFART_CUSTOMER]
    LFART_V,               -- Settl Doc Type [WB2_LFART_VENDOR]
    LFART,                 -- Settl Doc Type [WB2_LFART]
    SET_VARIANT,           -- Process Variant [WB2_WASHOUT_SET_VARIANT]
    GTS_CHECK,             -- GTS Check [WB2_GTS_CHECK_AT_UPDATE]
    FLOW_DISPLAY,          -- Document Flow [WB2_FLOW_DISPLAY]
    FLOW_SIZE,             -- Max Entries [WB2_FLOW_SIZE]
    RELEASE_LOG,           -- Application Log [WB2_RELEASE_LOG]
    PURPOSE,               -- Purpose [WB2_TC_PURPOSE]
    ITEM_REL_TYPE,         -- Undefined range (can be used for patch levels) [CHAR4]
    LOCK_FOL_DOCS,         -- Lock [WB2_LOCK_FOLLOW_ON_DOCS]
    SETTL_PURPOSE,         -- Settlement Purpose [WB2_SETTLEMENT_PURPOSE]
    BATCH_CLASS,           -- Batch Classification [WB2_BATCH_CLASS_ENABLED]
    PPE_GROUP_CODE,        -- PPE Group [PPE_GROUP]
    DELIVDEF_TYPE,         -- Default Date Type [WB2_DELIVDATE_TYPE_DEFAULT]
    TRMRISK_CTRL,          -- Exp.Upd.Ctrl [WB2_TRM_RISK_UPD_CONTROL]
    TIME_CONTROL,          -- Date & Time [WB2_TIME_CONTROL]
    ITMAC,                 -- Trade Compliance [/SAPSLL/ITMAC]
    OUTPUT_CONTROL_USAGE,  -- Output Control Indicator [WB2_OUTPUT_CONTROL_USAGE]
    PRIMARY KEY (MANDT, TCTYP)
);