SAP ABAP Table OIU_SB_DOIWC (DOI/WC Cross Reference)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIU_SB_DOIWC   Table Relationship Diagram
Short Description DOI/WC Cross Reference    
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 T000
2 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
3 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
4 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
5 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
6 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
7 MAJPD_CD OIU_COND_MAJPD_CD OIU_COND_MAJPD_CD CHAR 1   0   Major product code 1,2,4  
8 MATNR MATNR MATNR CHAR 18   0   Material Number OIU_CM_MAT_PRCD
9 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
10 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
11 DFLT_CD OIU_DFLT_CD OIU_DFLT_CD CHAR 1   0   Default DOI xRef Type  
12 .INCLUDE       0   0   Creator and date/time created  
13 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
14 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 OIU_SB_DOIWC BUKRS T001 BUKRS KEY 1 CN
2 OIU_SB_DOIWC DOI_NO OIU_DO_DI DOI_NO KEY 1 CN
3 OIU_SB_DOIWC MANDT T000 MANDT 1 CN
4 OIU_SB_DOIWC MATNR OIU_CM_MAT_PRCD MATNR 1 CN
5 OIU_SB_DOIWC VNAME OIU_DO_JV VNAME KEY 1 CN
6 OIU_SB_DOIWC WC_NO OIU_PR_WC WC_NO KEY 1 CN
7 OIU_SB_DOIWC WL_NO OIU_PR_WELL WL_NO KEY 1 CN
History
Last changed by/on SAP  20050301 
SAP Release Created in