OIUH_CM_BA

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.

-- Oil and Gas appl table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUH_CM_BA (
    MANDT,            -- Client [MANDT]
    BA_BA_NO,         -- Business Assoc [OIUCM_BUS_ASSOC]
    BA_SEQ_NO,        -- Sequence Number [OIUCM_SEQ_NO]
    BA_NM_19,         -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_NM_1,          -- BA Name [OIUCM_BA_NAME]
    BA_NM_29,         -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_NM_2,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_NM_39,         -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_NM_3,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_NM_49,         -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_NM_4,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_AD_1,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_AD_2,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_AD_3,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_AD_4,          -- OIUH_CHAR38 [OIUH_CHAR38]
    BA_CITY_NM9,      -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_CITY_NM,       -- OIUH_CHAR25 [OIUH_CHAR25]
    BA_ST_CD,         -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_ST_RES_CD,     -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_ZIP_NO,        -- OIUH_CHAR10 [OIUH_CHAR10]
    BA_BKUP_WH_FL,    -- OIUH_CHAR1 [OIUH_CHAR1]
    RSTR_TXNCHG_FL,   -- OIUH_CHAR1 [OIUH_CHAR1]
    A_FUNDS_TFER_CD,  -- OIUH_CHAR1 [OIUH_CHAR1]
    A_JIB_BA_SEQ_NO,  -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_JIB_BA_NO,     -- OIUH_CHAR6 [OIUH_CHAR6]
    BA_BNK_NO,        -- OIUH_CHAR9 [OIUH_CHAR9]
    BA_BNK_ACC_NO,    -- OIUH_CHAR9 [OIUH_CHAR9]
    BA_BNK_SER_AM,    -- Local amount [OIUH_CURR5_2]
    BA_BNK_DED_FL,    -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_JIB_FL,        -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_MIN_PAY_AM,    -- Local amount [OIUH_CURR5_2]
    BA_PAY_FRQ_CD,    -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_CNTRY_CD,      -- OIUH_CHAR3 [OIUH_CHAR3]
    BA_CHK_FIR_FL,    -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_SSN_TYPE_CD,   -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_STS_CD,        -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_AUTH_USER_ID,  -- OIUH_CHAR6 [OIUH_CHAR6]
    BA_STOP_PAY_FL,   -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_PRDR_TYPE_CD,  -- OIUH_CHAR2 [OIUH_CHAR2]
    A_1_PRDR_STS_CD,  -- OIUH_CHAR2 [OIUH_CHAR2]
    A_2_PRDR_STS_CD,  -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_SSN_NO,        -- Tax ID [OIUCM_BA_SSN_NO]
    BA_NRA_TAX_CD,    -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_GEN_1099_FL,   -- OIUH_CHAR1 [OIUH_CHAR1]
    A_OVRD_RCPMT_FL,  -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_ENTY_USG_CD,   -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_TEL_NO,        -- OIUH_CHAR10 [OIUH_CHAR10]
    A_1_HIST_OLD_NO,  -- OIUH_CHAR10 [OIUH_CHAR10]
    A_2_HIST_OLD_NO,  -- OIUH_CHAR10 [OIUH_CHAR10]
    BA_INTRNL_CO_NO,  -- OIUH_CHAR3 [OIUH_CHAR3]
    BA_ENTY_CD,       -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_NOM_FAX_NO,    -- OIUH_CHAR12 [OIUH_CHAR12]
    BA_RECOUP_PC,     -- OIUH_DEC3 [OIUH_DEC3]
    ALLOT_PX_MTH_CD,  -- OIUH_CHAR2 [OIUH_CHAR2]
    BA_REF_CD,        -- OIUH_CHAR10 [OIUH_CHAR10]
    BA_CMT_FL,        -- OIUH_CHAR1 [OIUH_CHAR1]
    BA_VER_NO,        -- OIUH_DEC5 [OIUH_DEC5]
    BA_USER_ID,       -- OIUH_CHAR8 [OIUH_CHAR8]
    BA_TIMESTAMP,     -- OIUH_CHAR14 [OIUH_CHAR14]
    ADDRESS_KEY9,     -- OIUH_CHAR1 [OIUH_CHAR1]
    ADDRESS_KEY,      -- Vendor/Customer [OIUH_VENDOR_OR_CUSTOMER]
    RES_CNTRY,        -- Res. Ctry/Reg. [OIU_RES_CNTRY]
    BUKRS,            -- Company Code [BUKRS]
    PRIMARY KEY (MANDT, BA_BA_NO, BA_SEQ_NO)
);