OIURV_DOC_HDR
Valuation Document Header
OIURV_DOC_HDR is an SAP database table in S/4HANA. Valuation Document Header. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ValuationDocumentHdr | view | from | BASIC | Valuation Document Header |
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 | |||
| dn_no | OIU_DN_NO | Delivery network ID | ||||
| dn_grp | OIU_DN_SET | DN Hier. Node | ||||
| sale_dt | OIU_SALE_DT | Sales Date | ||||
| freq_cd | OIU_FREQ_CD | Frequency | ||||
| doc_status | OIU_DOC_STATUS | VL Doc Status | ||||
| doc_type | OIU_DOC_TYPE | Doc Type | ||||
| application | OIU_APPLICATION | Application | ||||
| process | OIU_PROCESS | Process | ||||
| func_sequence | OIU_FUNC_SEQUENCE | FunctionSequenc | ||||
| func_name | RS38L_FNAM | Function Module | ||||
| app_log_no | BALOGNR | Log Number | ||||
| proc_status | OIU_PROC_STATUS | VL Doc Proc Status | ||||
| run_date | OIU_RUN_DATE | Run date | ||||
| run_time | OIU_RUN_TIME | Run time | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp | ||||
| arch_flag | /PRA/RD_ARCH_FLAG | Archiving Flag | ||||
| new_rd_fl | BOOLE_D | TRUE |
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 Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_HDR (
MANDT, -- Client [MANDT]
DOC_NO, -- DocNr [OIURV_DOCNR]
DOC_YEAR, -- Document year [OIU_DOC_YEAR]
DN_NO, -- Delivery network ID [OIU_DN_NO]
DN_GRP, -- DN Hier. Node [OIU_DN_SET]
SALE_DT, -- Sales Date [OIU_SALE_DT]
FREQ_CD, -- Frequency [OIU_FREQ_CD]
DOC_STATUS, -- VL Doc Status [OIU_DOC_STATUS]
DOC_TYPE, -- Doc Type [OIU_DOC_TYPE]
APPLICATION, -- Application [OIU_APPLICATION]
PROCESS, -- Process [OIU_PROCESS]
FUNC_SEQUENCE, -- FunctionSequenc [OIU_FUNC_SEQUENCE]
FUNC_NAME, -- Function Module [RS38L_FNAM]
APP_LOG_NO, -- Log Number [BALOGNR]
PROC_STATUS, -- VL Doc Proc Status [OIU_PROC_STATUS]
RUN_DATE, -- Run date [OIU_RUN_DATE]
RUN_TIME, -- Run time [OIU_RUN_TIME]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
ARCH_FLAG, -- Archiving Flag [/PRA/RD_ARCH_FLAG]
NEW_RD_FL, -- TRUE [BOOLE_D]
PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR)
);
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