SAP ABAP Table ROIUREP_MMS_2014_FE_WCSALESTY (MMS-2014: WC / Sales Type fast entry structure)
Hierarchy
IS-OIL (Software Component) IS-OIL
   IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     OIU_REP (Package) Production, Tax & Royalty Reporting
Basic Data
Table Category INTTAB    Structure 
Structure ROIUREP_MMS_2014_FE_WCSALESTY   Table Relationship Diagram
Short Description MMS-2014: WC / Sales Type fast entry structure    
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 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
2 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
3 LEASE_NO OIUREP_MMS_2014_LEASE_NO   CHAR 11   0   MMS-2014 - Lease Number OIUREP_FEDINDIAN
4 FED_INDIAN_CD OIUREP_MMS_2014_FED_INDIAN_CD OIUREP_MMS_2014_FED_INDIAN_CD CHAR 1   0   Production: MMS-2014 - Federal or Indian Code  
5 AGREEMENT_NO OIUREP_MMS_2014_AGREEMENT_NO   CHAR 11   0   Production: MMS-2014 - Agreement Number OIUREP_LEASE
6 .INCLUDE       0   0   MMS-2014 - Sales Type  
7 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Key Fields  
8 MANDT MANDT MANDT CLNT 3   0   Client T000
9 LEASE_RECORD_NO OIUREP_MMS_2014_LEASE_REC_NO   NUMC 20   0   Production: MMS-2014 - Lease Record Number  
10 SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
11 MATNR MATNR MATNR CHAR 18   0   Material Number OIUREP_PRDCDXREF
12 MMS_PRODUCT_CD OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
13 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
14 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
15 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Non Key Fields  
16 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
17 TRNSP_ALLW_FAC OIUREP_MMS_2014_TRNSP_ALLW_FAC   CURR 15   8   MMS-2014 - Transportation Allowance Factor  
18 TRNSP_ALLW_CUR OIUREP_MMS_2014_TRNSP_ALLW_CUR WAERS CUKY 5   0   MMS-2014 - Transportation Allowance Currency TCURC
19 MFRING_UOM_AMT OIUREP_MMS_2014_MFRING_UOM_AMT OIUCM_CURRENCY_15_DECIMAL_2 CURR 15   2   Production: MMS-2014 - Manufacturing UOM Amount  
20 MFRING_UOM_CUR OIUREP_MMS_2014_MFRING_UOM_CUR WAERS CUKY 5   0   Production: MMS-2014 - Manufacturing UOM Currency TCURC
21 MFRER_UOM_PC OIUREP_MMS_2014_MFRER_UM_PC   DEC 9   8   MMS-2014 - Manufacturer UOM Percent  
22 ROYAL_IN_KIND_FL OIUREP_MMS_2014_ROY_IN_KIND_FL YESNO CHAR 1   0   Production: MMS-2014 - Royalty In Kind Flag  
23 SA_TYPE_ALLOC_PC OIUREP_MMS_2014_SA_TP_ALLOC_PC   DEC 9   8   Production: MMS-2014 - Sales Type Allocation Percentage  
24 TXN_OVERRIDE OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
25 .INCLUDE       0   0   Creator and date/time created  
26 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
27 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
28 .INCLUDE       0   0   Change Username & Timestamp  
29 CHANGE_USER AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
30 CHANGE_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 ROIUREP_MMS_2014_FE_WCSALESTY AGREEMENT_NO OIUREP_LEASE FED_INDIAN_CD    
2 ROIUREP_MMS_2014_FE_WCSALESTY CT_NO OIUCM_CONTRACT VBELN    
3 ROIUREP_MMS_2014_FE_WCSALESTY LEASE_NO OIUREP_FEDINDIAN LEASE_NO    
4 ROIUREP_MMS_2014_FE_WCSALESTY MANDT T000 MANDT    
5 ROIUREP_MMS_2014_FE_WCSALESTY MATNR OIUREP_PRDCDXREF MATNR    
6 ROIUREP_MMS_2014_FE_WCSALESTY MFRING_UOM_CUR TCURC WAERS    
7 ROIUREP_MMS_2014_FE_WCSALESTY SALES_TYPE_CD OIUREP_SALESTY SALES_TYPE_CD    
8 ROIUREP_MMS_2014_FE_WCSALESTY TRNSP_ALLW_CUR TCURC WAERS    
9 ROIUREP_MMS_2014_FE_WCSALESTY WC_NO OIU_PR_WC WC_NO    
10 ROIUREP_MMS_2014_FE_WCSALESTY WL_NO OIU_PR_WELL WL_NO    
History
Last changed by/on SAP  20050411 
SAP Release Created in 46C