SAP ABAP Table BEAS_AGREEMENT_DTL (Agreement Detail Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-RB (Application Component) Rebate Processing
⤷ BEA_CLASS_R1 (Package) BE Application - Objects in Rebate Class
⤷ CRM-RB (Application Component) Rebate Processing
⤷ BEA_CLASS_R1 (Package) BE Application - Objects in Rebate Class
Basic Data
Table Category | INTTAB | Structure |
Structure | BEAS_AGREEMENT_DTL | Table Relationship Diagram |
Short Description | Agreement Detail Data |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | AGR_ITEM_GUID | BEA_RDLI_GUID | SYSUUID | RAW | 16 | 0 | GUID of an Item in Rebate Due List | ||
3 | EXT_AGR_GUID | BEA_RDLH_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Header of Rebate Due List | ||
4 | RECIPIENT | BEA_REBATE_RECIPIENT | BU_PARTNER | CHAR | 10 | 0 | Rebate Recipient | * | |
5 | VARNUMH | BEA_VARNUMH | SYSUUID | RAW | 16 | 0 | ID of a Condition Record | ||
6 | PRODUCT | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
7 | UPD_TYPE | UPDATE_TYPE | UPDATE_TYPE | CHAR | 1 | 0 | Type of Change | ||
8 | INDX_RDLH | BEA_TABLE_INDEX_R1 | TABIX | INT4 | 10 | 0 | Internal Table Index | ||
9 | INDX_RDLP | BEA_TABLE_INDEX_R1 | TABIX | INT4 | 10 | 0 | Internal Table Index | ||
10 | INDX_CONDITIONS | BEA_TABLE_INDEX_R1 | TABIX | INT4 | 10 | 0 | Internal Table Index | ||
11 | ERROR_ID | BEA_RDLI_ERROR_ID | BEA_RDLI_ERROR_ID | CHAR | 1 | 0 | Processing Indicator: Rebate Due List Item | ||
12 | AGR_CURRENCY_WRK | BEA_AGR_CURRENCY_R1 | WAERS | CUKY | 5 | 0 | Agreement Currency | * | |
13 | BASE_CURRENC_WRK | BEA_BASE_CURRENCY | WAERS | CUKY | 5 | 0 | Reference Currency of Billing Unit (Local Currency) | * | |
14 | BASE_UNIT_WRK | BEA_BASE_UNIT | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
15 | CALC_TYPE_WRK | BEA_CALCULATION_TYPE | BEA_CALCULATION_TYPE_R1 | CHAR | 3 | 0 | Calculation Type | ||
16 | CU_ACCR_K_WRK | BEA_CU_ACCR_VALUE_K | WERTV9 | CURR | 17 | 2 | Cumulated Accrual Value in Cumulation Currency | ||
17 | CU_ACCR_WRK | BEA_CU_ACCR_VALUE | WERTV9 | CURR | 17 | 2 | Cumulated Accrual Value in Base Currency | ||
18 | CU_BASE_K_WRK | BEA_CU_BASE_VALUE_K | BEA_CU_BASE_R1 | DEC | 20 | 5 | Cumulated Base Value in Cumulation Currency | ||
19 | CU_BASE_WRK | BEA_CU_BASE_VALUE | BEA_CU_BASE_R1 | DEC | 20 | 5 | Cumulated Base Value | ||
20 | CU_CURRENCY_WRK | BEA_CU_CURRENCY | WAERS | CUKY | 5 | 0 | Currency for Cumulation | * | |
21 | CU_EXPAY_VAL_WRK | BEA_CU_EXPAY_VALUE | WERTV9 | CURR | 17 | 2 | Cumulated Externally Paid Value in Cumulation Currency | ||
22 | CU_PAYD_K_WRK | BEA_CU_PAYD_VALUE_K | WERTV9 | CURR | 17 | 2 | Cumulated Paid Value in Cumulation Currency | ||
23 | CU_PAYD_WRK | BEA_CU_PAYD_VALUE | WERTV9 | CURR | 17 | 2 | Cumulated Paid Value in Reference Currency | ||
24 | CU_RACC_K_WRK | BEA_CU_RACC_VALUE_K | WERTV9 | CURR | 17 | 2 | Resolved Accrual Value in Cumulation Currency | ||
25 | CU_RACC_WRK | BEA_CU_RACC_VALUE | WERTV9 | CURR | 17 | 2 | Resolved Accrual Value in Base Currency | ||
26 | CU_SCALE_BAS_WRK | BEA_CU_SCALE_BASE | BEA_CU_SCALE_BASE_R1 | DEC | 18 | 5 | Cumulated Scale Base | ||
27 | MAN_PAY_VALUE_K | BEA_MPAY_VALUE_K | WERTV9 | CURR | 17 | 2 | Manual Payment Value in Agreement Currency | ||
28 | MA_BAS_VALUE_WRK | BEA_MA_BASE_VALUE | BEA_CU_BASE_R1 | DEC | 20 | 5 | Manual Additional Base Value (Delta) | ||
29 | MA_SCALE_BAS_WRK | BEA_MA_BASE_VALUE | BEA_CU_BASE_R1 | DEC | 20 | 5 | Manual Additional Base Value (Delta) | ||
30 | OKSTATUS | BEA_RDLI_STATUS_R1 | BEA_RDLI_STATUS_R1 | CHAR | 1 | 0 | Status of Settlement Record in Settlement | ||
31 | PAY_VALUE | BEA_PAY_VALUE | WERTV9 | CURR | 17 | 2 | Value to Pay in Reference Currency | ||
32 | PAY_VALUE_K | BEA_PAY_VALUE_K | WERTV9 | CURR | 17 | 2 | Value to Pay in Agreement Currency | ||
33 | REV_ACC_VALUE | BEA_REV_ACC_VALUE | WERTV9 | CURR | 17 | 2 | Accrual Value to Be Posted in Base Currency | ||
34 | REV_ACC_VALUE_K | BEA_REV_ACC_VALUE_K | WERTV9 | CURR | 17 | 2 | Accrual Value to Be Posted in Agreement Currency | ||
35 | SCALE_BASE_WRK | BEA_TOTAL_SCALE_BASE | BEA_CU_SCALE_BASE_R1 | DEC | 18 | 5 | Total Scale Base for Determining Scale Level | ||
36 | SCALE_CURR_WRK | BEA_SCALE_CURR | WAERS | CUKY | 5 | 0 | Scale Currency Key | * | |
37 | SCALE_TYPE_WRK | BEA_SCALE_BASE_TYPE | BEA_SCALE_BASE_TYPE_R1 | CHAR | 3 | 0 | Scale Base Type | ||
38 | SCALE_UOM_WRK | BEA_SCALE_UOM | MEINS | UNIT | 3 | 0 | Scale Unit of Measure | * | |
39 | SETTLE_DATE | BEA_TIMESTAMP_R1 | BEA_TIMESTAMP_R1 | CHAR | 14 | 0 | Time Stamp Consisting of Date and Time | ||
40 | BUFFER_REC | BEA_BOOLEAN | BEA_BOOLEAN | CHAR | 1 | 0 | Boolean Variable | ||
41 | RECIPIENT_GUID | BEA_REBATE_RECIPIENT_GUID_R1 | SYSUUID | RAW | 16 | 0 | Rebate Recipient GUID | ||
42 | CLOSED_VALUE_WRK | BEA_CU_CLOSED_CVAL_WRK | WERTV9 | CURR | 17 | 2 | Closed Consumable Value in Agreement Currency | ||
43 | CONSUMED_VALUE | BEA_CU_CNSMD_VALUE | WERTV9 | CURR | 17 | 2 | Consumed Value in Accumulation Currency | ||
44 | CU_MADD_VAL_WRK | BEA_MBAL_VALUE_K | WERTV9 | CURR | 17 | 2 | Manual Adjustment of Available Rebate Amount | ||
45 | OPEN_ACC_VALUE_K | BEA_OPEN_ACC_VALUE_K | WERTV9 | CURR | 17 | 2 | Open Accrual Value in Cumulation Currency | ||
46 | OPEN_CNSM_VALUE | BEA_OPEN_CONSM_VALUE | WERTV9 | CURR | 17 | 2 | Open Consumable Value in Agreement Currency | ||
47 | OPEN_CNSM_VAL_FT | BEA_OPEN_CONSM_VALUE_FUT | WERTV9 | CURR | 17 | 2 | Open Consumable Value in Agreement Currency - Future | ||
48 | OPEN_CNSM_VAL_NW | BEA_OPEN_CONSM_VALUE_NOW | WERTV9 | CURR | 17 | 2 | Open Consumable Value in Agreement Currency (At This Date) | ||
49 | EARNED_VAL_WRK | BEA_CU_EARNED_CVAL_WRK | WERTV9 | CURR | 17 | 2 | Earned Consumable Value in Agreement Currency | ||
50 | KSCHL_D | PRCT_COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Pricing - Condition Type | * | |
51 | CU_FOC_QTY_WRK | BEA_CU_FOC_QNTY | MENGV15_3 | QUAN | 15 | 3 | Cumulated Quantity for Free-Goods Rebate | ||
52 | FOC_ADD_QNTY | REB_FOC_ADD_QNTY | MENGV15_3 | QUAN | 15 | 3 | Quantity of Free Product | ||
53 | FOC_ADD_QNTY_UOM | REB_FOC_ADD_QNTY_UNIT | MEINS | UNIT | 3 | 0 | Unit for Free Product | * | |
54 | FOC_QTY_UNIT_WRK | BEA_FOC_QNTY_UNIT | MEINS | UNIT | 3 | 0 | Unit for Cumulated Quantity of Free-Goods Rebate | * | |
55 | FOC_QTY_WRK | BEA_FOC_QNTY | MENGV15_3 | QUAN | 15 | 3 | Quantity for Settlement - Free-Goods Rebate | ||
56 | FOC_TOTAL_QTY | BEA_FOC_QNTY | MENGV15_3 | QUAN | 15 | 3 | Quantity for Settlement - Free-Goods Rebate |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BEAS_AGREEMENT_DTL | CLIENT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 401 |