SAP ABAP Table ROXPR00109 (Generierte Tabelle zu einem View)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
WBON (Package) WWS: Bonus
⤷
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | ROXPR00109 |
|
| Short Description | Generierte Tabelle zu einem View |
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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
| 3 | |
KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | * | |
| 4 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 5 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
| 6 | |
SPART | SPART | CHAR | 2 | 0 | Division | TVTA | |
| 7 | |
BOART | BOART | CHAR | 4 | 0 | Agreement type | T6B1 | |
| 8 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 9 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 10 | |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 11 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 12 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 13 | |
ABREX | CHAR20 | CHAR | 20 | 0 | External description for agreement | ||
| 14 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 15 | |
BOGEW | LIFNR | CHAR | 10 | 0 | Condition granter | LFA1 | |
| 16 | |
BOSTA | BOSTA | CHAR | 1 | 0 | Status of the agreement | ||
| 17 | |
ABDATAB | DATUM | DATS | 8 | 0 | Agreement valid-from date | ||
| 18 | |
ABDATBI | DATUM | DATS | 8 | 0 | Agreement valid-to date | ||
| 19 | |
BOTEXT | TEXT40 | CHAR | 40 | 0 | Description of agreement (e.g. sales deal, promotion) | ||
| 20 | |
WFCID1 | WFCID | CHAR | 2 | 0 | Settlement calendar for rebate arrangements | TFACD | |
| 21 | |
WFCID2 | WFCID | CHAR | 2 | 0 | Arrangement calendar for rebate arrangements | TFACD | |
| 22 | |
UMNAM | USNAM | CHAR | 12 | 0 | Person responsible for BVol. comparison f. final settlement | ||
| 23 | |
UMSDA | DATUM | DATS | 8 | 0 | Date of last business volume comparison for final settlement | ||
| 24 | |
UMNAMP | USNAM | CHAR | 12 | 0 | Pers. responsible for last BVol. comparison, partial settlm. | ||
| 25 | |
UMSDAP | DATUM | DATS | 8 | 0 | Date of last business vol. comparison for partial settlement | ||
| 26 | |
EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
| 27 | |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
| 28 | |
BUKRS_AB | BUKRS | CHAR | 4 | 0 | Company code for subsequent settlement | T001 | |
| 29 | |
WABPAR | WABPAR | CHAR | 1 | 0 | Indicator for type of settlement partner (vendor/customer) | ||
| 30 | |
BONEM | KUNNR | CHAR | 10 | 0 | Rebate recipient | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | ROXPR00109 | AKTNR | |
|
|||
| 2 | ROXPR00109 | BOART | |
|
KEY | 1 | CN |
| 3 | ROXPR00109 | BOLIF | |
|
KEY | 1 | CN |
| 4 | ROXPR00109 | BUKRS | |
|
|||
| 5 | ROXPR00109 | EKGRP | |
|
|||
| 6 | ROXPR00109 | EKORG | |
|
KEY | 1 | CN |
| 7 | ROXPR00109 | IDENT1 | |
|
|||
| 8 | ROXPR00109 | IDENT2 | |
|
|||
| 9 | ROXPR00109 | LOGSYS | |
|
KEY | C | 1 |
| 10 | ROXPR00109 | MANDT | |
|
KEY | 1 | CN |
| 11 | ROXPR00109 | SPART | |
|
KEY | 1 | CN |
| 12 | ROXPR00109 | VKORG | |
|
KEY | 1 | CN |
| 13 | ROXPR00109 | VTWEG | |
|
KEY | 1 | CN |
| 14 | ROXPR00109 | WAERS | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20100310 |
| SAP Release Created in | 700 |