SAP ABAP Table OIUREP_MRT_HIST (MMS-2014 MMS Royalty Transaction Processed History), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIUREP_MRT_HIST` {MMS-2014 MMS Royalty Transaction Processed History}

Home

                title {label: "SAP ABAP table OIUREP_MRT_HIST {MMS-2014 MMS Royalty Transaction Processed History}", size: "20"}

# Entities

[OIUREP_MRT_HIST] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*DOC_ID {label: "CHAR (8)"}
*DET_LINE_NO {label: "NUMC (5)"}
+BUKRS {label: "CHAR (4)"}
+LEASE_NO {label: "CHAR (11)"}
+AGREEMENT_NO {label: "CHAR (11)"}
+SALES_TYPE_CD {label: "CHAR (4)"}
+MMS_SA_QY_U {label: "UNIT (3)"}
+GAS_MMBTU_QY_U {label: "UNIT (3)"}
+MMS_SA_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)"}
+INDIAN_TRIBE_NO {label: "CHAR (2)"}

[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)"}

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

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

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

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

# Relationships

OIUREP_MRT_HIST *--* OIUREP_LEASE {label: "OIUREP_MRT_HIST-AGREEMENT_NO = OIUREP_LEASE-FED_INDIAN_CD"}
OIUREP_MRT_HIST *--* T001 {label: "OIUREP_MRT_HIST-BUKRS = T001-BUKRS"}
OIUREP_MRT_HIST *--* T006 {label: "OIUREP_MRT_HIST-GAS_MMBTU_QY_U = T006-MSEHI"}
OIUREP_MRT_HIST *--* OIUREP_INDIAN_TR {label: "OIUREP_MRT_HIST-INDIAN_TRIBE_NO = OIUREP_INDIAN_TR-INDIAN_TRIBE_NO"}
OIUREP_MRT_HIST *--* OIUREP_FEDINDIAN {label: "OIUREP_MRT_HIST-LEASE_NO = OIUREP_FEDINDIAN-LEASE_NO"}
OIUREP_MRT_HIST *--* T000 {label: "OIUREP_MRT_HIST-MANDT = T000-MANDT"}
OIUREP_MRT_HIST *--* TCURC {label: "OIUREP_MRT_HIST-MMS_SA_CUR = TCURC-WAERS"}
OIUREP_MRT_HIST *--* T006 {label: "OIUREP_MRT_HIST-MMS_SA_QY_U = T006-MSEHI"}
OIUREP_MRT_HIST *--* TCURC {label: "OIUREP_MRT_HIST-PROC_ALW_DE_CUR = TCURC-WAERS"}
OIUREP_MRT_HIST *--* TCURC {label: "OIUREP_MRT_HIST-ROY_LS_ALLOW_CUR = TCURC-WAERS"}
OIUREP_MRT_HIST *--* TCURC {label: "OIUREP_MRT_HIST-ROY_PR_ALW_CUR = TCURC-WAERS"}
OIUREP_MRT_HIST *--* OIUREP_SALESTY {label: "OIUREP_MRT_HIST-SALES_TYPE_CD = OIUREP_SALESTY-SALES_TYPE_CD"}
OIUREP_MRT_HIST *--* TCURC {label: "OIUREP_MRT_HIST-TRNSP_ALW_DE_CUR = TCURC-WAERS"}

E-R Diagram for table OIUREP_MRT_HIST (MMS-2014 MMS Royalty Transaction Processed History)

Foreign Key tables (8)

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}
T000 {Clients}
T001 {Company Codes}
T006 {Units of Measurement}
TCURC {Currency Codes}

SAP ABAP Table OIUREP_MRT_HIST {MMS-2014 MMS Royalty Transaction Processed History}

Foreign Key tables (8)

SAP ABAP Table `OIUREP_MRT_HIST` {MMS-2014 MMS Royalty Transaction Processed History}