SAP ABAP Table ROIUREP_MMS_2014_RT_NON (Production: MMS-2014 - Royalty Transactions Non-Key Fields), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `ROIUREP_MMS_2014_RT_NON` {Production: MMS-2014 - Royalty Transactions Non-Key Fields}

Home

                title {label: "SAP ABAP table ROIUREP_MMS_2014_RT_NON {Production: MMS-2014 - Royalty Transactions Non-Key Fields}", size: "20"}

# Entities

[ROIUREP_MMS_2014_RT_NON] {bgcolor: "tomato"}
+INDIAN_TRIBE_NO {label: "CHAR (2)"}
+LEASE_NO {label: "CHAR (11)"}
+AGREEMENT_NO {label: "CHAR (11)"}
+SALES_TYPE_CD {label: "CHAR (4)"}
+WL_NO {label: "CHAR (15)"}
+WC_NO {label: "CHAR (5)"}
+VNAME {label: "CHAR (6)"}
+DOI_NO {label: "CHAR (5)"}
+MATNR {label: "CHAR (18)"}
+OWN_NO {label: "CHAR (10)"}
+CT_NO {label: "CHAR (10)"}
+SALES_QY_U {label: "UNIT (3)"}
+SALES_GV_QY_U {label: "UNIT (3)"}
+SALES_BTU_QY_U {label: "UNIT (3)"}
+SALES_PS_BASE_U {label: "UNIT (3)"}
+SALES_CUR {label: "CUKY (5)"}
+ROY_PR_ALW_CUR {label: "CUKY (5)"}
+TRNSP_ALW_DE_CUR {label: "CUKY (5)"}
+PROC_ALW_DE_CUR {label: "CUKY (5)"}
+ROY_LS_ALLOW_CUR {label: "CUKY (5)"}
+ROY_QY_U {label: "UNIT (3)"}
+DED_REMB_CUR {label: "CUKY (5)"}
+TAX_CUR {label: "CUKY (5)"}
+TAX_REMB_CUR {label: "CUKY (5)"}
+MMS_ROY_QY_U {label: "UNIT (3)"}
+MMS_PS_BASE_QY_U {label: "UNIT (3)"}
+MMS_ROY_CUR {label: "CUKY (5)"}
+MMS_SA_QY_U {label: "UNIT (3)"}
+MMS_SA_CUR {label: "CUKY (5)"}
+SUSPEND_RSN_CD {label: "CHAR (3)"}
+ADJ_SA_QY_U {label: "UNIT (3)"}
+ADJ_ROY_QY_U {label: "UNIT (3)"}
+ADJ_BTU_QY_U {label: "UNIT (3)"}
+GAS_MMBTU_QY_U {label: "UNIT (3)"}

[LFA1] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LIFNR {label: "CHAR (10)"}

[OIUCM_CONTRACT] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*VBELN {label: "CHAR (10)"}

[OIUREP_FEDINDIAN] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LEASE_NO {label: "CHAR (11)"}

[OIUREP_INDIAN_TR] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*INDIAN_TRIBE_NO {label: "CHAR (2)"}

