OIU_RV_VLTXNS SAP (Valuation Transactions) Table details

Dictionary Type: Table
Description: Valuation Transactions




ABAP Code to SELECT data from OIU_RV_VLTXNS
Related tables to OIU_RV_VLTXNS
Access table OIU_RV_VLTXNS




Table field list including key, data, relationships and ABAP select examples

OIU_RV_VLTXNS is a standard SAP Table which is used to store Valuation Transactions data and is available within R/3 SAP systems depending on the version and release level.

The OIU_RV_VLTXNS table consists of various fields, each holding specific information or linking keys about Valuation Transactions data available in SAP. These include DN_NO (Delivery network number), WL_NO (Well ID number), WC_NO (Well Completion Number), MP_NO (Measurement point number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIU_RV_VLTXNS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
DN_NODelivery network number OIU_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
MP_NOMeasurement point number OIU_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
MATNRMaterial Number MATNRCHAR18OIU_CM_MAT_PRCDMATN1MATNRMATS_MAT1
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
CT_NOContract Number OIU_CT_NOCHAR10OIU_RV_CTALPHAOIUCM_CONTRACT_NUMBEROIU_CID
MAJPD_CDMajor product code OIU_MAJPD_CDCHAR1OIU_MAJPD_CDOIU_MAJPD
FREQ_CDFrequency OIU_FREQ_CDCHAR1OIU_FREQ_CDOIU_FRQ
SALE_DTSales Date / Month OIU_SALE_DTDATS8DATUM
SCHOOL_DIST_CDSchool district code OIU_SCHOOL_DIST_CDCHAR3Assigned to domainOIU_SCHOOL_DIST_CD
TAX_CLSTax Class OIU_TAX_CLSCHAR4Assigned to domainOIU_TAX_CLSOIU_TAX_CLS
VLTXNS_NOValuation Transaction Number OIU_VLTXNS_NONUMC12OIU_SYS_NO
POS_NOLast used (highest) position number OIU_LAST_POSNUMC3NUMC3
FRML_NOFormula number OIU_FRML_NOCHAR8OIU_RV_FRMLOIU_FORMULA_NOOIU_FRML
LVL_CDLevel Code OIU_LVL_CDNUMC2OIU_LVL_CD
GROUP_CDGroup Code OIU_GROUP_CDCHAR1OIU_GROUP_CD
PPA_RSN_CDPrior Period Adjustment Reason Code OIU_PPA_RSN_CDCHAR2OIU_CM_PPARSNOIU_PPA_RSN_CD
UNIT_VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_SUM_FLSummarize RD to DOI Level Flag OIU_DOI_SUM_FLCHAR1OIU_X_FLAG
RM_FEE_FLCO2 Removal Fee Flag OIU_RM_FEE_FLCHAR1OIU_X_FLAG
DUAL_ACCT_FLDual Accounting Flag OIU_DUAL_ACCT_FLCHAR1OIU_X_FLAG
TXN_PRCS_CDTransaction Process Code OIU_TXN_PRCS_CDCHAR2OIU_TXN_PRCS_CD
CT_TYPE_CDContract Type OIU_CT_TYPE_CDCHAR2OIU_CM_CTTYPOIU_CT_TYPE_CDOIU_CTY
VL_VAL_ON_VAL_FLValue on Value indicator OIU_VL_VAL_ON_VAL_FLCHAR1OIU_X_FLAG
REJ_REPRCS_FLReject Reprocess Flag OIU_REJ_REPRCS_FLCHAR1OIU_X_FLAG
FULL_SMPL_PLT_CDFull Simple Plant Network OIU_FULL_SMPL_PLT_CDCHAR1OIU_FUL_SP_PLT_DN_NO
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table OIU_RV_VLTXNS using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIU_RV_VLTXNS to SELECT all data from the table
DATA: WA_OIU_RV_VLTXNS TYPE OIU_RV_VLTXNS.

SELECT SINGLE *
FROM OIU_RV_VLTXNS
INTO CORRESPONDING FIELDS OF WA_OIU_RV_VLTXNS
WHERE...

How to access SAP table OIU_RV_VLTXNS

Within an ECC or HANA version of SAP you can also view further information about OIU_RV_VLTXNS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!