SAP ABAP Table OIUY6_WY_ROYHSTA (Royalty 2.0 - WY - Royalty Transaction History (Allocated)), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIUY6_WY_ROYHSTA` {Royalty 2.0 - WY - Royalty Transaction History (Allocated)}

Home

                title {label: "SAP ABAP table OIUY6_WY_ROYHSTA {Royalty 2.0 - WY - Royalty Transaction History (Allocated)}", size: "20"}

# Entities

[OIUY6_WY_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: "CHAR (35)"}
*REV_BOOK_ADJ_IND {label: "CHAR (1)"}
UNIT_VNAME {label: "CHAR (6)"}
+UOM {label: "UNIT (3)"}

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

[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

OIUY6_WY_ROYHSTA *--* OIU_CM_COMPC {label: "OIUY6_WY_ROYHSTA-BUKRS = OIU_CM_COMPC-BUKRS"}
OIUY6_WY_ROYHSTA *--* OIU_RV_CT {label: "OIUY6_WY_ROYHSTA-CT_NO = OIU_RV_CT-CT_NO"}
OIUY6_WY_ROYHSTA *--* OIU_PR_DN {label: "OIUY6_WY_ROYHSTA-DN_NO = OIU_PR_DN-DN_NO"}
OIUY6_WY_ROYHSTA *--* OIU_DO_DI {label: "OIUY6_WY_ROYHSTA-DOI_NO = OIU_DO_DI-DOI_NO"}
OIUY6_WY_ROYHSTA *--* T000 {label: "OIUY6_WY_ROYHSTA-MANDT = T000-MANDT"}
OIUY6_WY_ROYHSTA *--* OIU_PR_MP {label: "OIUY6_WY_ROYHSTA-MP_NO = OIU_PR_MP-MP_NO"}
OIUY6_WY_ROYHSTA *--* OIUX3_PDCD {label: "OIUY6_WY_ROYHSTA-PDCD = OIUX3_PDCD-PDCD"}
OIUY6_WY_ROYHSTA *--* T006 {label: "OIUY6_WY_ROYHSTA-UOM = T006-MSEHI"}
OIUY6_WY_ROYHSTA *--* OIU_PR_VLTYP {label: "OIUY6_WY_ROYHSTA-VL_TYPE_CD = OIU_PR_VLTYP-VL_TYPE_CD"}
OIUY6_WY_ROYHSTA *--* OIU_DO_JV {label: "OIUY6_WY_ROYHSTA-VNAME = OIU_DO_JV-VNAME"}
OIUY6_WY_ROYHSTA *--* OIU_PR_WC {label: "OIUY6_WY_ROYHSTA-WC_NO = OIU_PR_WC-WC_NO"}
OIUY6_WY_ROYHSTA *--* OIU_PR_WELL {label: "OIUY6_WY_ROYHSTA-WL_NO = OIU_PR_WELL-WL_NO"}

E-R Diagram for table OIUY6_WY_ROYHSTA (Royalty 2.0 - WY - Royalty Transaction History (Allocated))

Foreign Key tables (12)

OIUX3_PDCD {Tax Reporting - 3 Character Product Code}
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 OIUY6_WY_ROYHSTA {Royalty 2.0 - WY - Royalty Transaction History (Allocated)}

Foreign Key tables (12)

SAP ABAP Table `OIUY6_WY_ROYHSTA` {Royalty 2.0 - WY - Royalty Transaction History (Allocated)}