SAP ABAP Table TRQV_ASSIGN (Generated Table for View TRQV_ASSIGN)
Basic Data
Table Category | VIEW | General view structure |
General view structure | TRQV_ASSIGN | Table Relationship Diagram |
Short Description | Generated Table for View TRQV_ASSIGN |
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_RULE | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | BUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
4 | EXTBUSTRANSID | TPM_EXTBUSTRANSID | TPM_EXTBUSTRANSID | CHAR | 60 | 0 | Default ID from Creator for Distributor Business Transaction | ||
5 | DEAL_NUMBER | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | ||
6 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
7 | LOT_ID | TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
8 | CONTRIBUTION | TPM_CONTRIBUTION | TPM_CONTRIBUTION | DEC | 25 | 6 | Distribution Key for Lot Assignment | ||
9 | TRANSFER_GROUP | TPM_TRANSFER_GROUP | TPM_SYSTEM_KEY | NUMC | 4 | 0 | Group of Flows from a Source or Target | ||
10 | LOT_ID_REF | TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
11 | FLOWGROUP_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
12 | ASSIGNMENT_GUID | TPM_ASSIGNMENT | TPM_DB_OS_GUID | CHAR | 32 | 0 | Allocation rule | ||
13 | ITEM_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
14 | BUSTRANS_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
15 | BUSTRANSCAT | TPM_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category | ||
16 | POSITION_GUID | TPM_QUANTITIY_POSITION | TPM_DB_OS_GUID | CHAR | 32 | 0 | Quantity Position | ||
17 | SELECTOR_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
18 | COM_VAL_CLASS | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | TRGC_COM_VALCL | |
19 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | ||
20 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | VWPANLA | |
21 | PORTFOLIO | TPM_PORTFOLIO_DIFF | RPORTB | CHAR | 10 | 0 | Portfolio as Differentiation Characteristic | ||
22 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | ||
23 | FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | CHAR | 1 | 0 | Indicator: Long or Short Position | ||
24 | CONSUMPTION_CAT | TPM_CONSUMPTION_CAT | TPM_CONSUMPTION_CAT | CHAR | 1 | 0 | Consumption Sequence Procedure | ||
25 | TRDBUSTRANS_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | ||
26 | TRANSFER_GROUPFG | TPM_TRANSFER_GROUP | TPM_SYSTEM_KEY | NUMC | 4 | 0 | Group of Flows from a Source or Target | ||
27 | SOURCETARGET_FLG | TPM_SOURCE_TARGET_FLG | TPM_SOURCE_TARGET_FLG | CHAR | 1 | 0 | Indicator: Source or Target of a Flow | ||
28 | LOT_CREATION | TPM_LOT_CREATION | TPM_LOT_CREATION | NUMC | 1 | 0 | Lot Creation Category | ||
29 | MANDT_FG | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
30 | MANDT_BT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
31 | MANDT_TRD_BT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
32 | MANDT_POS | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
33 | MANDT_DIF | MANDT | MANDT | CLNT | 3 | 0 | Client |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TRQV_ASSIGN | COMPANY_CODE | T001 | BUKRS | KEY | 1 | CN |
2 | TRQV_ASSIGN | COM_VAL_CLASS | TRGC_COM_VALCL | COM_VAL_CLASS | |||
3 | TRQV_ASSIGN | MANDT_TRD_BT | T000 | MANDT | KEY | 1 | CN |
4 | TRQV_ASSIGN | SECURITY_ID | VWPANLA | RANL |
History
Last changed by/on | SAP | 20080505 |
SAP Release Created in |