OIUCI_CDEXD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRAChkInptCDEXDetail | view_entity | from | BASIC | Input CDEX Details |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA