SAP ABAP Table ROIURV_DOC_ALLOCH (Valuation Rev. Dist. Allocation Header - Document Concept)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
     ⤷ OIU_RVDC (Package) PRA Valuation (Document Concept)
Basic Data
Table Category INTTAB    Structure 
Structure ROIURV_DOC_ALLOCH   Table Relationship Diagram
Short Description Valuation Rev. Dist. Allocation Header - Document Concept    
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 MANDT MANDT MANDT CLNT 3   0   Client *
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 ALLOCH_NO OIU_ALLOCH_NO OIU_SYS_NO NUMC 12   0   System No for allocation header  
5 DN_NO OIU_DN_NO OIU_DN_NO CHAR 20   0   Delivery network number OIU_PR_DN
6 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
7 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
8 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
9 MATNR MATNR MATNR CHAR 18   0   Material Number OIU_CM_MAT_PRCD
10 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
11 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
12 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
13 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIU_RV_CT
14 MAJPD_CD OIU_MAJPD_CD OIU_MAJPD_CD CHAR 1   0   Major product code  
15 FREQ_CD OIU_FREQ_CD OIU_FREQ_CD CHAR 1   0   Frequency  
16 SALE_DT OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
17 SCHOOL_DIST_CD OIU_SCHOOL_DIST_CD OIU_SCHOOL_DIST_CD CHAR 3   0   School district code *
18 TAX_CLS OIU_TAX_CLS OIU_TAX_CLS CHAR 4   0   Tax Class *
19 FRML_NO OIU_FRML_NO OIU_FORMULA_NO CHAR 8   0   Formula number *
20 LVL_CD OIU_LVL_CD OIU_LVL_CD NUMC 2   0   Level Code  
21 GROUP_CD OIU_GROUP_CD OIU_GROUP_CD CHAR 1   0   Group Code  
22 PPA_RSN_CD OIU_PPA_RSN_CD OIU_PPA_RSN_CD CHAR 2   0   Prior Period Adjustment Reason Code OIU_CM_PPARSN
23 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
24 DOI_SUM_FL OIU_DOI_SUM_FL OIU_X_FLAG CHAR 1   0   Summarize RD to DOI Level Flag  
25 RM_FEE_FL OIU_RM_FEE_FL OIU_X_FLAG CHAR 1   0   CO2 Removal Fee Flag  
26 DUAL_ACCT_FL OIU_DUAL_ACCT_FL OIU_X_FLAG CHAR 1   0   Dual Accounting Flag  
27 TXN_PRCS_CD OIU_TXN_PRCS_CD OIU_TXN_PRCS_CD CHAR 2   0   Transaction Process Code  
28 CT_TYPE_CD OIU_CT_TYPE_CD OIU_CT_TYPE_CD CHAR 2   0   Contract Type OIU_CM_CTTYP
29 VL_VAL_ON_VAL_FL OIU_VL_VAL_ON_VAL_FL OIU_X_FLAG CHAR 1   0   Value on Value indicator  
30 REJ_REPRCS_FL OIU_REJ_REPRCS_FL OIU_X_FLAG CHAR 1   0   Reject Reprocess Flag  
31 FULL_SMPL_PLT_CD OIU_FULL_SMPL_PLT_CD OIU_FUL_SP_PLT_DN_NO CHAR 1   0   Full Simple Plant Network  
32 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
33 PRI_GEO_LOC OIU_PRI_GEO_LOC OIU_PRI_GEO_LOC CHAR 2   0   Primary geographical location (PRI geo. loc.) *
34 SEC_GEO_LOC OIU_SEC_GEO_LOC OIU_SEC_GEO_LOC CHAR 3   0   Secondary geographic location *
35 ONS_OFS_CD OIU_ONS_OFS_CD OIU_ONS_OFS_CD CHAR 1   0   Onshore/Offshore codes  
36 SYSTEM_SRCE_CD OIU_VL_SRCE_CD OIU_VL_SRCE_CD CHAR 2   0   Valuation Transaction Source Code  
37 PAY_CD OIU_PAY_CD OIU_PAY_CD CHAR 2   0   Pay Code  
38 VNAME_TYPE_CD OIU_VNAME_TYPE_CD OIU_PR_TYPE_CD CHAR 2   0   Venture Usage Type  
39 THEO_CND_TAX_FL OIU_THEO_CND_TAX_FL OIU_X_FLAG CHAR 1   0   Theoretical Condensate Tax Calculation Flag  
40 CA_ALLOC_METH_CD OIU_CA_ALLOC_METH_CD OIU_CA_ALLOC_METH_CD CHAR 1   0   Allocation Method Code  
41 RELATED_CT OIU_RELATED_CT VBELN CHAR 10   0   Related Contract *
42 WI_OWN_NO OIU_WI_OWN_NO KUNNR CHAR 10   0   Working Interest Owner *
43 WI_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type *
44 WI_OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
45 TR_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
46 TR_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
47 TR_DOI OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) *
48 NI_OWN_NO OIU_NI_OWN_NO LIFNR CHAR 10   0   Net Interest Owner *
49 NI_INT_TYPE_CD OIU_PART_INT_TYPE OIU_PART_INT_TYPE CHAR 2   0   Participant Interest Type *
50 NI_OWN_ISQ_NO OIU_OWN_ISQ_NO OIU_OWN_ISQ_NO CHAR 2   0   Owner Interest Sequence Number  
51 NI_FRML_NO OIU_FRML_NO OIU_FORMULA_NO CHAR 8   0   Formula number *
52 TOT_GRI_PC OIU_TOT_GRI_PC OIU_PERCENT98 DEC 9   8   Total Gross Interest %  
53 TOT_NRI_PC OIU_TOT_NRI_PC OIU_PERCENT98 DEC 9   8   Total Net Revenue Interest Percentage  
54 CT_DECM OIU_CT_DECM OIU_PERCENT98 DEC 9   8   Contract Decimal  
55 REL_CT_DECM OIU_REL_CT_DECM OIU_PERCENT98 DEC 9   8   Relative Contract Decimal  
56 SETT_DECM OIU_SETT_DECM OIU_PERCENT98 DEC 9   8   Sett. Div. Decimal Amount  
57 TOT_MKT_GRP_GRI OIU_TOT_MKT_GRP_GRI OIU_PERCENT98 DEC 9   8   Total Market Groups GRI  
58 MP_TYPE_CD OIU_MP_TYPE_CD OIU_MP_TYPE_CD CHAR 2   0   Measurement point type code *
59 ORIG_MP_NO OIU_ORIG_MP_NO OIU_MP_NO CHAR 20   0   Original measurement point number *
60 MP_TYPE_CD2 OIU_MP_TYPE_CD OIU_MP_TYPE_CD CHAR 2   0   Measurement point type code *
61 VL_TYPE_CD OIU_VT_CD OIU_VL_TYPE_CD CHAR 2   0   Volume type code *
62 VL_CLS_CD OIU_VC_CD OIU_VC_CD CHAR 1   0   Volume class code  
63 FRML_ACTL_FL OIU_ACTL_FL OIU_X_FLAG CHAR 1   0   Actual indicator  
64 FRML_ENTL_FL OIU_ENTL_FL OIU_X_FLAG CHAR 1   0   Entitled Flag  
65 FRML_SETT_FL OIU_SETT_FL OIU_X_FLAG CHAR 1   0   Settlement Flag  
66 TOT_CT_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
67 TOT_CT_VL OIU_TOT_CT_VL MENGE QUAN 13   3   Total Contract Volume  
68 TOT_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
69 TOT_GR_VL OIU_TOT_GR_VL MENGE QUAN 13   3   Total Gross Volume  
70 ACTL_GR_VL OIU_ACTL_GR_VL_AM MENGE QUAN 13   3   Actual Gross Volume Amount  
71 ACTL_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
72 ENTL_GR_VL OIU_ENTL_GR_VL_AM MENGE QUAN 13   3   Entitled Gross Volume Amount  
73 ENTL_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
74 SETT_GR_VL OIU_SETT_GR_VL_AM MENGE QUAN 13   3   Settlement Gross Volume Amount  
75 SETT_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
76 ACTL_ENERGY OIU_ACTL_ENERGY MENGE QUAN 13   3   Actual Energy  
77 ACTL_ENERGY_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
78 ENTL_ENERGY OIU_ENTL_ENERGY MENGE QUAN 13   3   Entitlement Energy  
79 ENTL_ENERGY_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
80 SETT_ENERGY OIU_SETT_ENERGY MENGE QUAN 13   3   Settlement Amount  
81 SETT_ENERGY_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
82 UNCR_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
83 UNCR_GR_VL OIU_UNCR_GR_VL MENGE QUAN 13   3   Uncorrected Gross Volume  
84 UNCR_SETT_GR_VL OIU_UNCR_SETT_GR_VL MENGE QUAN 13   3   Uncorr. Sett. Div. Gross Volume  
85 RUN_TKT_NO OIU_RUN_TKT_NO CHAR7 CHAR 7   0   Run Ticket Number  
86 TOT_TKT_DAYS OIU_TOT_TKT_DAYS NUMC05 NUMC 5   0   Total Number of Ticket Days  
87 PRD_DAYS OIU_DAYS_PROD OIU_DAYS_PROD NUMC 2   0   Days produced  
88 SALE_DT_TO OIU_SA_DT_TO DATUM DATS 8   0   Sales To-Date  
89 SALE_DT_FROM OIU_SA_DT_FROM DATUM DATS 8   0   Sales From-Date  
90 TANK_METER OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number *
91 GRV_AM OIB_BDICH OIB_DICHT FLTP 16   16   Oil/gas density at standard/base conditions  
92 DENSITY_U OIB_BDNEH MEINS UNIT 3   0   Unit for densities at standard/base conditions *
93 DNTYP OIB_DNTYP OIB_DNTYP CHAR 1   0   Density Type  
94 HEAT_VALUE_FCT_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
95 ACT_HEAT_VAL_FCT OIU_ACT_HEAT_VAL_FCT MENGE QUAN 13   3   Actual Heating Factor  
96 SET_HEAT_VAL_FCT OIU_SET_HEAT_VAL_FCT MENGE QUAN 13   3   Sett. Stmt. Heating Factor  
97 CT_HEAT_VA_FCT_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
98 CT_HEAT_VAL_FCT OIU_CT_HEAT_VAL_FCT MENGE QUAN 13   3   Contract Heating Factor  
99 VL_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
100 TRNSP_NO OIU_TRNSP_NO KUNNR CHAR 10   0   Transporter number *
101 TRNSP_REF_NO OIU_TRNSP_REF_NO OIU_TEXT25 CHAR 25   0   Transporter Reference Number  
102 TRNSP_ROU_CD OIU_TRNSP_ROU_CD OIU_TRNSP_ROU_CD CHAR 1   0   Transporter route code  
103 GASLIFT_WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number *
104 GASLIFT_WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number *
105 REJ_RSN_CD OIU_REJ_RSN_CD OIU_REJ_RSN_CD CHAR 3   0   Rejection Reason Code *
106 RA_PCT OIU_RA_PCT OIU_PERCENT73 DEC 7   3   RA Formation Percent  
107 TIK_PA_PC OIU_TIK_PA_PC OIU_PERCENT73 DEC 7   3   Processing Agreements Percent  
108 CA_WGB_CD OIU_CA_WGB_CD OIU_CA_FPF_WGB_CD CHAR 1   0   Wet Gas Balancing Code  
109 CALC_WLR_FL OIU_CALC_WETLESRES_FL OIU_X_FLAG CHAR 1   0   Calc. WetLesRes  
110 PCT_RET_LSE OIU_PCT_RET_LSE OIU_PERCENT74 DEC 7   4   Percent Returned to Lease  
111 ACTL_WLR_VL_AM OIU_ACTL_WLR_VL_AM MENGE QUAN 13   3   Act. Wet-less-Residue Vol. Amount  
112 ACTL_WLR_VL_AM_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
113 ENTL_WLR_VL_AM OIU_ENTL_WLR_VL_AM MENGE QUAN 13   3   Entl. Wet-less-Residue Vol. Amount  
114 ENTL_WLR_VL_AM_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
115 SETT_WLR_VL_AM OIU_SETT_WLR_VL_AM MENGE QUAN 13   3   Sett. Wet-less-Residue Vol. Amount  
116 SETT_WLR_VL_AM_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
117 ENT_VL_ALLOC_DEC OIU_ENT_VL_ALLOC_DEC OIU_PERCENT98 DEC 9   8   Entitled Volume Allocation Decimal  
118 ENT_ENG_ALLC_DEC OIU_ENT_ENG_ALLC_DEC OIU_PERCENT98 DEC 9   8   Entitled Energy Allocation Decimal  
119 ENT_SET_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
120 ENTL_SETT_GR_VL OIU_ENTL_SETT_GR_VL MENGE QUAN 13   3   Entitled Sett. Gross Volume  
121 ENTL_SETT_ENG_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
122 ENTL_SETT_ENERGY OIU_ENTL_SETT_ENERGY MENGE QUAN 13   3   Entitiled Sett. Energy  
123 COST_CENTER KOSTL KOSTL CHAR 10   0   Cost Center *
124 LSE_VOL OIU_LSE_VOL MENGE QUAN 13   3   Lease Volume  
125 LSE_VOL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
126 GPLT_VNAME OIU_GPLT_VNAME JV_NAME CHAR 6   0   Gas Plant Venture *
127 GPLT_DOI_DOI OIU_GPLT_DOI_NO OIU_DOI_NO CHAR 5   0   Gasplant DOI No *
128 TOT_PCT_RET_LSE OIU_PCT_RET_LSE OIU_PERCENT74 DEC 7   4   Percent Returned to Lease  
129 PCT_RET_LSE_VL OIU_ACTL_GR_VL_AM MENGE QUAN 13   3   Actual Gross Volume Amount  
130 PCT_RET_LSE_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
131 .INCLUDE       0   0   Creator and date/time created  
132 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
133 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 ROIURV_DOC_ALLOCH BUKRS T001 BUKRS KEY 1 CN
2 ROIURV_DOC_ALLOCH CT_NO OIU_RV_CT CT_NO KEY 1 CN
3 ROIURV_DOC_ALLOCH CT_TYPE_CD OIU_CM_CTTYP CT_TYPE_CD    
4 ROIURV_DOC_ALLOCH DN_NO OIU_PR_DN DN_NO KEY 1 CN
5 ROIURV_DOC_ALLOCH DOI_NO OIU_DO_DI DOI_NO KEY 1 CN
6 ROIURV_DOC_ALLOCH MATNR OIU_CM_MAT_PRCD MATNR KEY 1 CN
7 ROIURV_DOC_ALLOCH MP_NO OIU_PR_MP MP_NO KEY 1 CN
8 ROIURV_DOC_ALLOCH PPA_RSN_CD OIU_CM_PPARSN PPA_RSN_CD 1 CN
9 ROIURV_DOC_ALLOCH UNIT_VNAME OIU_DO_JV VNAME 1 CN
10 ROIURV_DOC_ALLOCH VNAME OIU_DO_JV VNAME KEY 1 CN
11 ROIURV_DOC_ALLOCH WC_NO OIU_PR_WC WC_NO KEY 1 CN
12 ROIURV_DOC_ALLOCH WL_NO OIU_PR_WELL WL_NO KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C