OIUCI_CDEXD

Transparent Table Application Table

CDEX Detail

OIUCI_CDEXD is an SAP database table in S/4HANA. CDEX Detail. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAChkInptCDEXDetail view_entity from BASIC Input CDEX Details

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY co_no oiuci_cdex_company CDEX Company
KEY own_no oiuci_owner_number Owner Number
KEY ck_no oiuci_cdex_check_no Check #
KEY line_no oiuci_line_number Line No.
lease_code oiuci_lease_code Lease code
prod_from_dt oiuci_production_from_date Prod From Date
prod_to_dt oiuci_production_to_date Prod To Date
pd_cd oiuci_cdex_product_code Product
tran_code_1 oiuci_transaction_code_1 Tran Cd 1
tran_code_2 oiuci_transaction_code_2 Tran Cd 2
lse_gr_vol oiuci_lse_gr_vol Lse Gr Vol
lse_gr_sev oiuci_lse_gr_sev_tax Lse Gr Sev
lse_net_val oiuci_lse_net_val Lse Net
lse_gr_crwpt oiuci_lse_gr_crwpt Lse Gr C/R/WPT
own_net_val oiuci_own_net_val Own Net
own_crwpt oiuci_own_crwpt Own C/R/WPT
trans_date oiuci_transmission_date Transmission Date
type_interest oiuci_type_interest Type Int
dec_int_fl oiuci_decimal_flag Decimal Flag
dec_int oiuci_decimal_interest Decimal Interest
btu_fact oiuci_btu_factor BTU Factor
status oiuci_check_line_status Chk Ln St
rej_rsn_cd oiuci_rej_reason_cd Rej rsn

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.

-- CDEX Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUCI_CDEXD (
    MANDT,          -- Client [mandt]
    CO_NO,          -- CDEX Company [oiuci_cdex_company]
    OWN_NO,         -- Owner Number [oiuci_owner_number]
    CK_NO,          -- Check # [oiuci_cdex_check_no]
    LINE_NO,        -- Line No. [oiuci_line_number]
    LEASE_CODE,     -- Lease code [oiuci_lease_code]
    PROD_FROM_DT,   -- Prod From Date [oiuci_production_from_date]
    PROD_TO_DT,     -- Prod To Date [oiuci_production_to_date]
    PD_CD,          -- Product [oiuci_cdex_product_code]
    TRAN_CODE_1,    -- Tran Cd 1 [oiuci_transaction_code_1]
    TRAN_CODE_2,    -- Tran Cd 2 [oiuci_transaction_code_2]
    LSE_GR_VOL,     -- Lse Gr Vol [oiuci_lse_gr_vol]
    LSE_GR_SEV,     -- Lse Gr Sev [oiuci_lse_gr_sev_tax]
    LSE_NET_VAL,    -- Lse Net [oiuci_lse_net_val]
    LSE_GR_CRWPT,   -- Lse Gr C/R/WPT [oiuci_lse_gr_crwpt]
    OWN_NET_VAL,    -- Own Net [oiuci_own_net_val]
    OWN_CRWPT,      -- Own C/R/WPT [oiuci_own_crwpt]
    TRANS_DATE,     -- Transmission Date [oiuci_transmission_date]
    TYPE_INTEREST,  -- Type Int [oiuci_type_interest]
    DEC_INT_FL,     -- Decimal Flag [oiuci_decimal_flag]
    DEC_INT,        -- Decimal Interest [oiuci_decimal_interest]
    BTU_FACT,       -- BTU Factor [oiuci_btu_factor]
    STATUS,         -- Chk Ln St [oiuci_check_line_status]
    REJ_RSN_CD,     -- Rej rsn [oiuci_rej_reason_cd]
    PRIMARY KEY (MANDT, CO_NO, OWN_NO, CK_NO, LINE_NO)
);