SAP Table PINS_TRL_POSITION
Subledger Position Indicator
PINS_TRL_POSITION (Subledger Position Indicator) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PINS_TRL_POSITION to other SAP tables.
PINS_TRL_POSITION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | TRGC_PM_PROC | CHAR | 4 | 0 | ||||||||||||||||||
| POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | 0 | |||||||||||||||||||
| VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | 0 | |||||||||||||||||||
| ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | TPM_ACTIVE_PASSIVE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | 0 | |||||||||||||||||||
| SKWG14NEU | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||||||||||||||||||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||||||||||||||||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||||||||||||||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||||||||||||||||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||||||||||||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||||||||||||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||||||||||||||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||||||||||||||||||
| FLG_SUBPOSITION | Indicator: Position has Subpositions | TPM_FLG_SUBPOSITION | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ACCOUNT_ASS_REF | Account Assignment Reference (prelim. sol. not CFM 1.0) | TPM_ACC_ASS_REF | CHAR | 10 | 0 | |||||||||||||||||||
| CONTXTSTATE | Obsolete: Status of Position Context | TPM_POS_CNTXT_STATE | INT1 | 3 | 0 |
Possible values
|
||||||||||||||||||
| AA_REF | Account Assignment Reference of Position Management | TPM_AA_REF | TRACC_AA_REF | CHAR | 12 | 0 | ||||||||||||||||||
| BUPLA | Business Place | BUPLA | CHAR | 4 | 0 | |||||||||||||||||||
| SECCO | Section Code | SECCO | CHAR | 4 | 0 | |||||||||||||||||||
| FKBER | Functional Area | FKBER | CHAR | 16 | 0 | |||||||||||||||||||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||||||||||||
| VALUATION_AREA | Valuation Area | TPM_VAL_AREA | TRGC_VAL_AREA | CHAR | 3 | 0 | ||||||||||||||||||
| COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | TRGC_COM_VALCL | NUMC | 4 | 0 | ||||||||||||||||||
| VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | TRGC_VAL_CLASS | NUMC | 4 | 0 | ||||||||||||||||||
| ACCOUNTING_CODE | Accounting Code | TPM_ACC_CODE | TRGC_TR_ACC_CODE | CHAR | 4 | 0 | ||||||||||||||||||
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||
| PRODUCT_TYPE | Product Type | VVSART | TZPA | CHAR | 3 | 0 | ||||||||||||||||||
| SECURITY_ACCOUNT | Securities Account | RLDEPO | TWD01 | CHAR | 10 | 0 | ||||||||||||||||||
| SECURITY_ID | Security ID Number | VVRANLW | VWPANLA | CHAR | 13 | 0 | ||||||||||||||||||
| PORTFOLIO | Portfolio as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | TWPOB | CHAR | 10 | 0 | ||||||||||||||||||
| TRADER | Trader | RDEALER | TZDEA | CHAR | 12 | 0 | ||||||||||||||||||
| ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | TRGT_SECACCGRP | CHAR | 10 | 0 | ||||||||||||||||||
| LOANS_CONTRACT | Contract Number | RANL | VDARL | CHAR | 13 | 0 | ||||||||||||||||||
| POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | TRFT_POS_ACCOUNT | CHAR | 10 | 0 | ||||||||||||||||||
| FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | 0 | |||||||||||||||||||
| DEAL_NUMBER | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 | 0 | ||||||||||||||||||
| FUND | Fund | FM_FUND | CHAR | 10 | 0 | |||||||||||||||||||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | 0 | |||||||||||||||||||
| EXTERNAL_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | 0 | |||||||||||||||||||
| DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | TCURC | CUKY | 5 | 0 | ||||||||||||||||||
| POS_ATTRIB_S1 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | TRLTC_ATTRVAL_S | CHAR | 4 | 0 | ||||||||||||||||||
| POS_ATTRIB_S2 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | TRLTC_ATTRVAL_S | CHAR | 4 | 0 | ||||||||||||||||||
| POS_ATTRIB_S3 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | TRLTC_ATTRVAL_S | CHAR | 4 | 0 | ||||||||||||||||||
| POS_ATTRIB_M1 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | TRLTC_ATTRVAL_M | CHAR | 10 | 0 | ||||||||||||||||||
| POS_ATTRIB_M2 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | TRLTC_ATTRVAL_M | CHAR | 10 | 0 | ||||||||||||||||||
| POS_ATTRIB_M3 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | TRLTC_ATTRVAL_M | CHAR | 10 | 0 | ||||||||||||||||||
| POS_ATTRIB_L1 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | 0 | |||||||||||||||||||
| POS_ATTRIB_L2 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | 0 | |||||||||||||||||||
| POS_ATTRIB_L3 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | 0 | |||||||||||||||||||
PINS_TRL_POSITION foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PINS_TRL_POSITION | AA_REF | SYST | MANDT | TRACC_AA_REF | Treasury: Account Assignment Reference | MANDT |
| PINS_TRL_POSITION | AA_REF | PINS_TRL_POSITION | AA_REF | TRACC_AA_REF | Treasury: Account Assignment Reference | AA_REF |
| PINS_TRL_POSITION | ACCOUNTING_CODE | * | TRGC_TR_ACC_CODE | Accounting Code | MANDT | |
| PINS_TRL_POSITION | ACCOUNTING_CODE | PINS_TRL_POSITION | ACCOUNTING_CODE | TRGC_TR_ACC_CODE | Accounting Code | TR_ACC_CODE |
| PINS_TRL_POSITION | ACCOUNT_GROUP | * | TRGT_SECACCGRP | Securities Account Groups (Definition) | MANDT | |
| PINS_TRL_POSITION | ACCOUNT_GROUP | PINS_TRL_POSITION | COMPANY_CODE | TRGT_SECACCGRP | Securities Account Groups (Definition) | COMPANY_CODE |
| PINS_TRL_POSITION | ACCOUNT_GROUP | PINS_TRL_POSITION | ACCOUNT_GROUP | TRGT_SECACCGRP | Securities Account Groups (Definition) | SEC_ACCT_GRP |
| PINS_TRL_POSITION | COMPANY_CODE | * | T001 | Company Codes | MANDT | |
| PINS_TRL_POSITION | COMPANY_CODE | PINS_TRL_POSITION | COMPANY_CODE | T001 | Company Codes | BUKRS |
| PINS_TRL_POSITION | COM_VAL_CLASS | PINS_TRL_POSITION | COM_VAL_CLASS | TRGC_COM_VALCL | General valuation class | COM_VAL_CLASS |
| PINS_TRL_POSITION | COM_VAL_CLASS | * | TRGC_COM_VALCL | General valuation class | MANDT | |
| PINS_TRL_POSITION | DEAL_NUMBER | PINS_TRL_POSITION | DEAL_NUMBER | VTBFHA | Transaction | RFHA |
| PINS_TRL_POSITION | DEAL_NUMBER | SYST | MANDT | VTBFHA | Transaction | MANDT |
| PINS_TRL_POSITION | DEAL_NUMBER | PINS_TRL_POSITION | COMPANY_CODE | VTBFHA | Transaction | BUKRS |
| PINS_TRL_POSITION | DIFF_CURRENCY | SYST | MANDT | TCURC | Currency Codes | MANDT |
| PINS_TRL_POSITION | DIFF_CURRENCY | PINS_TRL_POSITION | DIFF_CURRENCY | TCURC | Currency Codes | WAERS |
| PINS_TRL_POSITION | LOANS_CONTRACT | * | VDARL | Loans | MANDT | |
| PINS_TRL_POSITION | LOANS_CONTRACT | PINS_TRL_POSITION | COMPANY_CODE | VDARL | Loans | BUKRS |
| PINS_TRL_POSITION | LOANS_CONTRACT | * | VDARL | Loans | SARCHIV | |
| PINS_TRL_POSITION | LOANS_CONTRACT | PINS_TRL_POSITION | LOANS_CONTRACT | VDARL | Loans | RANL |
| PINS_TRL_POSITION | PORTFOLIO | * | TWPOB | Portfolio position | MANDT | |
| PINS_TRL_POSITION | PORTFOLIO | PINS_TRL_POSITION | COMPANY_CODE | TWPOB | Portfolio position | BUKRS |
| PINS_TRL_POSITION | PORTFOLIO | PINS_TRL_POSITION | PORTFOLIO | TWPOB | Portfolio position | RPORTB |
| PINS_TRL_POSITION | POSITION_ACCOUNT | SYST | MANDT | TRFT_POS_ACCOUNT | Treasury: Futures Account Master Data | MANDT |
| PINS_TRL_POSITION | POSITION_ACCOUNT | PINS_TRL_POSITION | COMPANY_CODE | TRFT_POS_ACCOUNT | Treasury: Futures Account Master Data | COMPANY_CODE |
| PINS_TRL_POSITION | POSITION_ACCOUNT | PINS_TRL_POSITION | POSITION_ACCOUNT | TRFT_POS_ACCOUNT | Treasury: Futures Account Master Data | POS_ACCOUNT |
| PINS_TRL_POSITION | POS_ATTRIB_M1 | SYST | MANDT | TRLTC_ATTRVAL_M | medium attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_M1 | 'M1' | TRLTC_ATTRVAL_M | medium attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_M1 | PINS_TRL_POSITION | POS_ATTRIB_M1 | TRLTC_ATTRVAL_M | medium attribute values | VALUE |
| PINS_TRL_POSITION | POS_ATTRIB_M2 | SYST | MANDT | TRLTC_ATTRVAL_M | medium attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_M2 | 'M2' | TRLTC_ATTRVAL_M | medium attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_M2 | PINS_TRL_POSITION | POS_ATTRIB_M2 | TRLTC_ATTRVAL_M | medium attribute values | VALUE |
| PINS_TRL_POSITION | POS_ATTRIB_M3 | PINS_TRL_POSITION | POS_ATTRIB_M3 | TRLTC_ATTRVAL_M | medium attribute values | VALUE |
| PINS_TRL_POSITION | POS_ATTRIB_M3 | SYST | MANDT | TRLTC_ATTRVAL_M | medium attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_M3 | 'M3' | TRLTC_ATTRVAL_M | medium attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_S1 | SYST | MANDT | TRLTC_ATTRVAL_S | short attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_S1 | 'S1' | TRLTC_ATTRVAL_S | short attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_S1 | PINS_TRL_POSITION | POS_ATTRIB_S1 | TRLTC_ATTRVAL_S | short attribute values | VALUE |
| PINS_TRL_POSITION | POS_ATTRIB_S2 | 'S2' | TRLTC_ATTRVAL_S | short attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_S2 | PINS_TRL_POSITION | POS_ATTRIB_S2 | TRLTC_ATTRVAL_S | short attribute values | VALUE |
| PINS_TRL_POSITION | POS_ATTRIB_S2 | SYST | MANDT | TRLTC_ATTRVAL_S | short attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_S3 | SYST | MANDT | TRLTC_ATTRVAL_S | short attribute values | MANDT |
| PINS_TRL_POSITION | POS_ATTRIB_S3 | 'S3' | TRLTC_ATTRVAL_S | short attribute values | ATTRIB | |
| PINS_TRL_POSITION | POS_ATTRIB_S3 | PINS_TRL_POSITION | POS_ATTRIB_S3 | TRLTC_ATTRVAL_S | short attribute values | VALUE |
| PINS_TRL_POSITION | POS_MAN_PROC | SYST | MANDT | TRGC_PM_PROC | Treasury: Position Management Procedure | MANDT |
| PINS_TRL_POSITION | POS_MAN_PROC | PINS_TRL_POSITION | POS_MAN_PROC | TRGC_PM_PROC | Treasury: Position Management Procedure | POS_MAN_PROC |
| PINS_TRL_POSITION | PRODUCT_TYPE | * | TZPA | Financial Assets Management Product Types | MANDT | |
| PINS_TRL_POSITION | PRODUCT_TYPE | PINS_TRL_POSITION | PRODUCT_TYPE | TZPA | Financial Assets Management Product Types | GSART |
| PINS_TRL_POSITION | SECURITY_ACCOUNT | PINS_TRL_POSITION | COMPANY_CODE | TWD01 | Treasury: Securities Account Master Data | BUKRS |
| PINS_TRL_POSITION | SECURITY_ACCOUNT | PINS_TRL_POSITION | SECURITY_ACCOUNT | TWD01 | Treasury: Securities Account Master Data | RLDEPO |
| PINS_TRL_POSITION | SECURITY_ACCOUNT | * | TWD01 | Treasury: Securities Account Master Data | MANDT | |
| PINS_TRL_POSITION | SECURITY_ID | * | VWPANLA | Asset master for securities | MANDT | |
| PINS_TRL_POSITION | SECURITY_ID | PINS_TRL_POSITION | SECURITY_ID | VWPANLA | Asset master for securities | RANL |
| PINS_TRL_POSITION | TRADER | * | TZDEA | Trader register | MANDT | |
| PINS_TRL_POSITION | TRADER | PINS_TRL_POSITION | COMPANY_CODE | TZDEA | Trader register | BUKRS |
| PINS_TRL_POSITION | TRADER | PINS_TRL_POSITION | TRADER | TZDEA | Trader register | RDEALER |
| PINS_TRL_POSITION | VALUATION_AREA | * | TRGC_VAL_AREA | Valuation Areas | MANDT | |
| PINS_TRL_POSITION | VALUATION_AREA | PINS_TRL_POSITION | VALUATION_AREA | TRGC_VAL_AREA | Valuation Areas | VALUATION_AREA |
| PINS_TRL_POSITION | VALUATION_CLASS | * | TRGC_VAL_CLASS | Treasury: Valuation Class | MANDT | |
| PINS_TRL_POSITION | VALUATION_CLASS | PINS_TRL_POSITION | VALUATION_AREA | TRGC_VAL_CLASS | Treasury: Valuation Class | VALUATION_AREA |
| PINS_TRL_POSITION | VALUATION_CLASS | PINS_TRL_POSITION | VALUATION_CLASS | TRGC_VAL_CLASS | Treasury: Valuation Class | VALUATION_CLASS |
