- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
OIUREP_AGY_LSE
Agency assigned Leases
|
#masterdata
|
Component: Royalty Reporting
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates
- ☰ Categorical (1)
- Other (26)
- 🔗 Relations (2)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| AGENCY FK | Agency for Reporting | |
| AGENCY_LEASE | Agency assigned Lease No. |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| SW_SWEET_FL | Sweet or Sour Flag(Y/N) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| RRC_LEASE_NO | RRC Oil Lease | CHAR7 | |
| RRC_WL_LSE_NO | Gas Well Number (RRC) | CHAR9 | |
| RRC_DIST_CD | RRC District ID | CHAR3 | |
| FIELD_ID | Field ID | OIU_FIELDID | |
| OPERATOR_NO | Business Associate | OIUCM_BUS_ASSOC | |
| SEQ_NO | Transaction code for Royalty reporting | OIUCM_SEQ_NO | |
| TRANSP_ORG_CD | Transport Org Cd | CHAR4 | |
| LEASE_SHR_PCNT | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | |
| WELL_IND | Well Indicator | CHAR1 | |
| REPORT_NO | Plant Org Id | CHAR4 | |
| UNIT_NO | Unit Number | CHAR6 | |
| SEC | Section Number | CHAR6 | |
| TWP | Township number | CHAR3 | |
| RGE | RGE | CHAR3 | |
| ROYALTY_DEC | Royalty Decimal | OIUY1_ROYALTY_DEC | |
| OPERATOR | Operator | LIFNR | |
| PUR_TAXID | Purchaser Tax ID | CHAR13 | |
| OPER_TAXID | Operator TAX ID | CHAR13 | |
| TRACT_NO | Tract Number | CHAR18 | |
| OIU_CRUSER | Name of Person Responsible for Creating the Object | USNAM | |
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| LEASE_SHR_PCNTO | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | |
| TXN_CD_O | Transaction code for Royalty reporting | OIUCM_SEQ_NO | |
| TYPE_IND | RRC Type | CHAR1 | |
| DRILLPERMIT_NO | Drilling permit Number | ||
| WELL_SNO | Well Serial Number | CHAR6 |
| Master Data Relations | Join Conditions |
|---|---|
| Agency for Reporting | OIUREP_AGY_LSE.AGENCY == OIUREP_ROY_AGY.AGENCY |
| Client | OIUREP_AGY_LSE.MANDT == T000.MANDT |