SAP ABAP Table ROIU_RV_CPTR (Tax and Royalty Reimbursement Structure)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REV-CP (Application Component) Contracts & Pricing
⤷ OIU_RVCP (Package) PRA Contracts & Pricing (Revenue)
⤷ IS-OIL-PRA-REV-CP (Application Component) Contracts & Pricing
⤷ OIU_RVCP (Package) PRA Contracts & Pricing (Revenue)
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIU_RV_CPTR | Table Relationship Diagram |
Short Description | Tax and Royalty Reimbursement Structure |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Contract Product Tax Reimbursement Header | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | OIU_RV_CT | |
4 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
5 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
6 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
7 | MAJPD_CD | OIU_MAJPD_CD | OIU_MAJPD_CD | CHAR | 1 | 0 | Major product code | ||
8 | EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
9 | EFF_TO_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
10 | CPTR_NO | OIU_CPTR_NO | OIU_SYS_NO | NUMC | 12 | 0 | Contract Product Tax Reimbursement Number | ||
11 | EXCROY_RMB_PC | OIUCP_EXCROY_RMB_PC | OIU_PERCENT52 | DEC | 5 | 2 | Excess Royalty Reimbursement Percentage | ||
12 | EXCROYPRV_FL | OIU_EXCROYPRV_FL | OIU_X_FLAG | CHAR | 1 | 0 | Excess Royalty Provision | ||
13 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
14 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
15 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
16 | XXDBACTION | OIU_DBACTION | CHAR1 | CHAR | 1 | 0 | Database Action Flag | ||
17 | SEL_CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | * | |
18 | SEL_WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | * | |
19 | SEL_WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | * | |
20 | SEL_MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | * | |
21 | SEL_EFF_FROM_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
22 | START_DT | OIU_START_DT | DATUM | DATS | 8 | 0 | Start date | ||
23 | END_DT | OIU_END_DT | DATUM | DATS | 8 | 0 | End Date | ||
24 | MAJPD_DE | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
25 | CT_TYPE_CD | OIU_CT_TYPE_CD | OIU_CT_TYPE_CD | CHAR | 2 | 0 | Contract Type | * | |
26 | CT_TYPE_DE | OIU_CT_TYPE_DE | OIU_TEXT50 | CHAR | 50 | 0 | Contract Type Description | ||
27 | NAME | OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
28 | MP_DE | OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIU_RV_CPTR | CT_NO | OIU_RV_CT | CT_NO | KEY | 1 | CN |
2 | ROIU_RV_CPTR | MP_NO | OIU_PR_MP | MP_NO | KEY | 1 | CN |
3 | ROIU_RV_CPTR | WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
4 | ROIU_RV_CPTR | WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in |