SAP ABAP Table ROIUVL_SCTXNS1 (Settlement statement/CI transaction)
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 INTTAB    Structure 
Structure ROIUVL_SCTXNS1   Table Relationship Diagram
Short Description Settlement statement/CI transaction    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 SCTXNS_NO OIUVL_SCTXNS_NO OIU_SYS_NO NUMC 12   0   Document number for the transaction  
2 DOC_NO OIU_DOCNR OIU_DOCNR CHAR 10   0   volumes document number  
3 DOC_YEAR OIU_DOC_YEAR GJAHR NUMC 4   0   Document year  
4 DOC_DT OIUVL_DOC_DT OIUVL_DOC_DT DATS 8   0   Document date  
5 TXN_TYPE OIUVL_TXN_TYPE OIUVL_TXN_TYPE CHAR 1   0   Transaction type  
6 SETT_REF_NO OIUVL_SETT_REF_NO CHAR18 CHAR 18   0   Settlement statement identification number  
7 DOC_REF_NO OIUVL_DOC_REF_NO OIUVL_DOC_REF_NO CHAR 10   0   Related Document  
8 PU_NO OIU_PU_NO KUNNR CHAR 10   0   Purchaser KNA1
9 LINE_ITEM_NO OIU_LIN_NO NUMC5 NUMC 5   0   Line Number  
10 PPA_RSN_CD OIU_PPA_RSN_CD OIU_PPA_RSN_CD CHAR 2   0   Prior Period Adjustment Reason Code OIU_CM_PPARSN
11 REJ_RSN_CD OIU_REJ_RSN_CD OIU_REJ_RSN_CD CHAR 3   0   Rejection Reason Code OIU_CM_REJCD
12 VL_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
13 SETT_MATNR MATNR MATNR CHAR 18   0   Material Number OIU_CM_MAT_PRCD
14 MATNR MATNR MATNR CHAR 18   0   Material Number OIU_CM_MAT_PRCD
15 MAJPD_CD OIU_MAJPD_CD OIU_MAJPD_CD CHAR 1   0   Major product code OIU_CM_PDCD
16 SETT_BUKRS OIUVL_SETT_BUKRS BUKRS CHAR 4   0   Settlement Company Code *
17 SETT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
18 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
19 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
20 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
21 COST_CENTER KOSTL KOSTL CHAR 10   0   Cost Center *
22 LVL_CD OIU_LVL_CD OIU_LVL_CD NUMC 2   0   Level Code  
23 WI_OWN_NO OIU_WI_OWN_NO KUNNR CHAR 10   0   Working Interest Owner KNA1
24 WI_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type OIU_CM_PINTTY
25 WI_OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
26 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
27 CT_TYPE_CD OIU_CT_TYPE_CD OIU_CT_TYPE_CD CHAR 2   0   Contract Type OIU_CM_CTTYP
28 FREQ_CD OIU_FREQ_CD OIU_FREQ_CD CHAR 1   0   Frequency  
29 SALE_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
30 UNIT_BUKRS OIUVL_UNIT_BUKRS BUKRS CHAR 4   0   Unit Company Code *
31 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
32 DOI_SUM_FL OIU_DOI_SUM_FL OIU_X_FLAG CHAR 1   0   Summarize RD to DOI Level Flag  
33 TXN_PRCS_CD OIU_TXN_PRCS_CD OIU_TXN_PRCS_CD CHAR 2   0   Transaction Process Code  
34 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
35 PRI_GEO_LOC OIU_PRI_GEO_LOC OIU_PRI_GEO_LOC CHAR 2   0   Primary geographical location (PRI geo. loc.) OIU_CM_LXPGL
36 SEC_GEO_LOC OIU_SEC_GEO_LOC OIU_SEC_GEO_LOC CHAR 3   0   Secondary geographic location OIU_CM_LXSGL
37 ONS_OFFS_CD OIU_ONS_OFS_CD OIU_ONS_OFS_CD CHAR 1   0   Onshore/Offshore codes  
38 SYSTEM_SRCE_CD OIU_VL_SRCE_CD OIU_VL_SRCE_CD CHAR 2   0   Valuation Transaction Source Code  
39 VNAME_TYPE_CD OIU_VNAME_TYPE_CD OIU_PR_TYPE_CD CHAR 2   0   Venture Usage Type  
40 THEO_CND_TAX_FL OIU_THEO_CND_TAX_FL OIU_X_FLAG CHAR 1   0   Theoretical Condensate Tax Calculation Flag  
41 TOT_GRI_PC OIU_TOT_GRI_PC OIU_PERCENT98 DEC 9   8   Total Gross Interest %  
42 CT_DECM OIU_CT_DECM OIU_PERCENT98 DEC 9   8   Contract Decimal  
43 REL_CT_DECM OIU_REL_CT_DECM OIU_PERCENT98 DEC 9   8   Relative Contract Decimal  
44 TOT_MKT_GRP_GRI OIU_TOT_MKT_GRP_GRI OIU_PERCENT98 DEC 9   8   Total Market Groups GRI  
45 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code OIU_PR_VLTYP
46 TOT_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
47 ACTL_GR_VL OIU_ACTL_GR_VL_AM MENGE QUAN 13   3   Actual Gross Volume Amount  
48 ENERGY_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
49 ACTL_ENERGY OIU_ACTL_ENERGY MENGE QUAN 13   3   Actual Energy  
50 GRV OIB_BDICH OIB_DICHT FLTP 16   16   Oil/gas density at standard/base conditions  
51 DENSITY_U OIB_BDNEH MEINS UNIT 3   0   Unit for densities at standard/base conditions T006
52 DNTYP OIB_DNTYP OIB_DNTYP CHAR 1   0   Density Type  
53 HEAT_VAL_FCT_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
54 ACT_HEAT_VAL_FCT OIU_ACT_HEAT_VAL_FCT MENGE QUAN 13   3   Actual Heating Factor  
55 WLR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit T006
56 ACTL_WLR_VL OIU_ACTL_WLR_VL_AM MENGE QUAN 13   3   Act. Wet-less-Residue Vol. Amount  
57 GR_VAL_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
58 ACTL_GR_VAL OIU_ACTL_GR_VAL_AM WERT7 CURR 13   2   Actual Gross Value Amount  
59 MKCT_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
60 MKCT_1 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
61 MKCT_2 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
62 MKCT_3 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
63 MKCT_4 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
64 MKCT_5 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
65 MKCT_6 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
66 MKCT_7 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
67 MKCT_8 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
68 MKCT_9 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
69 MKCT_10 OIUVL_MKCT WERT8 CURR 15   2   Marketing cost amount  
70 MK_RMB_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
71 MK_RMB_1 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
72 MK_RMB_2 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
73 MK_RMB_3 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
74 MK_RMB_4 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
75 MK_RMB_5 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
76 MK_RMB_6 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
77 MK_RMB_7 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
78 MK_RMB_8 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
79 MK_RMB_9 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
80 MK_RMB_10 OIUVL_MK_RMB WERT8 CURR 15   2   Marketing Reimbursement  
81 TAX_CALC_FL OIU_TAX_CALC_FL OIU_X_FLAG CHAR 1   0   Calculate Tax Flag  
82 SEVT_TYPE_CD_1 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
83 SEVT_TYPE_CD_2 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
84 SEVT_TYPE_CD_3 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
85 SEVT_TYPE_CD_4 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
86 SEVT_TYPE_CD_5 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
87 SEVT_TYPE_CD_6 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
88 SEVT_TYPE_CD_7 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
89 SEVT_TYPE_CD_8 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
90 SEVT_TYPE_CD_9 OIU_SEVT_TYPE_CD CHAR2 CHAR 2   0   Severance tax type code  
91 SEV_TAX_PAY_CD_1 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
92 SEV_TAX_PAY_CD_2 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
93 SEV_TAX_PAY_CD_3 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
94 SEV_TAX_PAY_CD_4 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
95 SEV_TAX_PAY_CD_5 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
96 SEV_TAX_PAY_CD_6 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
97 SEV_TAX_PAY_CD_7 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
98 SEV_TAX_PAY_CD_8 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
99 SEV_TAX_PAY_CD_9 OIUVL_SEV_TAX_PAY_CD OIU_FLAG CHAR 1   0   Severance tax pay code  
100 SEV_TAX_RPT_CD_1 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
101 SEV_TAX_RPT_CD_2 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
102 SEV_TAX_RPT_CD_3 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
103 SEV_TAX_RPT_CD_4 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
104 SEV_TAX_RPT_CD_5 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
105 SEV_TAX_RPT_CD_6 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
106 SEV_TAX_RPT_CD_7 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
107 SEV_TAX_RPT_CD_8 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
108 SEV_TAX_RPT_CD_9 OIUVL_SEV_TAX_RPT_CD OIU_FLAG CHAR 1   0   Severance tax report code  
109 SVTR_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
110 SVTR_1 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
111 SVTR_2 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
112 SVTR_3 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
113 SVTR_4 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
114 SVTR_5 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
115 SVTR_6 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
116 SVTR_7 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
117 SVTR_8 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
118 SVTR_9 OIUVL_SVTR WERT8 CURR 15   2   Tax or reimbursement amount  
119 SEVT_CURR WAERS WAERS CUKY 5   0   Currency Key TCURC
120 SEVT_1 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
121 SEVT_2 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
122 SEVT_3 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
123 SEVT_4 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
124 SEVT_5 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
125 SEVT_6 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
126 SEVT_7 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
127 SEVT_8 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
128 SEVT_9 OIUVL_SEVT WERT8 CURR 15   2   Severance tax amount  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUVL_SCTXNS1 BUKRS T001 BUKRS 1 CN
2 ROIUVL_SCTXNS1 CT_NO OIUCM_CONTRACT VBELN 1 CN
3 ROIUVL_SCTXNS1 CT_TYPE_CD OIU_CM_CTTYP CT_TYPE_CD    
4 ROIUVL_SCTXNS1 DENSITY_U T006 MSEHI 1 CN
5 ROIUVL_SCTXNS1 DOI_NO OIU_DO_DI DOI_NO 1 CN
6 ROIUVL_SCTXNS1 ENERGY_U T006 MSEHI 1 CN
7 ROIUVL_SCTXNS1 GR_VAL_CURR TCURC WAERS 1 CN
8 ROIUVL_SCTXNS1 HEAT_VAL_FCT_U T006 MSEHI 1 CN
9 ROIUVL_SCTXNS1 LAND1 T005 LAND1 1 CN
10 ROIUVL_SCTXNS1 MAJPD_CD OIU_CM_PDCD MAJPD_CD    
11 ROIUVL_SCTXNS1 MATNR OIU_CM_MAT_PRCD MATNR 1 CN
12 ROIUVL_SCTXNS1 MKCT_CURR TCURC WAERS 1 CN
13 ROIUVL_SCTXNS1 MK_RMB_CURR TCURC WAERS 1 CN
14 ROIUVL_SCTXNS1 PPA_RSN_CD OIU_CM_PPARSN PPA_RSN_CD 1 CN
15 ROIUVL_SCTXNS1 PRI_GEO_LOC OIU_CM_LXPGL PRI_GEO_LOC 1 CN
16 ROIUVL_SCTXNS1 PU_NO KNA1 KUNNR 1 CN
17 ROIUVL_SCTXNS1 REJ_RSN_CD OIU_CM_REJCD REJ_RSN_CD    
18 ROIUVL_SCTXNS1 SEC_GEO_LOC OIU_CM_LXSGL SEC_GEO_LOC 1 CN
19 ROIUVL_SCTXNS1 SETT_MATNR OIU_CM_MAT_PRCD MATNR 1 CN
20 ROIUVL_SCTXNS1 SETT_VNAME OIU_DO_JV VNAME 1 CN
21 ROIUVL_SCTXNS1 SEVT_CURR TCURC WAERS 1 CN
22 ROIUVL_SCTXNS1 SVTR_CURR TCURC WAERS 1 CN
23 ROIUVL_SCTXNS1 TOT_GR_VL_U T006 MSEHI 1 CN
24 ROIUVL_SCTXNS1 UNIT_VNAME OIU_DO_JV VNAME 1 CN
25 ROIUVL_SCTXNS1 VL_TYPE_CD OIU_PR_VLTYP VL_TYPE_CD    
26 ROIUVL_SCTXNS1 VNAME OIU_DO_JV VNAME 1 CN
27 ROIUVL_SCTXNS1 WI_INT_TYPE_CD OIU_CM_PINTTY OWN_INT_TYPE_CD 1 N
28 ROIUVL_SCTXNS1 WI_OWN_NO KNA1 KUNNR 1 CN
29 ROIUVL_SCTXNS1 WLR_VL_U T006 MSEHI 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in