SAP ABAP Table OIUREP_RPT_ENTTY (Entities for Royalty Reporting), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIUREP_RPT_ENTTY` {Entities for Royalty Reporting}

Home

                title {label: "SAP ABAP table OIUREP_RPT_ENTTY {Entities for Royalty Reporting}", size: "20"}

# Entities

[OIUREP_RPT_ENTTY] {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)"}
*+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_LEASE {label: "CHAR (15)"}

[OIUREP_AGY_LSE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+AGENCY {label: "CHAR (3)"}
*AGENCY_LEASE {label: "CHAR (15)"}

[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_RPT_ENTTY 1--* OIUREP_ROY_AGY {label: "OIUREP_RPT_ENTTY-AGENCY = OIUREP_ROY_AGY-AGENCY"}
OIUREP_RPT_ENTTY *--* OIUREP_AGY_LSE {label: "OIUREP_RPT_ENTTY-AGENCY_LEASE = OIUREP_AGY_LSE-AGENCY_LEASE"}
OIUREP_RPT_ENTTY *--* OIU_DO_DI {label: "OIUREP_RPT_ENTTY-DOI_NO = OIU_DO_DI-DOI_NO"}
OIUREP_RPT_ENTTY *--* T000 {label: "OIUREP_RPT_ENTTY-MANDT = T000-MANDT"}
OIUREP_RPT_ENTTY *--* OIU_PR_MP {label: "OIUREP_RPT_ENTTY-MP_NO = OIU_PR_MP-MP_NO"}
OIUREP_RPT_ENTTY *--* T001 {label: "OIUREP_RPT_ENTTY-ORG_LEVEL1_NO = T001-BUKRS"}
OIUREP_RPT_ENTTY *--* OIU_DO_JV {label: "OIUREP_RPT_ENTTY-PROPERTY_NO = OIU_DO_JV-VNAME"}
OIUREP_RPT_ENTTY *--* OIU_PR_WC {label: "OIUREP_RPT_ENTTY-WC_NO = OIU_PR_WC-WC_NO"}
OIUREP_RPT_ENTTY *--* OIU_PR_WELL {label: "OIUREP_RPT_ENTTY-WL_NO = OIU_PR_WELL-WL_NO"}

E-R Diagram for table OIUREP_RPT_ENTTY (Entities for Royalty Reporting)

Foreign Key tables (9)

OIUREP_AGY_LSE {Agency assigned Leases}
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_RPT_ENTTY {Entities for Royalty Reporting}

Foreign Key tables (9)

SAP ABAP Table `OIUREP_RPT_ENTTY` {Entities for Royalty Reporting}