1. Home
  2. Resources
  3. SAP Tables
  4. PINS_TRL_POSITION_DISPLAY - Subsidiary Ledger Position Indicator: Display Structure

SAP Table PINS_TRL_POSITION_DISPLAY

Subsidiary Ledger Position Indicator: Display Structure

PINS_TRL_POSITION_DISPLAY (Subsidiary Ledger Position Indicator: Display Structure) 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_DISPLAY to other SAP tables.

PINS_TRL_POSITION_DISPLAY table fields

Field Data element Checktable Datatype Length Decimals
ROW_NUMBER Row Number TPM_ROW_NUMBER NUMC 3 0
VALUATION_AREA Valuation Area TPM_VAL_AREA CHAR 3 0
VALUATION_AREA_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
ACCOUNTING_CODE Accounting Code TPM_ACC_CODE CHAR 4 0
ACCOUNTING_CODE_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
VALUATION_CLASS Valuation Class TPM_VAL_CLASS TRGC_VAL_CLASS NUMC 4 0
VALUATION_CLASS_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
COMPANY_CODE Company Code BUKRS CHAR 4 0
COMPANY_CODE_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
PRODUCT_TYPE Product Type VVSART CHAR 3 0
PRODUCT_TYPE_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
SECURITY_ACCOUNT Securities Account RLDEPO CHAR 10 0
SECURITY_ACCOUNT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
SECURITY_ID Security ID Number VVRANLW CHAR 13 0
SECURITY_ID_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
PORTFOLIO Portfolio RPORTB CHAR 10 0
PORTFOLIO_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
ACCOUNT_GROUP Securities Account Group TPM_SEC_ACCT_GRP CHAR 10 0
ACCOUNT_GROUP_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
LOANS_CONTRACT Contract Number RANL CHAR 13 0
LOANS_CONTRACT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT CHAR 10 0
POSITION_ACCOUNT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
FLAG_LONG_SHORT Indicator: Long or Short Position TPM_FLAG_LONG_SHORT CHAR 1 0
L Long position
S Short position
FLAG_LONG_SHORT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
DEAL_NUMBER Financial Transaction TB_RFHA CHAR 13 0
DEAL_NUMBER_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
FLAG_LOT Single Position TPM_TRL_LOT_SIGN CHAR 1 0
FLAG_LOT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
EXTERNAL_ACCOUNT External Account TPM_EXT_ACCOUNT CHAR 10 0
EXTERNAL_ACCOUNT_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
POS_MAN_PROC Position Management Procedure TPM_POS_MAN_PROC TRGC_PM_PROC CHAR 4 0
POS_MAN_PROC_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
POSITION_CURR Position Currency TPM_POSITION_CURR TCURC CUKY 5 0
POSITION_CURR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
VALUATION_CURR Valuation Currency TPM_VALUATION_CURR CUKY 5 0
VALUATION_CURR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position TPM_ACTIVE_PASSIVE CHAR 1 0
NULL Asset Position
P Liability Position
ACTIVE_PASSIVE_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
SBILK Balance Sheet Indicator SBILK TW11 CHAR 2 0
SBILK_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
SKWG14NEU Position grouping acc. Para 14 GBA (Sec. and loans) VVSKWG14 CHAR 2 0
20 Loans acc. to para 19, sentence 2, NOT column 7, 8, 9
27 Loans acc. to para 19, sent. 2, real estate loans �14 GBA II
28 Loans acc. to para 19, sent. 2, publ.loans. �14 GBA II
29 Loans acc. to para 19, sent. 2, inter-bank loans, �14 GBA II
30 Off-balance sheet transactions, NOT columns 4, 5, 6
34 Off-balance sheet transactions, fin.swaps etc. �14 GBA I,s.1
35 Off-balance sheet transactions, swaps etc. �14 GBA I,s.1
36 Off-balance sheet trans., guarantees etc. �14 GBA I,s.1
SKWG14NEU_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
AA_REF Account Assignment Reference of Position Management TPM_AA_REF CHAR 12 0
AA_REF_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
RERF Entered by RERF CHAR 12 0
RERF_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
DERF First Entered on DERF DATS 8 0
DERF_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
TERF Time of Initial Entry TERF TIMS 6 0
TERF_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
REHER Source of initial entry REHER CHAR 10 0
REHER_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
RBEAR Employee ID RBEAR CHAR 12 0
RBEAR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
DBEAR Last Edited on DBEAR DATS 8 0
DBEAR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
TBEAR Last Edited at TBEAR TIMS 6 0
TBEAR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
RBHER Editing Source RBHER CHAR 10 0
RBHER_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
BUPLA_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
SECCO Section Code SECCO SECCODE CHAR 4 0
SECCO_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
FUND Fund FM_FUND CHAR 10 0
FUND_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GRANT_NBR_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
FKBER Functional Area FKBER TFKB CHAR 16 0
FKBER_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOSTL_SM Display Mode TRG_SCREEN_MODE INT1 3 0
0 Hide
1 Display
2 Changeable
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
POS_ATTRIB_S1_TXT Description TPM_DESCRIPTION30 CHAR 30 0
POS_ATTRIB_S2_TXT Description TPM_DESCRIPTION30 CHAR 30 0
POS_ATTRIB_S3_TXT Description TPM_DESCRIPTION30 CHAR 30 0
POS_ATTRIB_M1_TXT Description TPM_DESCRIPTION30 CHAR 30 0
POS_ATTRIB_M2_TXT Description TPM_DESCRIPTION30 CHAR 30 0
POS_ATTRIB_M3_TXT Description TPM_DESCRIPTION30 CHAR 30 0
TAB_SUBPOSITION PINY_TRL_SUBPOSITION_DISPLAY TTYP 0 0

