SAP ABAP Table TRACV_ITEM_DATA (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | TRACV_ITEM_DATA | Table Relationship Diagram |
Short Description | Generated Table for 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 | MANDT | CLNT | 3 | 0 | Client | ||
2 | DOCUMENT_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | TRACT_DOCUMENT | |
3 | ITEM_NUMBER | POSNR_ACC | POSNR_ACC | NUMC | 10 | 0 | Accounting Document Line Item Number | ||
4 | PC_GUID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | TRACT_POSCONTEXT | |
5 | DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | CHAR | 8 | 0 | Update Type | TRDC_DFLOWTYPE | |
6 | SZART | TPM_SZART | XFELD | CHAR | 1 | 0 | Payment Transaction | ||
7 | AA_REF | TPM_AA_REF | TPM_AA_REF | CHAR | 12 | 0 | Account Assignment Reference of Position Management | ||
8 | ACC_SYMBOL | TPM_ACC_SYMBOL | TPM_ACC_SYMBOL | CHAR | 16 | 0 | Account Symbol for Account Assignment Reference | TRAC_ACCSYMB | |
9 | POSTING_CAT | TPM_POSTING_CAT | TPM_POSTING_CAT | INT1 | 3 | 0 | Posting Category | ||
10 | POSTING_KEY | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | ||
11 | GL_ACCOUNT | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | ||
12 | POSITION_AMT | TPM_FOREIGN_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Transaction Currency | ||
13 | POSITION_CURR | TPM_FOREIGN_CURR | WAERS | CUKY | 5 | 0 | Transaction Currency | ||
14 | LOCAL_AMT | TPM_LOCAL_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Local Currency | ||
15 | LOCAL_CURR | TPM_LOCAL_CURR | WAERS | CUKY | 5 | 0 | Local Currency | ||
16 | TRDFLOWNR | TPM_TRDFLOWNR | TPM_TRDFLOWNR | INT4 | 10 | 0 | Number of a Distributor Flow | ||
17 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
18 | REVERSAL_BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
19 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
20 | LOGVO | LOGVO | LOGVO | CHAR | 6 | 0 | Logical Transaction | ||
21 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | ||
22 | PAYMENT_DATE | TPM_PAYMENT_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Payment Date | ||
23 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | ||
24 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
25 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | ||
26 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | ||
27 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | ||
28 | RPBANK | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
29 | HOUSE_BANK | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | ||
30 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | ||
31 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | ||
32 | ALLOCNR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
33 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
34 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | ||
35 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
36 | RMVCT | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | ||
37 | VBUND | VBUND | RCOMP | CHAR | 6 | 0 | Company ID | ||
38 | KONTRAHENT | TB_KUNNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | ||
39 | ISSUER | REPKE_NEW | BU_PARTNER | CHAR | 10 | 0 | Issuer Identity Key | ||
40 | POS_IDENTIF_OID | TPM_DB_OS_GUID | TPM_DB_OS_GUID | CHAR | 32 | 0 | Object Identity in Database Format | DIFT_POS_IDENT | |
41 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
42 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | VWPANLA | |
43 | DEAL_NUMBER | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | VTBFHA | |
44 | LOANS_CONTRACT | RANL | RANL | CHAR | 13 | 0 | Contract Number | VDARL | |
45 | VALUATION_CLASS | TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | TRGC_VAL_CLASS | |
46 | PRODUCT_TYPE | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
47 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
48 | PORTFOLIO | TPM_PORTFOLIO_DIFF | RPORTB | CHAR | 10 | 0 | Portfolio as Differentiation Characteristic | TWPOB | |
49 | ACCOUNT_GROUP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | TRGT_SECACCGRP | |
50 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | TRFT_POS_ACCOUNT | |
51 | FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | CHAR | 1 | 0 | Indicator: Long or Short Position | ||
52 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | TRGC_VAL_AREA |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TRACV_ITEM_DATA | ACCOUNT_GROUP | TRGT_SECACCGRP | SEC_ACCT_GRP | |||
2 | TRACV_ITEM_DATA | ACC_SYMBOL | TRAC_ACCSYMB | ACC_SYMBOL | 1 | CN | |
3 | TRACV_ITEM_DATA | COMPANY_CODE | T001 | BUKRS | |||
4 | TRACV_ITEM_DATA | DEAL_NUMBER | VTBFHA | RFHA | KEY | 1 | CN |
5 | TRACV_ITEM_DATA | DIS_FLOWTYPE | TRDC_DFLOWTYPE | DIS_FLOWTYPE | KEY | 1 | CN |
6 | TRACV_ITEM_DATA | DOCUMENT_GUID | TRACT_DOCUMENT | OS_GUID | |||
7 | TRACV_ITEM_DATA | LOANS_CONTRACT | VDARL | RANL | |||
8 | TRACV_ITEM_DATA | PC_GUID | TRACT_POSCONTEXT | OS_GUID | KEY | 1 | CN |
9 | TRACV_ITEM_DATA | PORTFOLIO | TWPOB | RPORTB | |||
10 | TRACV_ITEM_DATA | POSITION_ACCOUNT | TRFT_POS_ACCOUNT | POS_ACCOUNT | KEY | 1 | CN |
11 | TRACV_ITEM_DATA | POS_IDENTIF_OID | DIFT_POS_IDENT | OS_GUID | REF | 1 | CN |
12 | TRACV_ITEM_DATA | PRODUCT_TYPE | TZPA | GSART | |||
13 | TRACV_ITEM_DATA | SECURITY_ACCOUNT | TWD01 | RLDEPO | |||
14 | TRACV_ITEM_DATA | SECURITY_ID | VWPANLA | RANL | |||
15 | TRACV_ITEM_DATA | VALUATION_AREA | TRGC_VAL_AREA | VALUATION_AREA | |||
16 | TRACV_ITEM_DATA | VALUATION_CLASS | TRGC_VAL_CLASS | VALUATION_CLASS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |