SAP ABAP Table OIUY1_GEN_CD_VAL (Maintain Code with Effective Dated)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework
⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIUY1_GEN_CD_VAL | Table Relationship Diagram |
Short Description | Maintain Code with Effective Dated |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | AGENCY | OIUREP_ROY_AGENCY | CHAR3 | CHAR | 3 | 0 | Agency for Reporting | OIUY1_CAT_CD | |
3 | CATEGORY | OIUY1_CAT | CHAR2 | CHAR | 2 | 0 | ID to represent the Category | OIUY1_CAT_CD | |
4 | CODE | OIUY1_CD | CHAR20 | CHAR | 20 | 0 | Input code for the category | ||
5 | SEQ_NO | OIU_SEQ_NO | OIU_SEQ_NO | NUMC | 3 | 0 | Sequence number | ||
6 | EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
7 | CODE_VAL | OIUY1_CODE_VALUE | CHAR60 | CHAR | 60 | 0 | Description for code values | ||
8 | EFF_TO_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIUY1_GEN_CD_VAL | AGENCY | OIUY1_CAT_CD | AGENCY | KEY | ||
2 | OIUY1_GEN_CD_VAL | CATEGORY | OIUY1_CAT_CD | CATEGORY | KEY | ||
3 | OIUY1_GEN_CD_VAL | MANDT | T000 | MANDT | KEY |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 600 |