SAP ABAP Table ROIUREP_ROY_LEASE_LASTCURR (Reported Royalty Data by Lease (last and current)), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `ROIUREP_ROY_LEASE_LASTCURR` {Reported Royalty Data by Lease (last and current)}

Home

                title {label: "SAP ABAP table ROIUREP_ROY_LEASE_LASTCURR {Reported Royalty Data by Lease (last and current)}", size: "20"}

# Entities

[ROIUREP_ROY_LEASE_LASTCURR] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+ORG_LEVEL1_NO {label: "CHAR (4)"}
+AGENCY {label: "CHAR (3)"}
+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)"}

[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

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

E-R Diagram for table ROIUREP_ROY_LEASE_LASTCURR (Reported Royalty Data by Lease (last and current))

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 ROIUREP_ROY_LEASE_LASTCURR {Reported Royalty Data by Lease (last and current)}

Foreign Key tables (10)

SAP ABAP Table `ROIUREP_ROY_LEASE_LASTCURR` {Reported Royalty Data by Lease (last and current)}