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

SAP ABAP Table `OIUREP_RT_HIST` {MMS-2014 - Royalty Transaction (Pending) History}

Home

                title {label: "SAP ABAP table OIUREP_RT_HIST {MMS-2014 - Royalty Transaction (Pending) History}", size: "20"}

# Entities

[OIUREP_RT_HIST] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*SALES_YEAR {label: "NUMC (4)"}
*SALES_MONTH {label: "NUMC (2)"}
*RTP_LINE_NUM {label: "NUMC (10)"}
+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)"}
PU_NO {label: "CHAR (10)"}
+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)"}

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

E-R Diagram for table OIUREP_RT_HIST (MMS-2014 - Royalty Transaction (Pending) History)

Foreign Key tables (16)

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

SAP ABAP Table OIUREP_RT_HIST {MMS-2014 - Royalty Transaction (Pending) History}

Foreign Key tables (16)

SAP ABAP Table `OIUREP_RT_HIST` {MMS-2014 - Royalty Transaction (Pending) History}