SAP ABAP Table ROIUREP_MMS_2014_FE_PRSALESTY (MMS-2014: Property / 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_PRSALESTY   Table Relationship Diagram
Short Description MMS-2014: Property / 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 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
2 PROPERTY OIUREP_MMS_2014_PROPERTY JV_NAME CHAR 6   0   MMS-2014 - Venture OIU_DO_JV
3 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
4 LEASE_NO OIUREP_MMS_2014_LEASE_NO   CHAR 11   0   MMS-2014 - Lease Number OIUREP_FEDINDIAN
5 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  
6 AGREEMENT_NO OIUREP_MMS_2014_AGREEMENT_NO   CHAR 11   0   Production: MMS-2014 - Agreement Number OIUREP_LEASE
7 .INCLUDE       0   0   MMS-2014 - Sales Type  
8 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Key Fields  
9 MANDT MANDT MANDT CLNT 3   0   Client T000
10 LEASE_RECORD_NO OIUREP_MMS_2014_LEASE_REC_NO   NUMC 20   0   Production: MMS-2014 - Lease Record Number  
11 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
12 MATNR MATNR MATNR CHAR 18   0   Material Number OIUREP_PRDCDXREF
13 MMS_PRODUCT_CD OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
14 CT_NO OIU_CT_NO OIUCM_CONTRACT_NUMBER CHAR 10   0   Contract Number OIUCM_CONTRACT
15 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
16 .INCLUDE       0   0   Production: MMS-2014 - Sales Type Non Key Fields  
17 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
18 TRNSP_ALLW_FAC OIUREP_MMS_2014_TRNSP_ALLW_FAC   CURR 15   8   MMS-2014 - Transportation Allowance Factor  
19 TRNSP_ALLW_CUR OIUREP_MMS_2014_TRNSP_ALLW_CUR WAERS CUKY 5   0   MMS-2014 - Transportation Allowance Currency TCURC
20 MFRING_UOM_AMT OIUREP_MMS_2014_MFRING_UOM_AMT OIUCM_CURRENCY_15_DECIMAL_2 CURR 15   2   Production: MMS-2014 - Manufacturing UOM Amount  
21 MFRING_UOM_CUR OIUREP_MMS_2014_MFRING_UOM_CUR WAERS CUKY 5   0   Production: MMS-2014 - Manufacturing UOM Currency TCURC
22 MFRER_UOM_PC OIUREP_MMS_2014_MFRER_UM_PC   DEC 9   8   MMS-2014 - Manufacturer UOM Percent  
23 ROYAL_IN_KIND_FL OIUREP_MMS_2014_ROY_IN_KIND_FL YESNO CHAR 1   0   Production: MMS-2014 - Royalty In Kind Flag  
24 SA_TYPE_ALLOC_PC OIUREP_MMS_2014_SA_TP_ALLOC_PC   DEC 9   8   Production: MMS-2014 - Sales Type Allocation Percentage  
25 TXN_OVERRIDE OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
26 .INCLUDE       0   0   Creator and date/time created  
27 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
28 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
29 .INCLUDE       0   0   Change Username & Timestamp  
30 CHANGE_USER AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
31 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_PRSALESTY AGREEMENT_NO OIUREP_LEASE FED_INDIAN_CD    
2 ROIUREP_MMS_2014_FE_PRSALESTY CT_NO OIUCM_CONTRACT VBELN    
3 ROIUREP_MMS_2014_FE_PRSALESTY DOI_NO OIU_DO_DI DOI_NO    
4 ROIUREP_MMS_2014_FE_PRSALESTY LEASE_NO OIUREP_FEDINDIAN LEASE_NO    
5 ROIUREP_MMS_2014_FE_PRSALESTY MANDT T000 MANDT    
6 ROIUREP_MMS_2014_FE_PRSALESTY MATNR OIUREP_PRDCDXREF MATNR    
7 ROIUREP_MMS_2014_FE_PRSALESTY MFRING_UOM_CUR TCURC WAERS    
8 ROIUREP_MMS_2014_FE_PRSALESTY PROPERTY OIU_DO_JV VNAME    
9 ROIUREP_MMS_2014_FE_PRSALESTY SALES_TYPE_CD OIUREP_SALESTY SALES_TYPE_CD    
10 ROIUREP_MMS_2014_FE_PRSALESTY TRNSP_ALLW_CUR TCURC WAERS    
History
Last changed by/on SAP  20050411 
SAP Release Created in 46C