SAP ABAP Table TRACS_PJ_DISPLAY (Display Structure for the Posting Journal SAP List Viewer)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
⤷ FTR_ACCOUNTING_ADAPTOR (Package) CFM TM: Accounting Adaptor
⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
⤷ FTR_ACCOUNTING_ADAPTOR (Package) CFM TM: Accounting Adaptor
Basic Data
Table Category | INTTAB | Structure |
Structure | TRACS_PJ_DISPLAY | Table Relationship Diagram |
Short Description | Display Structure for the Posting Journal SAP List Viewer |
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 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | COMPANY_CODE_T | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
3 | ACCOUNTING_CODE | TPM_ACC_CODE | TPM_ACC_CODE | CHAR | 4 | 0 | Accounting Code | * | |
4 | ACCOUNTING_CODE_T | TPM_TR_ACC_CODE_NAME | TPM_DESCRIPTION | CHAR | 60 | 0 | Name of Accounting Code | ||
5 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | * | |
6 | VALUATION_AREA_T | TPM_VAL_AREA_NAME | TPM_DESCRIPTION | CHAR | 60 | 0 | Name of the Valuation Area | ||
7 | COM_VAL_CLASS | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | * | |
8 | VALUATION_CLASS | TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | * | |
9 | VALUATION_CLASS_T | TPM_VAL_CLASS_NAME | TPM_DESCRIPTION | CHAR | 60 | 0 | Description of valuation class | ||
10 | PRODUCT_TYPE | VVSART | VVSART | CHAR | 3 | 0 | Product Type | * | |
11 | PRODUCT_TYPE_T | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
12 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
13 | SECURITY_ID_T | XLBEZ | XTEXT50 | CHAR | 50 | 0 | Name | ||
14 | SECURITY_ID_TL | XALLB | XLBEZ | CHAR | 60 | 0 | Long name | ||
15 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
16 | SECURITY_ACCOUNT_T | XLDEPO | XLDEPO | CHAR | 30 | 0 | Securities account ID | ||
17 | ACCOUNT_GROUP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | * | |
18 | ACCOUNT_GROUP_T | TPM_SEC_ACCT_GRP_NAME | TPM_DESCRIPTION | CHAR | 60 | 0 | Name of Securities Account Group | ||
19 | PORTFOLIO | TPM_PORTFOLIO_DIFF | RPORTB | CHAR | 10 | 0 | Portfolio as Differentiation Characteristic | * | |
20 | PORTFOLIO_T | VVXPORTB | TEXT30 | CHAR | 30 | 0 | Portfolio name | ||
21 | LOANS_CONTRACT | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
22 | LOANS_CONTRACT_T | XLBEZ | XTEXT50 | CHAR | 50 | 0 | Name | ||
23 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | * | |
24 | POSITION_ACCOUNT_T | TPM_POS_ACC_FUT_TEXT | TPM_POS_ACC_FUT_TEXT | CHAR | 30 | 0 | Futures Account Text | ||
25 | DEAL_NUMBER | FTI_POSRFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction That Creates a Position | * | |
26 | AA_REF | TPM_AA_REF | TPM_AA_REF | CHAR | 12 | 0 | Account Assignment Reference of Position Management | * | |
27 | AA_REF_T | TPM_AA_REF_NAME | TPM_DESCRIPTION | CHAR | 60 | 0 | Name of Account Assignment Reference | ||
28 | ITEM_NUMBER | POSNR_ACC | POSNR_ACC | NUMC | 10 | 0 | Accounting Document Line Item Number | ||
29 | DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | CHAR | 8 | 0 | Update Type | * | |
30 | DIS_FLOWTYPE_T | TPM_DFT_TEXT | TPM_DESCRIPTION | CHAR | 60 | 0 | Update Type Text | ||
31 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
32 | ACC_SYMBOL | TPM_ACC_SYMBOL | TPM_ACC_SYMBOL | CHAR | 16 | 0 | Account Symbol for Account Assignment Reference | TRAC_ACCSYMB | |
33 | ACC_SYMBOL_T | TPM_ACC_SYMBOL_TEXT | TPM_DESCRIPTION | CHAR | 60 | 0 | Account Symbol Text | ||
34 | POSTING_CAT | TPM_POSTING_CAT | TPM_POSTING_CAT | INT1 | 3 | 0 | Posting Category | ||
35 | POSTING_CAT_T | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
36 | POSTING_KEY | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
37 | POSTING_KEY_T | TEXT_BSLT | TEXT20 | CHAR | 20 | 0 | Name of the Posting Key | ||
38 | GL_ACCOUNT | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
39 | GL_ACCOUNT_T | TXT50_SKAT | TEXT50 | CHAR | 50 | 0 | G/L Account Long Text | ||
40 | CHART_OF_ACCOUNTS | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | * | |
41 | POSITION_AMT | TPM_POSITION_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Position Currency | ||
42 | POSITION_CURR | TPM_POSITION_CURR | WAERS | CUKY | 5 | 0 | Position Currency | * | |
43 | LOCAL_AMT | TPM_LOCAL_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Local Currency | ||
44 | LOCAL_CURR | TPM_LOCAL_CURR | WAERS | CUKY | 5 | 0 | Local Currency | * | |
45 | BUSTRANSCAT | TPM_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category | TRDTS_BT_CAT | |
46 | BUSTRANSCAT_T | TPM_BUSTRANSCAT_TEXT | TPM_DESCRIPTION | CHAR | 60 | 0 | Name of Business Transaction Category | ||
47 | ACPOSTINGDATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
48 | ACPOSTINGPERIOD | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
49 | ACPOSTINGYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
50 | ACREVERSALDATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
51 | ACREVERSALPERIOD | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
52 | ACREVERSALYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
53 | CHANGE_NAME | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
54 | CHANGE_DATE | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
55 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
56 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
57 | AWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
58 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
59 | REVERSAL_AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
60 | REVERSAL_AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
61 | REVERSAL_AWKEY | REVERSAL_AWKEY | AWKEY | CHAR | 20 | 0 | Reversal Reference Key | ||
62 | REVERSAL_BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
63 | CREATE_NAME | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
64 | CREATE_DATE | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
65 | DOCUMENT_STATE | TPM_TRACDOCSTATE | TPM_TRACDOCSTATE | CHAR | 1 | 0 | TRAC Document Status | ||
66 | DOCUMENT_STATE_T | TPM_DOC_STATE_TEXT | TPM_DOC_STATE_TEXT | CHAR | 15 | 0 | Document Posting Status Text | ||
67 | SPECIALLEDGER | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | * | |
68 | BUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
69 | ACC_PRINCIPLE | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | CHAR | 4 | 0 | Accounting Principle | * | |
70 | TRDFLOWNR | TPM_TRDFLOWNR | TPM_TRDFLOWNR | INT4 | 10 | 0 | Number of a Distributor Flow | ||
71 | DOCUMENT_DATE | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
72 | BKTXT | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
73 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
74 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
75 | BLART_T | LTEXT_003T | TEXT20 | CHAR | 20 | 0 | Document Type Description | ||
76 | PAYMENT_DATE | TPM_PAYMENT_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Payment Date | ||
77 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
78 | KUNNR_T | BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
79 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
80 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
81 | ZLSCH_T | TEXT1_042Z | TEXT30 | CHAR | 30 | 0 | Name of Payment Method in Language of the Country | ||
82 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
83 | UZAWE_T | TXT30 | TEXT30 | CHAR | 30 | 0 | Text | ||
84 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
85 | ZLSPR_T | TEXTL_008 | TEXT20 | CHAR | 20 | 0 | Explanation of the Reason for Payment Block | ||
86 | RPBANK | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
87 | RPBANK_TRAC | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
88 | HOUSE_BANK | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | * | |
89 | HOUSE_BANK_TRAC | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | * | |
90 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | * | |
91 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | * | |
92 | LANDL_T | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
93 | ALLOCNR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
94 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
95 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
96 | GSBER_T | GTEXT | TEXT30 | CHAR | 30 | 0 | Business area description | ||
97 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
98 | KOSTL_T | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
99 | RMVCT | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | * | |
100 | RMVCT_T | RMVCT_TXT | TEXT20 | CHAR | 20 | 0 | Transaction type description | ||
101 | VBUND | VBUND | RCOMP | CHAR | 6 | 0 | Company ID | * | |
102 | VBUND_T | NAME_1 | TEXT30 | CHAR | 30 | 0 | Company name | ||
103 | KONTRAHENT | TB_KUNNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
104 | KONTRAHENT_T | TB_XKONTRH | TEXT80 | CHAR | 80 | 0 | Name and address of business partner | ||
105 | ISSUER | REPKE_NEW | BU_PARTNER | CHAR | 10 | 0 | Issuer Identity Key | * | |
106 | ISSUER_T | TB_XKONTRH | TEXT80 | CHAR | 80 | 0 | Name and address of business partner | ||
107 | PRQ_KEYNO | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
108 | PAYMENT_AWKEY | TPM_PAYMENT_AWKEY | AWKEY | CHAR | 20 | 0 | Payment Reference Key | ||
109 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
110 | SPRSNG | TB_SPRSNG | T_SPAYRQ | CHAR | 1 | 0 | Individual payment required | ||
111 | SCSPAY | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
112 | SIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
113 | SPRGRD | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
114 | SPRGRD_T | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
115 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
116 | PAYMENT_CURR | TPM_PAYMENT_CURR | WAERS | CUKY | 5 | 0 | Payment Currency | * | |
117 | PAYMENT_AMT | TPM_PAYMENT_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Payment Currency | ||
118 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
119 | RPCODE | RPCODE | RPCODE | CHAR | 20 | 0 | Repetitive Code | * | |
120 | RP_TEXT | RPCODE_TEXT | XTEXT50 | CHAR | 50 | 0 | Reference Text for Repetitive Code | ||
121 | CLEARING_ACC | PRQ_BKHBK | SAKNR | CHAR | 10 | 0 | G/L Account for Bank Clearing Account | * | |
122 | HOUSE_BANK_ACC | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | * | |
123 | RPZAHL | TB_RPZAHL_NEW | BU_PARTNER | CHAR | 10 | 0 | Payer/payee | * | |
124 | RPZAHL_T | BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
125 | RELEASE_STATE | TPM_TRPR_RELSTATE | TPM_TRPR_RELSTATE | CHAR | 1 | 0 | Release Status for Payment Requests | ||
126 | RELEASE_STATE_T | TPM_TRPR_RELSTATE_TEXT | CHAR15 | CHAR | 15 | 0 | Description of Release Status | ||
127 | DEAL_NUMBER_TM | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | * | |
128 | PORTFOLIO_TM | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | * | |
129 | TRANSACTION_TYPE_TM | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | * | |
130 | TRANSACTION_TYPE_TM_T | TB_FATEXT | T_XTEXT30 | CHAR | 30 | 0 | Name of Transaction Type | ||
131 | CREATE_CAT | TPM_TRAC_CREATE_CATEGORY | TPM_TRAC_CREATE_CATEGORY | CHAR | 1 | 0 | Indicator: Generate TRAC Document in Release | ||
132 | POST_CAT | TPM_TRAC_POST_CATEGORY | TPM_TRAC_POST_CATEGORY | CHAR | 1 | 0 | Update to Financial Accounting Indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TRACS_PJ_DISPLAY | ACC_SYMBOL | TRAC_ACCSYMB | ACC_SYMBOL | REF | 1 | CN |
2 | TRACS_PJ_DISPLAY | BUSTRANSCAT | TRDTS_BT_CAT | BUSTRANSCAT | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462_10 |