SAP ABAP Table OIUY3_TX_ROYHSTA (Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIUY3_TX_ROYHSTA` {Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)}

Home

                title {label: "SAP ABAP table OIUY3_TX_ROYHSTA {Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)}", size: "20"}

# Entities

[OIUY3_TX_ROYHSTA] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*SALES_DT {label: "DATS (8)"}
*+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)"}
*OWNER_IDENTIFIER {label: "CHAR (22)"}
*LEASE_IDENTIFIER {label: "NUMC (6)"}
*REV_BOOK_ADJ_IND {label: "CHAR (1)"}
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

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

E-R Diagram for table OIUY3_TX_ROYHSTA (Royalty 2.0 - TX GLO - Royalty Trans History (Allocated))

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 OIUY3_TX_ROYHSTA {Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)}

Foreign Key tables (15)

SAP ABAP Table `OIUY3_TX_ROYHSTA` {Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)}