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)
);