SAP ABAP Table OIUVL_SCAUDIT (Settlement statement batch)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
     ⤷ OIU_RVVA (Package) PRA Valuation (Revenue)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUVL_SCAUDIT   Table Relationship Diagram
Short Description Settlement statement batch    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 DOC_NO OIURV_DOCNR OIU_MP_NO CHAR 20   0   Val. document number *
3 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
4 LINE_ITEM_NO OIUVL_LINE_ITEM_NO OIUVL_LINE_ITEM_NO NUMC 6   0   Document Line Item Number  
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
7 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
8 SALE_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
9 WI_OWN_NO OIU_WI_OWN_NO KUNNR CHAR 10   0   Working Interest Owner KNA1
10 WI_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type OIU_CM_PINTTY
11 WI_OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
12 TRANSACT_TYPE OIUVL_TRANS_TYPE OIUVL_TRANS_TYPE CHAR 1   0   Transaction Type  
13 SYSTEM_SRCE_CD OIU_VL_SRCE_CD OIU_VL_SRCE_CD CHAR 2   0   Valuation Transaction Source Code  
14 SALE_MONTH OIUVL_SALE_MONTH OIUVL_SALE_MONTH DATS 8   0   Sales Month  
15 TXN_PRCS_CD OIU_TXN_PRCS_CD OIU_TXN_PRCS_CD CHAR 2   0   Transaction Process Code  
16 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
17 MATNR MATNR MATNR CHAR 18   0   Material Number OIU_CM_MAT_PRCD
18 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code OIU_PR_VLTYP
19 DOI_SUM_FL OIU_DOI_SUM_FL OIU_X_FLAG CHAR 1   0   Summarize RD to DOI Level Flag  
20 PURCH_NO OIU_PU_NO KUNNR CHAR 10   0   Purchaser KNA1
21 CT_DECM OIU_CT_DECM OIU_PERCENT98 DEC 9   8   Contract Decimal  
22 HEAT_VAL_FCT_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
23 ACT_HEAT_VAL_FCT OIU_ACT_HEAT_VAL_FCT MENGE QUAN 13   3   Actual Heating Factor  
24 GRV OIB_BDICH OIB_DICHT FLTP 16   16   Oil/gas density at standard/base conditions  
25 DENSITY_U OIB_BDNEH MEINS UNIT 3   0   Unit for densities at standard/base conditions T006
26 DNTYP OIB_DNTYP OIB_DNTYP CHAR 1   0   Density Type  
27 TOT_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
28 ACTL_GR_VL OIU_ACTL_GR_VL_AM MENGE QUAN 13   3   Actual Gross Volume Amount  
29 WLR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
30 ACTL_WLR_VL OIU_ACTL_WLR_VL_AM MENGE QUAN 13   3   Act. Wet-less-Residue Vol. Amount  
31 GR_VAL_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
32 ACTL_GR_VAL OIU_ACTL_GR_VAL_AM WERT7 CURR 13   2   Actual Gross Value Amount  
33 MKCT_1 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
34 MKCT_2 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
35 MKCT_3 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
36 MKCT_4 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
37 MKCT_5 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
38 MKCT_6 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
39 MKCT_7 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
40 MKCT_8 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
41 MKCT_9 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
42 MKCT_10 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
43 MK_RMB_1 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
44 MK_RMB_2 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
45 MK_RMB_3 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
46 MK_RMB_4 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
47 MK_RMB_5 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
48 MK_RMB_6 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
49 MK_RMB_7 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
50 MK_RMB_8 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
51 MK_RMB_9 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
52 MK_RMB_10 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
53 TAX_CALC_FL OIU_TAX_CALC_FL OIU_X_FLAG CHAR 1   0   Calculate Tax Flag  
54 SEVT_TYPE_CD_1 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
55 SEVT_TYPE_CD_2 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
56 SEVT_TYPE_CD_3 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
57 SEVT_TYPE_CD_4 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
58 SEVT_TYPE_CD_5 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
59 SEVT_TYPE_CD_6 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
60 SEVT_TYPE_CD_7 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
61 SEVT_TYPE_CD_8 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
62 SEVT_TYPE_CD_9 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
63 SVTR_1 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
64 SVTR_2 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
65 SVTR_3 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
66 SVTR_4 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
67 SVTR_5 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
68 SVTR_6 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
69 SVTR_7 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
70 SVTR_8 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
71 SVTR_9 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
72 SEVT_1 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
73 SEVT_2 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
74 SEVT_3 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
75 SEVT_4 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
76 SEVT_5 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
77 SEVT_6 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
78 SEVT_7 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
79 SEVT_8 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
80 SEVT_9 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
81 PPA_RSN_CD OIU_PPA_RSN_CD OIU_PPA_RSN_CD CHAR 2   0   Prior Period Adjustment Reason Code OIU_CM_PPARSN
82 .INCLUDE       0   0   Creator and date/time created  
83 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
84 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUVL_SCAUDIT BUKRS T001 BUKRS KEY 1 CN
2 OIUVL_SCAUDIT CT_NO OIUCM_CONTRACT VBELN REF 1 CN
3 OIUVL_SCAUDIT DENSITY_U T006 MSEHI KEY 1 CN
4 OIUVL_SCAUDIT DOI_NO OIU_DO_DI DOI_NO KEY 1 CN
5 OIUVL_SCAUDIT GR_VAL_CURR TCURC WAERS 1 CN
6 OIUVL_SCAUDIT HEAT_VAL_FCT_U T006 MSEHI 1 CN
7 OIUVL_SCAUDIT MATNR OIU_CM_MAT_PRCD MATNR 1 CN
8 OIUVL_SCAUDIT PPA_RSN_CD OIU_CM_PPARSN PPA_RSN_CD 1 CN
9 OIUVL_SCAUDIT PURCH_NO KNA1 KUNNR 1 CN
10 OIUVL_SCAUDIT TOT_GR_VL_U T006 MSEHI 1 CN
11 OIUVL_SCAUDIT VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD REF    
12 OIUVL_SCAUDIT VNAME OIU_DO_JV VNAME KEY 1 CN
13 OIUVL_SCAUDIT WI_INT_TYPE_CD OIU_CM_PINTTY OWN_INT_TYPE_CD KEY 1 N
14 OIUVL_SCAUDIT WI_OWN_NO KNA1 KUNNR KEY 1 CN
15 OIUVL_SCAUDIT WLR_VL_U T006 MSEHI 1 CN
History
Last changed by/on SAP  20050411 
SAP Release Created in