SAP ABAP Table OIUREP_ROY_DATA (Reported Royalty and Volume Data by Reporting Entities), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIUREP_ROY_DATA` {Reported Royalty and Volume Data by Reporting Entities}

Home

                title {label: "SAP ABAP table OIUREP_ROY_DATA {Reported Royalty and Volume Data by Reporting Entities}", size: "20"}

# Entities

[OIUREP_ROY_DATA] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*YEAR_MONTH {label: "NUMC (6)"}
*+ORG_LEVEL1_NO {label: "CHAR (4)"}
*+AGENCY {label: "CHAR (3)"}
*OIL_GAS_IND {label: "CHAR (1)"}
*YEAR_MONTH_AMND {label: "NUMC (6)"}
*+PROPERTY_NO {label: "CHAR (6)"}
*+DOI_NO {label: "CHAR (5)"}
*+WL_NO {label: "CHAR (15)"}
*+WC_NO {label: "CHAR (5)"}
*+MP_NO {label: "CHAR (20)"}
*+AGENCY_PROD_CODE {label: "CHAR (3)"}
*+AGENCY_VOL_TYPE {label: "CHAR (2)"}
*GRAVITY_QTY {label: "NUMC (4)"}

[OIUREP_AGY_PDCD] {bgcolor: "#d0e0d0"}
*+AGENCY {label: "CHAR (3)"}
*AGENCY_PROD_CODE {label: "CHAR (3)"}

[OIUREP_AGY_VLTP] {bgcolor: "#d0e0d0"}
*+AGENCY {label: "CHAR (3)"}
*AGENCY_VOL_TYPE {label: "CHAR (2)"}

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

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

# Relationships

OIUREP_ROY_DATA 1--* OIUREP_ROY_AGY {label: "OIUREP_ROY_DATA-AGENCY = OIUREP_ROY_AGY-AGENCY"}
OIUREP_ROY_DATA *--* OIUREP_AGY_PDCD {label: "OIUREP_ROY_DATA-AGENCY_PROD_CODE = OIUREP_AGY_PDCD-AGENCY_PROD_CODE"}
OIUREP_ROY_DATA 1--* OIUREP_AGY_VLTP {label: "OIUREP_ROY_DATA-AGENCY_VOL_TYPE = OIUREP_AGY_VLTP-AGENCY_VOL_TYPE"}
OIUREP_ROY_DATA *--* OIU_DO_DI {label: "OIUREP_ROY_DATA-DOI_NO = OIU_DO_DI-DOI_NO"}
OIUREP_ROY_DATA *--* T000 {label: "OIUREP_ROY_DATA-MANDT = T000-MANDT"}
OIUREP_ROY_DATA *--* OIU_PR_MP {label: "OIUREP_ROY_DATA-MP_NO = OIU_PR_MP-MP_NO"}
OIUREP_ROY_DATA *--* T001 {label: "OIUREP_ROY_DATA-ORG_LEVEL1_NO = T001-BUKRS"}
OIUREP_ROY_DATA *--* OIU_DO_JV {label: "OIUREP_ROY_DATA-PROPERTY_NO = OIU_DO_JV-VNAME"}
OIUREP_ROY_DATA *--* OIU_PR_WC {label: "OIUREP_ROY_DATA-WC_NO = OIU_PR_WC-WC_NO"}
OIUREP_ROY_DATA *--* OIU_PR_WELL {label: "OIUREP_ROY_DATA-WL_NO = OIU_PR_WELL-WL_NO"}

E-R Diagram for table OIUREP_ROY_DATA (Reported Royalty and Volume Data by Reporting Entities)

Foreign Key tables (10)

OIUREP_AGY_PDCD {Agency defined Product Code}
OIUREP_AGY_VLTP {Agency defined Volume Types}
OIUREP_ROY_AGY {Reporting Agencies for Tax and Royalty}
OIU_DO_DI {Base Venture/DOI Relationship}
OIU_DO_JV {PRA venture extension}
OIU_PR_MP {PRA Measurement Points}
OIU_PR_WC {PRA: Well Completion}
OIU_PR_WELL {PRA: Well}
T000 {Clients}
T001 {Company Codes}

SAP ABAP Table OIUREP_ROY_DATA {Reported Royalty and Volume Data by Reporting Entities}

Foreign Key tables (10)

SAP ABAP Table `OIUREP_ROY_DATA` {Reported Royalty and Volume Data by Reporting Entities}