SAP ABAP Table BEAS_IPMO_DLPI_DSP (Structure of IPMO DPLI-BVAL used for WebUI)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-IM-IPM-RO (Application Component) Royalty Accounting
⤷ CRM_IPM_BEA_GENIL (Package) IPM GenIL: Billing Engine Applications
⤷ CRM-IM-IPM-RO (Application Component) Royalty Accounting
⤷ CRM_IPM_BEA_GENIL (Package) IPM GenIL: Billing Engine Applications
Basic Data
Table Category | INTTAB | Structure |
Structure | BEAS_IPMO_DLPI_DSP | Table Relationship Diagram |
Short Description | Structure of IPMO DPLI-BVAL used for WebUI |
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 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
2 | ORDER_IDX | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
3 | .INCLUDE | 0 | 0 | IPM BEA: Single Settlement Item - Data Part | |||||
4 | .INCLU-_TX | 0 | 0 | IPM BEA: Key Fields in a Transaction Item | |||||
5 | LOGSYS_TX | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
6 | OBJTYPE_TX | OJ_NAME | OJ_NAME | CHAR | 10 | 0 | Object type | TOJTB | |
7 | SRC_HEADNO_TX | CRMT_IPM_BDC_OBJECT_REF | CRMT_IPM_BDC_OBJECT_REF | CHAR | 18 | 0 | Document Reference in Settlement Data Collector | ||
8 | SRC_ITEMNO_TX | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
9 | .INCLU-_TX | 0 | 0 | IPM BEA: Key Fields for Time in a Transaction Item | |||||
10 | DATE_TX | BEA_RENDERED_DATE | SYDATS | DATS | 8 | 0 | Date of Services Rendered | ||
11 | CANCELED | CRMT_IPM_BEA_CANCELED | XFELD | CHAR | 1 | 0 | Reversed Single Settlement Item Indicator | ||
12 | .INCLUDE | 0 | 0 | IPM BEA: Single Settlement Itm - Data Part After Contrt Det. | |||||
13 | .INCLU-_OR | 0 | 0 | IPM BEA: Key Fields in a Transaction Item | |||||
14 | LOGSYS_OR | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
15 | OBJTYPE_OR | OJ_NAME | OJ_NAME | CHAR | 10 | 0 | Object type | TOJTB | |
16 | SRC_HEADNO_OR | CRMT_IPM_BDC_OBJECT_REF | CRMT_IPM_BDC_OBJECT_REF | CHAR | 18 | 0 | Document Reference in Settlement Data Collector | ||
17 | SRC_ITEMNO_OR | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
18 | BR_ITEMNO_OR | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
19 | KKURS | KKURS | KKURS | DEC | 9 | 5 | Condition exchange rate for conversion to local currency | ||
20 | STATUS | CRMT_IPM_BEA_DPL_STATUS | CRMT_IPM_BEA_DPL_STATUS | CHAR | 1 | 0 | IPM: Status in the Settlement Data Collector | ||
21 | .INCLUDE | 0 | 0 | IPM: BW Fields in the Settlement Data Collector | |||||
22 | .INCLUDE | 0 | 0 | IPM BEA: Data Part of Values Container | |||||
23 | .INCLUDE | 0 | 0 | IPM BEA: Content Key for Value Container | |||||
24 | PARENT_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
25 | VALUE_TYPE | CRMT_IPM_BEA_VALUE_TYPE | CRMT_IPM_BEA_VALUE_TYPE | CHAR | 4 | 0 | Data Value | CRMC_IPM_DATATYP | |
26 | CUM_SCOPE | CRMT_IPM_BEA_CUM_SCOPE | CRMT_IPM_BEA_CUM_SCOPE | CHAR | 1 | 0 | Cumulation Scope for a Value | CRMC_IPM_CUM_SCP | |
27 | .INCLUDE | 0 | 0 | IPM BEA: Values Part of the Value Container | |||||
28 | QUANTITY | CRMT_CUM_QUAN | CRM_MENGV15 | QUAN | 15 | 3 | CRM Quantity for Cumulated I | ||
29 | QUANTITY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
30 | VALUE | CRMT_CUM_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Cumulative Value | ||
31 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
32 | IP_ID | CRMT_IPM_IP_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Intellectual Property ID | ||
33 | DERIV_COUNT | BEA_DERIV_COUNT | BEA_DERIV_COUNT | NUMC | 2 | 0 | Counter for Derived Items | ||
34 | TIER_BDI_GUID | BEA_BDI_GUID | SYSUUID | RAW | 16 | 0 | GUID of Billing Item | ||
35 | IP | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
36 | PRODUCT_DESCR | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
37 | LANGU | CRMT_IPM_LANGU | CRMT_IPM_LANGU | CHAR | 10 | 0 | Language | * | |
38 | MARKET | CRMT_IPM_MARKET | CRMT_IPM_MARKET | CHAR | 18 | 0 | Market | * | |
39 | TERRI | CRMT_IPM_TERRI | CRMT_IPM_TERRI | CHAR | 10 | 0 | Territory | * | |
40 | AC_ASSIGNMENT | CRMT_AC_ASSIGN | CRMT_AC_ASSIGN | CHAR | 50 | 0 | Settlement Account Assignment | ||
41 | AC_OBJECT_TYPE | CRMT_AC_OBJECT_TYPE | CRMT_OBJECT_TYPE | CHAR | 2 | 0 | Object Type for Settlement Account Assignment | * | |
42 | AC_TYPE_T | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
43 | LOGSYS_PD | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
44 | OBJTYPE_PD | OJ_NAME | OJ_NAME | CHAR | 10 | 0 | Object type | * | |
45 | SRC_HEADNO_PD | CRMT_IPM_BDC_OBJECT_REF | CRMT_IPM_BDC_OBJECT_REF | CHAR | 18 | 0 | Document Reference in Settlement Data Collector | ||
46 | SRC_ITEMNO_PD | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
47 | TIER_SEQUENCE | NUM2 | NUM2 | NUMC | 2 | 0 | Numeric, 2-digit value | ||
48 | TIER_START | NUM2 | NUM2 | NUMC | 2 | 0 | Numeric, 2-digit value | ||
49 | TKSTBS_END | PRCT_COND_SCALE_LEVEL | PRC_QUANTITY | DEC | 18 | 5 | Scale Limit | ||
50 | TKSTBS_START | PRCT_COND_SCALE_LEVEL | PRC_QUANTITY | DEC | 18 | 5 | Scale Limit | ||
51 | TNB_TIERS | NUM2 | NUM2 | NUMC | 2 | 0 | Numeric, 2-digit value | ||
52 | IS_GREY_OUT | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
53 | OPERATOR | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
54 | DERIV_CATEGORY | BEA_DERIV_CATEGORY | BEA_DERIV_CATEGORY | CHAR | 1 | 0 | Derivation Category in Billing Due List | ||
55 | ACC_BD_HEADNO | CRMT_IPM_BDC_OBJECT_REF | CRMT_IPM_BDC_OBJECT_REF | CHAR | 18 | 0 | Document Reference in Settlement Data Collector | ||
56 | ACC_BDH_GUID | BEA_BDH_GUID | SYSUUID | RAW | 16 | 0 | Unique Internal ID of a Billing Header | ||
57 | ACC_BDI_GUID | BEA_BDI_GUID | SYSUUID | RAW | 16 | 0 | GUID of Billing Item | ||
58 | TIER_SCALE_FROM | CRMT_IPM_VALUE_UI | DEC18_2 | DEC | 18 | 2 | IPM: Value for UI | ||
59 | TIER_SCALE_TO | CRMT_IPM_VALUE_UI | DEC18_2 | DEC | 18 | 2 | IPM: Value for UI | ||
60 | TIER_SHARE | CRMT_IPM_VALUE_UI | DEC18_2 | DEC | 18 | 2 | IPM: Value for UI | ||
61 | TIER_SCALE_LEVEL_T | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
62 | PD_BDH_GUID | BEA_BDH_GUID | SYSUUID | RAW | 16 | 0 | Unique Internal ID of a Billing Header | ||
63 | RGHTDIM01 | CRMT_IPM_RIGHTS_DIM1 | CRMT_IPM_RIGHTS_DIM1 | CHAR | 30 | 0 | Rights Dimension 1 | ||
64 | RGHTDIM02 | CRMT_IPM_RIGHTS_DIM2 | CRMT_IPM_RIGHTS_DIM2 | CHAR | 30 | 0 | Rights Dimension 2 | ||
65 | RGHTDIM03 | CRMT_IPM_RIGHTS_DIM3 | CRMT_IPM_RIGHTS_DIM3 | CHAR | 30 | 0 | Rights Dimension 3 | ||
66 | RGHTDIM04 | CRMT_IPM_RIGHTS_DIM4 | CRMT_IPM_RIGHTS_DIM4 | CHAR | 30 | 0 | Rights Dimension 4 | ||
67 | RGHTDIM05 | CRMT_IPM_RIGHTS_DIM5 | CRMT_IPM_RIGHTS_DIM5 | CHAR | 30 | 0 | Rights Dimension 5 | ||
68 | RGHTDIM06 | CRMT_IPM_RIGHTS_DIM6 | CRMT_IPM_RIGHTS_DIM6 | CHAR | 30 | 0 | Rights Dimension 6 | ||
69 | STATUS_T | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BEAS_IPMO_DLPI_DSP | CUM_SCOPE | CRMC_IPM_CUM_SCP | CUM_SCOPE | REF | 1 | CN |
2 | BEAS_IPMO_DLPI_DSP | LOGSYS_OR | TBDLS | LOGSYS | REF | 1 | CN |
3 | BEAS_IPMO_DLPI_DSP | LOGSYS_TX | TBDLS | LOGSYS | REF | 1 | CN |
4 | BEAS_IPMO_DLPI_DSP | OBJTYPE_OR | TOJTB | NAME | REF | 1 | CN |
5 | BEAS_IPMO_DLPI_DSP | OBJTYPE_TX | TOJTB | NAME | REF | 1 | CN |
6 | BEAS_IPMO_DLPI_DSP | VALUE_TYPE | CRMC_IPM_DATATYP | DATA_TYPE | REF | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |