SAP ABAP Table ROIUY3_TX_ROYHST_TC_0300 (Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `ROIUY3_TX_ROYHST_TC_0300` {Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct}

Home

                title {label: "SAP ABAP table ROIUY3_TX_ROYHST_TC_0300 {Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct}", size: "20"}

# Entities

[ROIUY3_TX_ROYHST_TC_0300] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+BUKRS {label: "CHAR (4)"}
+PDCD {label: "CHAR (3)"}
+WL_NO {label: "CHAR (15)"}
+WC_NO {label: "CHAR (5)"}
+MP_NO {label: "CHAR (20)"}
+VNAME {label: "CHAR (6)"}
+DOI_NO {label: "CHAR (5)"}
+DN_NO {label: "CHAR (20)"}
+CT_NO {label: "CHAR (10)"}
+VL_TYPE_CD {label: "CHAR (2)"}
UNIT_VNAME {label: "CHAR (6)"}
+UOM {label: "UNIT (3)"}
+GLO_LEASE {label: "NUMC (6)"}
+GLO_UNIT_NO {label: "CHAR (4)"}
+OPERATOR_NO {label: "CHAR (6)"}

[OIUH_CM_BA] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*BA_BA_NO {label: "CHAR (6)"}
*BA_SEQ_NO {label: "CHAR (2)"}

[OIUX3_PDCD] {bgcolor: "#d0e0d0"}
*PDCD {label: "CHAR (3)"}

[OIUY3_TX_LEASE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GLO_LEASE {label: "NUMC (6)"}

[OIUY3_TX_UNIT] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GLO_UNIT_NO {label: "CHAR (4)"}
*EFF_FROM_DT {label: "DATS (8)"}
*+GLO_LEASE {label: "NUMC (6)"}

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

[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_DN] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*DN_NO {label: "CHAR (20)"}

[OIU_PR_MP] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*MP_NO {label: "CHAR (20)"}

[OIU_PR_VLTYP] {bgcolor: "#d0e0d0"}
*VL_TYPE_CD {label: "CHAR (2)"}

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

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

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

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

# Relationships

ROIUY3_TX_ROYHST_TC_0300 *--* OIU_CM_COMPC {label: "ROIUY3_TX_ROYHST_TC_0300-BUKRS = OIU_CM_COMPC-BUKRS"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_RV_CT {label: "ROIUY3_TX_ROYHST_TC_0300-CT_NO = OIU_RV_CT-CT_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_PR_DN {label: "ROIUY3_TX_ROYHST_TC_0300-DN_NO = OIU_PR_DN-DN_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_DO_DI {label: "ROIUY3_TX_ROYHST_TC_0300-DOI_NO = OIU_DO_DI-DOI_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIUY3_TX_LEASE {label: "ROIUY3_TX_ROYHST_TC_0300-GLO_LEASE = OIUY3_TX_LEASE-GLO_LEASE"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIUY3_TX_UNIT {label: "ROIUY3_TX_ROYHST_TC_0300-GLO_UNIT_NO = OIUY3_TX_UNIT-GLO_UNIT_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* T000 {label: "ROIUY3_TX_ROYHST_TC_0300-MANDT = T000-MANDT"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_PR_MP {label: "ROIUY3_TX_ROYHST_TC_0300-MP_NO = OIU_PR_MP-MP_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIUH_CM_BA {label: "ROIUY3_TX_ROYHST_TC_0300-OPERATOR_NO = OIUH_CM_BA-BA_BA_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIUX3_PDCD {label: "ROIUY3_TX_ROYHST_TC_0300-PDCD = OIUX3_PDCD-PDCD"}
ROIUY3_TX_ROYHST_TC_0300 *--* T006 {label: "ROIUY3_TX_ROYHST_TC_0300-UOM = T006-MSEHI"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_PR_VLTYP {label: "ROIUY3_TX_ROYHST_TC_0300-VL_TYPE_CD = OIU_PR_VLTYP-VL_TYPE_CD"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_DO_JV {label: "ROIUY3_TX_ROYHST_TC_0300-VNAME = OIU_DO_JV-VNAME"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_PR_WC {label: "ROIUY3_TX_ROYHST_TC_0300-WC_NO = OIU_PR_WC-WC_NO"}
ROIUY3_TX_ROYHST_TC_0300 *--* OIU_PR_WELL {label: "ROIUY3_TX_ROYHST_TC_0300-WL_NO = OIU_PR_WELL-WL_NO"}

E-R Diagram for table ROIUY3_TX_ROYHST_TC_0300 (Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct)

Foreign Key tables (15)

OIUH_CM_BA {Oil and Gas appl table}
OIUX3_PDCD {Tax Reporting - 3 Character Product Code}
OIUY3_TX_LEASE {Royalty 2.0 - TX GLO - Lease Master}
OIUY3_TX_UNIT {Royalty 2.0 - TX GLO - Unit Master}
OIU_CM_COMPC {PRA Company Codes}
OIU_DO_DI {Base Venture/DOI Relationship}
OIU_DO_JV {PRA venture extension}
OIU_PR_DN {Delivery Network}
OIU_PR_MP {PRA Measurement Points}
OIU_PR_VLTYP {Volume Type Table - Tblcm010}
OIU_PR_WC {PRA: Well Completion}
OIU_PR_WELL {PRA: Well}
OIU_RV_CT {Generated Table for View}
T000 {Clients}
T006 {Units of Measurement}

SAP ABAP Table ROIUY3_TX_ROYHST_TC_0300 {Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct}

Foreign Key tables (15)

SAP ABAP Table `ROIUY3_TX_ROYHST_TC_0300` {Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct}