OIURV_DOC_DTL_RV
Valuation Reversal Notificaton
OIURV_DOC_DTL_RV is an SAP database table in S/4HANA. Valuation Reversal Notificaton. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRAValnDocTransReversal | view_entity | from | BASIC | Valuation Reversal Notificaton |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | doc_no | OIURV_DOCNR | DocNr | |||
| KEY | doc_year | OIU_DOC_YEAR | Document year | |||
| KEY | line_no | OIU_DOC_LINENR | Doc Line No. | |||
| dn_no | OIU_DN_NO | Delivery network ID | ||||
| prd_dt | OIU_PROD_DT | Prod month | ||||
| wl_no | OIU_WL_NO | Well | ||||
| wc_no | OIU_WC_NO | Well Completion | ||||
| mp_no | OIU_MP_NO | Measurement Pt | ||||
| majpd_cd | OIU_MAJPD_CD | Major Product | ||||
| bukrs | BUKRS | Company Code | ||||
| vname | JV_NAME | Joint venture | ||||
| doi_no | OIU_DOI_NO | Venture/DOI | ||||
| ct_no | OIU_CT_NO | Contract | ||||
| freq_cd | OIU_FREQ_CD | Frequency | ||||
| ppa_rsn_cd | OIU_PPA_RSN_CD | PPA Reason | ||||
| rej_zv_cd | OIU_REJ_ZVCD | Reject / Zero Vol | ||||
| rpt_pos_no | OIU_DOC_POS_NO | Position | ||||
| rej_rsn_cd | OIU_REJ_RSN_CD | Rejection Rsn | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp |
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.
-- Valuation Reversal Notificaton
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_DTL_RV (
MANDT, -- Client [MANDT]
DOC_NO, -- DocNr [OIURV_DOCNR]
DOC_YEAR, -- Document year [OIU_DOC_YEAR]
LINE_NO, -- Doc Line No. [OIU_DOC_LINENR]
DN_NO, -- Delivery network ID [OIU_DN_NO]
PRD_DT, -- Prod month [OIU_PROD_DT]
WL_NO, -- Well [OIU_WL_NO]
WC_NO, -- Well Completion [OIU_WC_NO]
MP_NO, -- Measurement Pt [OIU_MP_NO]
MAJPD_CD, -- Major Product [OIU_MAJPD_CD]
BUKRS, -- Company Code [BUKRS]
VNAME, -- Joint venture [JV_NAME]
DOI_NO, -- Venture/DOI [OIU_DOI_NO]
CT_NO, -- Contract [OIU_CT_NO]
FREQ_CD, -- Frequency [OIU_FREQ_CD]
PPA_RSN_CD, -- PPA Reason [OIU_PPA_RSN_CD]
REJ_ZV_CD, -- Reject / Zero Vol [OIU_REJ_ZVCD]
RPT_POS_NO, -- Position [OIU_DOC_POS_NO]
REJ_RSN_CD, -- Rejection Rsn [OIU_REJ_RSN_CD]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, 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