OIUCM_CONTRACT

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.

-- PRA Contracts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUCM_CONTRACT (
    MANDT,             -- Client [MANDT]
    VBELN,             -- Contract [OIU_CT_NO]
    ERDAT,             -- Created On [ERDAT]
    ERZET,             -- Time [ERZET]
    ERNAM,             -- Created By [ERNAM]
    ANGDT,             -- Valid From [ANGDT_V]
    BNDDT,             -- Valid To [BNDDT]
    AUDAT,             -- Document Date [AUDAT]
    VBTYP,             -- Document cat. [VBTYP]
    TRVOG,             -- Transact.Group [TRVOG]
    AUART,             -- Sales Doc. Type [AUART]
    NETWR,             -- Net Value [NETWR_AK]
    WAERK,             -- Doc. Currency [WAERK]
    VKORG,             -- Sales Org. [VKORG]
    VTWEG,             -- Distr. Channel [VTWEG]
    SPART,             -- Division [SPART]
    GUEBG,             -- Valid From [GUEBG]
    GUEEN,             -- Valid To [GUEEN]
    KNUMV,             -- Doc. Condition [KNUMV]
    VDATU,             -- Reqd Deliv Date [EDATU_VBAK]
    VPRGR,             -- Prop.date type [PRGRS_VBAK]
    KALSM,             -- Pric. Procedure [KALSMASD]
    FKARA,             -- Ord-Rel.Bill.Ty [FKARA]
    AWAHR,             -- Probability [AWAHR_AK]
    KTEXT,             -- Description [KTEXT_V]
    BSTNK,             -- Cust. Reference [BSTNK]
    BSTDK,             -- Cust. Ref. Date [BSTDK]
    BNAME,             -- Name [BNAME_V]
    KUNNR,             -- Sold-to Party [KUNAG]
    STWAE,             -- Stats. Currency [STWAE]
    AEDAT,             -- Changed On [AEDAT]
    KOKRS,             -- CO Area [KOKRS]
    BUKRS_VF,          -- CCodeToBeBilled [BUKRS_VF]
    ZTERM,             -- Pyt Terms [DZTERM]
    PRSDT,             -- Pricing Date [PRSDT]
    OIU_CT_TYPE_CD,    -- Contract Type [OIU_CT_TYPE_CD]
    OIU_CUST_VEND_CD,  -- CustVend Ind [OIU_CUST_VEND_CD]
    OIU_APPR_FL,       -- Approved [OIU_APPL_FL]
    OIU_APPR_DT,       -- Appr Date [OIU_APPR_DT]
    OIU_EXEC_DT,       -- Contract Date [OIU_EXEC_DT]
    OIU_STD_CT_FL,     -- Standard Ct [OIU_STD_CT_FL]
    OIU_PREV_CT_NO,    -- Old Contract [OIU_PREV_CT_NO]
    OIU_GPLT_COMPANY,  -- Gplt Comp [OIU_GPLT_BUKRS]
    OIU_GPLT_VNAME,    -- Gplt Venture [OIU_GPLT_VNAME]
    OIU_GPLT_DOI_NO,   -- Gplt DOI [OIU_GPLT_DOI_NO]
    OIU_MK_REP_NO,     -- Marketing Rep [OIU_MK_REP_NO]
    OIU_MK_REP_ISQ,    -- Mkt. Rep. ISQ [OIU_MK_REP_ISQ_NO]
    OIU_DEST_SALE_CD,  -- Plt Destination [OIU_DEST_SALE_CD]
    OIU_LIFE_LSE_FL,   -- Life Lease [OIU_LIFE_LSE_FL]
    OIU_INV_NO,        -- Invoice Number [OIU_INV_NO]
    OIU_INV_FL,        -- Invoice Flag [OIU_INV_FL]
    OIU_OBLIG_DT,      -- Obligation Dt [OIU_OBLIG_DT]
    OIU_DESK_CD,       -- Desk Code [OIU_DESK_CD]
    OIU_EIA_GINA_CD,   -- EIA Report Cd [OIU_EIA_GINA_CD]
    OIU_CT_STATUS_CD,  -- Status Code [OIU_CT_STATUS_CD]
    OIU_SPOT_TERM_CD,  -- Spot/Term [OIU_SPOT_TERM_CD]
    OIU_STNDEDQ_CD,    -- COPAS/EDQ [OIU_STNDEDQ_CD]
    OIU_IOTR_FL,       -- Inc Tax Reimb [OIU_IOTR_FL]
    OIU_INTRA_INTER,   -- Boundaries [OIU_INTRA_INTER_CD]
    OIU_EXRES_SPLT,    -- Excess Residue [OIU_EXRES_SPLT_CD]
    OIU_EVGN_FL,       -- Evergreen [OIU_EVGN_FL]
    OIU_EVGNPD_BAS,    -- Period Basis [OIU_EVGNPD_BAS_CD]
    OIU_EVGN_PERD_QY,  -- Period Length [OIU_EVGN_PERD_QY]
    OIU_PREIM_TM_CD,   -- Primary Basis [OIU_PREIM_TM_CD]
    OIU_PRIM_TM_QY,    -- Primary Length [OIU_PRIM_TM_QY]
    OIU_SEC_TM_CD,     -- Secondary Basis [OIU_SEC_TM_CD]
    OIU_SEC_TM_QY,     -- Secondary Length [OIU_SEC_TM_QY]
    OIU_EXP_NOTIF_DT,  -- Exp Notify Date [OIU_EXP_NOTIF_DT]
    OIU_INTIT_RDT_DT,  -- Date [OIU_INTIT_RDT_DT]
    OIU_NEXT_RDT_DT,   -- N. date [OIU_NEXT_RDT_DT]
    OIU_RTC_DT,        -- RTC date [OIU_RTC_DT]
    OIU_RDT_N_PERD,    -- Period [OIU_RDT_N_PERD_QY]
    OIU_RDT_REFQ_CD,   -- Redeterm Freq [OIU_RDT_REFQ_CD]
    OIU_RTF_CD,        -- Date [OIU_RTF_DT]
    OIU_IMB_PRVSN_FL,  -- Imbalance Prov [OIU_IMB_PRVSN_FL]
    OIU_FFEE_RMB_FL,   -- Filing Fee Reim [OIU_FFEE_RMB_FL]
    OIU_FIRM_INTRPT,   -- Firm/Interrupt [OIU_FIRM_INTRPT_CD]
    OIU_BAL_BAS_CD,    -- Bal Basis [OIU_BAL_BAS_CD]
    OIU_PNTY_BAS_CD,   -- Penalty Basis [OIU_PNTY_BAS_CD]
    OIU_TRANSP_BA,     -- Transp Basis Cd [OIU_TRANSP_BAS_CD]
    OIU_DLY_MAX_T_QY,  -- Dly Max Trnsp [OIU_DLY_MAX_T_QY]
    OIU_PRCS_FL,       -- Process [OIU_PRCS_FL]
    OIU_SPR_FL,        -- Separation [OIU_SPR_FL]
    OIU_DEHYD_FL,      -- Dehydration [OIU_DEHYD_FL]
    OIU_COMPR_FL,      -- Compression [OIU_COMPR_FL]
    OIU_PYMT_METH_CD,  -- Payment Method [OIU_PYMT_METH_CD]
    OIU_CON_MATNR,     -- Contaminant [OIU_CON_MATNR]
    OIU_CON_MAX_QY,    -- Contaminant % [OIU_CON_MAX_QY]
    OIU_AFFIL_FL,      -- Affiliate Flag [OIU_AFFIL_FL]
    OIU_MMS_TYPE_CD,   -- MMS Sales Type [OIUREP_MMS_2014_SALES_TYPE_CD]
    OIU_MMS_ETPAY_FL,  -- Est. Payment [OIUREP_MMS_2014_CT_EST_PAY_FL]
    OIUH_CT_NO,        -- Contract [OIUH_CT_NO]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, VBELN)
);