[OIUREP_LEASE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PAYORXREF_REC_NO {label: "NUMC (20)"}
*+LEASE_NO {label: "CHAR (11)"}
*FED_INDIAN_CD {label: "CHAR (1)"}
*AGREEMENT_NO {label: "CHAR (11)"}
*EFF_FROM_DT {label: "DATS (8)"}

[OIUREP_SALESTY] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SALES_TYPE_CD {label: "CHAR (4)"}

[OIU_CM_MAT_PRCD] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+MATNR {label: "CHAR (18)"}

[OIU_CM_SUSP] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SUSP_CD {label: "CHAR (3)"}

[OIU_DO_DI] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*+VNAME {label: "CHAR (6)"}
*DOI_NO {label: "CHAR (5)"}

[OIU_DO_JV] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*VNAME {label: "CHAR (6)"}

[OIU_PR_WC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+WL_NO {label: "CHAR (15)"}
*WC_NO {label: "CHAR (5)"}

[OIU_PR_WELL] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WL_NO {label: "CHAR (15)"}

[T006] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MSEHI {label: "UNIT (3)"}

[TCURC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WAERS {label: "CUKY (5)"}

# Relationships

ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-ADJ_BTU_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-ADJ_ROY_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-ADJ_SA_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* OIUREP_LEASE {label: "ROIUREP_MMS_2014_RT_NON-AGREEMENT_NO = OIUREP_LEASE-FED_INDIAN_CD"}
ROIUREP_MMS_2014_RT_NON *--* OIUCM_CONTRACT {label: "ROIUREP_MMS_2014_RT_NON-CT_NO = OIUCM_CONTRACT-VBELN"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-DED_REMB_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* OIU_DO_DI {label: "ROIUREP_MMS_2014_RT_NON-DOI_NO = OIU_DO_DI-DOI_NO"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-GAS_MMBTU_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* OIUREP_INDIAN_TR {label: "ROIUREP_MMS_2014_RT_NON-INDIAN_TRIBE_NO = OIUREP_INDIAN_TR-INDIAN_TRIBE_NO"}
ROIUREP_MMS_2014_RT_NON *--* OIUREP_FEDINDIAN {label: "ROIUREP_MMS_2014_RT_NON-LEASE_NO = OIUREP_FEDINDIAN-LEASE_NO"}
ROIUREP_MMS_2014_RT_NON *--* OIU_CM_MAT_PRCD {label: "ROIUREP_MMS_2014_RT_NON-MATNR = OIU_CM_MAT_PRCD-MATNR"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-MMS_PS_BASE_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-MMS_ROY_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-MMS_ROY_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-MMS_SA_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-MMS_SA_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* LFA1 {label: "ROIUREP_MMS_2014_RT_NON-OWN_NO = LFA1-LIFNR"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-PROC_ALW_DE_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-ROY_LS_ALLOW_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-ROY_PR_ALW_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-ROY_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-SALES_BTU_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-SALES_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-SALES_GV_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-SALES_PS_BASE_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* T006 {label: "ROIUREP_MMS_2014_RT_NON-SALES_QY_U = T006-MSEHI"}
ROIUREP_MMS_2014_RT_NON *--* OIUREP_SALESTY {label: "ROIUREP_MMS_2014_RT_NON-SALES_TYPE_CD = OIUREP_SALESTY-SALES_TYPE_CD"}
ROIUREP_MMS_2014_RT_NON *--* OIU_CM_SUSP {label: "ROIUREP_MMS_2014_RT_NON-SUSPEND_RSN_CD = OIU_CM_SUSP-SUSP_CD"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-TAX_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-TAX_REMB_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* TCURC {label: "ROIUREP_MMS_2014_RT_NON-TRNSP_ALW_DE_CUR = TCURC-WAERS"}
ROIUREP_MMS_2014_RT_NON *--* OIU_DO_JV {label: "ROIUREP_MMS_2014_RT_NON-VNAME = OIU_DO_JV-VNAME"}
ROIUREP_MMS_2014_RT_NON *--* OIU_PR_WC {label: "ROIUREP_MMS_2014_RT_NON-WC_NO = OIU_PR_WC-WC_NO"}
ROIUREP_MMS_2014_RT_NON *--* OIU_PR_WELL {label: "ROIUREP_MMS_2014_RT_NON-WL_NO = OIU_PR_WELL-WL_NO"}

E-R Diagram for table ROIUREP_MMS_2014_RT_NON (Production: MMS-2014 - Royalty Transactions Non-Key Fields)

Foreign Key tables (14)

LFA1 {Vendor Master (General Section)}
OIUCM_CONTRACT {PRA Contracts}
OIUREP_FEDINDIAN {MMS-2014 - Federal or Indian Leases}
OIUREP_INDIAN_TR {MMS-2014 - Indian Tribes}
OIUREP_LEASE {MMS-2014 - Lease}
OIUREP_SALESTY {MMS-2014: Sales Type Control Table}
OIU_CM_MAT_PRCD {Material and Product Code (processing) Xref}
OIU_CM_SUSP {Suspense Reason Codes (TBLRV007)}
OIU_DO_DI {Base Venture/DOI Relationship}
OIU_DO_JV {PRA venture extension}
OIU_PR_WC {PRA: Well Completion}
OIU_PR_WELL {PRA: Well}
T006 {Units of Measurement}
TCURC {Currency Codes}

SAP ABAP Table ROIUREP_MMS_2014_RT_NON {Production: MMS-2014 - Royalty Transactions Non-Key Fields}

Foreign Key tables (14)

SAP ABAP Table `ROIUREP_MMS_2014_RT_NON` {Production: MMS-2014 - Royalty Transactions Non-Key Fields}