PINS_TRL_POSITION_DISPLAY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PINS_TRL_POSITION_DISPLAY BUPLA PINS_TRL_POSITION_DISPLAY BUPLA J_1BBRANCH Business Place BRANCH
PINS_TRL_POSITION_DISPLAY BUPLA SYST MANDT J_1BBRANCH Business Place MANDT
PINS_TRL_POSITION_DISPLAY BUPLA PINS_TRL_POSITION_DISPLAY COMPANY_CODE J_1BBRANCH Business Place BUKRS
PINS_TRL_POSITION_DISPLAY FKBER SYST MANDT TFKB Functional areas MANDT
PINS_TRL_POSITION_DISPLAY FKBER PINS_TRL_POSITION_DISPLAY FKBER TFKB Functional areas FKBER
PINS_TRL_POSITION_DISPLAY KOSTL SYST MANDT CSKS Cost Center Master Data MANDT
PINS_TRL_POSITION_DISPLAY KOSTL * CSKS Cost Center Master Data KOKRS
PINS_TRL_POSITION_DISPLAY KOSTL PINS_TRL_POSITION_DISPLAY KOSTL CSKS Cost Center Master Data KOSTL
PINS_TRL_POSITION_DISPLAY KOSTL * CSKS Cost Center Master Data DATBI
PINS_TRL_POSITION_DISPLAY POSITION_CURR PINS_TRL_POSITION_DISPLAY POSITION_CURR TCURC Currency Codes WAERS
PINS_TRL_POSITION_DISPLAY POSITION_CURR SYST MANDT TCURC Currency Codes MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M1 SYST MANDT TRLTC_ATTRVAL_M medium attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M1 'M1' TRLTC_ATTRVAL_M medium attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M1 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M1 TRLTC_ATTRVAL_M medium attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M2 SYST MANDT TRLTC_ATTRVAL_M medium attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M2 'M2' TRLTC_ATTRVAL_M medium attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M2 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M2 TRLTC_ATTRVAL_M medium attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M3 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M3 TRLTC_ATTRVAL_M medium attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M3 SYST MANDT TRLTC_ATTRVAL_M medium attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_M3 'M3' TRLTC_ATTRVAL_M medium attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S1 SYST MANDT TRLTC_ATTRVAL_S short attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S1 'S1' TRLTC_ATTRVAL_S short attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S1 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S1 TRLTC_ATTRVAL_S short attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S2 'S2' TRLTC_ATTRVAL_S short attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S2 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S2 TRLTC_ATTRVAL_S short attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S2 SYST MANDT TRLTC_ATTRVAL_S short attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S3 SYST MANDT TRLTC_ATTRVAL_S short attribute values MANDT
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S3 'S3' TRLTC_ATTRVAL_S short attribute values ATTRIB
PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S3 PINS_TRL_POSITION_DISPLAY POS_ATTRIB_S3 TRLTC_ATTRVAL_S short attribute values VALUE
PINS_TRL_POSITION_DISPLAY POS_MAN_PROC SYST MANDT TRGC_PM_PROC Treasury: Position Management Procedure MANDT
PINS_TRL_POSITION_DISPLAY POS_MAN_PROC PINS_TRL_POSITION_DISPLAY POS_MAN_PROC TRGC_PM_PROC Treasury: Position Management Procedure POS_MAN_PROC
PINS_TRL_POSITION_DISPLAY SBILK PINS_TRL_POSITION_DISPLAY SBILK TW11 Balance sheet indicator SBILK
PINS_TRL_POSITION_DISPLAY SBILK SYST MANDT TW11 Balance sheet indicator MANDT
PINS_TRL_POSITION_DISPLAY SECCO SYST MANDT SECCODE Section Code MANDT
PINS_TRL_POSITION_DISPLAY SECCO PINS_TRL_POSITION_DISPLAY COMPANY_CODE SECCODE Section Code BUKRS
PINS_TRL_POSITION_DISPLAY SECCO PINS_TRL_POSITION_DISPLAY SECCO SECCODE Section Code SECCODE
PINS_TRL_POSITION_DISPLAY VALUATION_CLASS SYST MANDT TRGC_VAL_CLASS Treasury: Valuation Class MANDT
PINS_TRL_POSITION_DISPLAY VALUATION_CLASS PINS_TRL_POSITION_DISPLAY VALUATION_AREA TRGC_VAL_CLASS Treasury: Valuation Class VALUATION_AREA
PINS_TRL_POSITION_DISPLAY VALUATION_CLASS PINS_TRL_POSITION_DISPLAY VALUATION_CLASS TRGC_VAL_CLASS Treasury: Valuation Class VALUATION_CLASS