SAP table PINS_TRL_POSITION (Subledger Position Indicator)

Field Description Data Type Length Decimals Checktable Data Element
POS_MAN_PROC Position Management Procedure CHAR 4 0 TRGC_PM_PROC TPM_POS_MAN_PROC
POSITION_CURR Position Currency CUKY 5 0 TCURC TPM_POSITION_CURR
VALUATION_CURR Valuation Currency CUKY 5 0 * TPM_VALUATION_CURR
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position CHAR 1 0 TPM_ACTIVE_PASSIVE
Asset Position
P Liability Position
SBILK Balance Sheet Indicator CHAR 2 0 * SBILK
SKWG14NEU Position Grouping Acc. Article 14 GBA (Sec. and Loans) CHAR 2 0 VVSKWG14
20 Loans acc. to para. 19, sentence 2, NOT column 7, 8, 9
26 Loans acc. to para 19 sent. 2 resid. RE loans para 14 GBA II
27 Loans acc. to para. 19, sent. 2, RE loans, para. 14 GBA II
28 Loans acc. to para 19, sent. 2, public loans, para 14 GBA II
29 Loans acc. to para 19 sent. 2 interbank loans para 14 GBA II
30 Off-balance sheet transactions, NOT columns 4, 5, 6
31 Open irrevocable real estate loan commitments
32 Open irrevocable resid. real estate loan commitments
33 Open revocable real estate loan commitments
34 Off-bal. sheet transactions, fin.swaps etc para 14 GBA I,s.1
35 Off-balance sheet transactions, swaps etc para. 14 GBA I,s.1
36 Off-balance sheet trans., guarantees etc para. 14 GBA I, s.1
37 Open irrevocable loan commitments
38 Open revocable loan commitments
39 Open revocable resid. real estate loan commitments
41 Bonds and Other Interest-Bearing Securities
42 Bonds and Other Interest-Bearing Securities – Trading Book
43 Stocks, Shareholdings, Shares in Company
44 Stocks, Shareholdings, Shares in Company – Trading Book
45 Sec. Rep. Agreements/Lending Trans. as Repo Buyer/Borrower
46 Sec. Rep. Agreements/Lending Trans. as Repo Seller/Lender
50 Derivatives
51 Counterparty Risk from Credit Derivatives as Prot. Buyer
52 Counterparty Risk from Credit Derivatives as Prot. Seller
55 Risk Position from Credit Derivatives as Protection Buyer
56 Risk Position from Credit Derivatives as Protection Seller
60 Collateral
80 Coll. and loans acc. to para. 19, sent. 2, NOT col. 7, 8, 9
86 Coll. and loans acc. to para 19 sent. 2 resid. RE loans
87 Coll. and loans acc. to para. 19, sent. 2, RE loans
88 Coll. and loans acc. to para 19, sent. 2, public loans
89 Coll. and loans acc. to para 19 sent. 2 interbank loans
90 Coll. and off-balance sheet transactions, NOT col. 4, 5, 6
91 Coll. and open irrevocable real estate loan commitments
92 Coll. and open irrevocable resid. real est. loan commitments
93 Coll. and open revocable real estate loan commitments
94 Coll. and off-bal. sheet transactions, fin.swaps etc
95 Coll. and off-balance sheet transactions, swaps etc
96 Coll. and off-balance sheet trans., guarantees etc
97 Coll. and open irrevocable loan commitments
98 Coll. and open revocable loan commitments
99 Coll. and open revocable resid. real estate loan commitments
D1 Coll. and Bonds and Other Interest-Bearing Securities
D2 Coll. and Bonds and Other Interest-Bearing Securities – TB
D3 Coll. and Stocks, Shareholdings, Shares in Company
D4 Coll. and Stocks, Shareholdings, Shares in Company – TB
D5 Coll. and Sec. Rep. Agr./Lend. Trans. as Repo Buyer/Borrower
D6 Coll. and Sec. Rep. Agr./Lend. Trans. as Repo Seller/Lender
E0 Collateral and Derivatives
E1 Coll. and Counterparty Risk from Credit Deri. as Prot. Buyer
E2 Coll. and Counterparty Risk from Credit Deri. as Prot. Sell.
E5 Coll. and Risk Pos. from Credit Deri. as Protection Buyer
E6 Coll. and Risk Pos. from Credit Deri. as Protection Seller
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
FLG_SUBPOSITION Indicator: Position has Subpositions CHAR 1 0 TPM_FLG_SUBPOSITION
ACCOUNT_ASS_REF Account Assignment Reference (Prelim. Solution, Not CFM 1.0) CHAR 10 0 * TPM_ACC_ASS_REF
CONTXTSTATE Obsolete: Status of Position Context INT1 3 0 TPM_POS_CNTXT_STATE
0 Not charged
1 Charged
AA_REF Account Assignment Reference of Position Management CHAR 12 0 TRACC_AA_REF TPM_AA_REF
BUPLA Business Place CHAR 4 0 * BUPLA
SECCO Section Code CHAR 4 0 SECCO
FKBER Functional Area CHAR 16 0 * FKBER
KOSTL Cost Center CHAR 10 0 * KOSTL
VALUATION_AREA Treasury Valuation Area CHAR 3 0 TRGC_VAL_AREA TPM_VAL_AREA
ACCOUNTING_CODE Accounting Code CHAR 4 0 TRGC_TR_ACC_CODE TPM_ACC_CODE
COMPANY_CODE Company Code CHAR 4 0 T001 BUKRS
PRODUCT_TYPE Product Type CHAR 3 0 TZPA VVSART
SECURITY_ACCOUNT Securities Account CHAR 10 0 * RLDEPO
SECURITY_ID Security Class ID Number CHAR 13 0 * VVRANLW
PORTFOLIO Portfolio as Differentiation Characteristic CHAR 10 0 TWPOB TPM_PORTFOLIO_DIFF
ACCOUNT_GROUP Securities Account Group CHAR 10 0 * TPM_SEC_ACCT_GRP
POSITION_ACCOUNT Futures Account for Listed Options and Futures CHAR 10 0 TPM_POS_ACCOUNT_FUT
FLAG_LONG_SHORT Indicates whether it is a long or a short position CHAR 1 0 TPM_FLAG_LONG_SHORT
L Long position
S Short position
LOT_ID Identifier of the Lot RAW 16 0 TPM_LOT_ID
LOANS_CONTRACT Contract Number CHAR 13 0 * RANL
DEAL_NUMBER Financial Transaction CHAR 13 0 * TB_RFHA
EXTERNAL_ACCOUNT External Account CHAR 10 0 TPM_EXT_ACCOUNT
DIFF_CURRENCY Currency as Differentiation Term CUKY 5 0 * TPM_DIFF_CURRENCY
HEDGED_ITEM_ID Identification Number of Hedged Item NUMC 10 0 THM_HEDGE_ID
EXPOSURE_ITEM_ID Exposure Item ID CHAR 13 0 TOE_EXPOSURE_ITEM_ID
COM_VAL_CLASS General Valuation Class NUMC 4 0 TRGC_COM_VALCL TPM_COM_VAL_CLASS
VALUATION_CLASS Valuation Class NUMC 4 0 TRGC_VAL_CLASS TPM_VAL_CLASS
FUND Fund CHAR 10 0 * FM_FUND
GRANT_NBR Grant CHAR 20 0 * GM_GRANT_NBR
TRADER Trader CHAR 12 0 * RDEALER
EXPOSURE_SUBITEM_ID Exposure Subitem ID CHAR 13 0 TOE_EXPOSURE_SUBITEM_ID
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
COST_CENTER Cost Center CHAR 10 0 CSKS KOSTL
PROFIT_CENTER Profit Center CHAR 10 0 CEPC PRCTR
FUNCTIONAL_AREA Functional Area CHAR 16 0 TFKB FKBER
POS_ATTRIB_S1 Short Position Attribute CHAR 4 0 TRLTC_ATTRVAL_S TPM_POS_ATTRIB_SHORT
POS_ATTRIB_S2 Short Position Attribute CHAR 4 0 TRLTC_ATTRVAL_S TPM_POS_ATTRIB_SHORT
POS_ATTRIB_S3 Short Position Attribute CHAR 4 0 TRLTC_ATTRVAL_S TPM_POS_ATTRIB_SHORT
POS_ATTRIB_M1 Medium Position Attribute CHAR 10 0 TRLTC_ATTRVAL_M TPM_POS_ATTRIB_MEDIUM
POS_ATTRIB_M2 Medium Position Attribute CHAR 10 0 TRLTC_ATTRVAL_M TPM_POS_ATTRIB_MEDIUM
POS_ATTRIB_M3 Medium Position Attribute CHAR 10 0 TRLTC_ATTRVAL_M TPM_POS_ATTRIB_MEDIUM
POS_ATTRIB_L1 Long Position Attribute CHAR 30 0 TPM_POS_ATTRIB_LONG
POS_ATTRIB_L2 Long Position Attribute CHAR 30 0 TPM_POS_ATTRIB_LONG
POS_ATTRIB_L3 Long Position Attribute CHAR 30 0 TPM_POS_ATTRIB_LONG

PINS_TRL_POSITION foreign key relationships

Table Field Check Table Check Field
0 PINS_TRL_POSITION AA_REF TRACC_AA_REF Treasury: Account Assignment Reference MANDT
0 PINS_TRL_POSITION AA_REF TRACC_AA_REF Treasury: Account Assignment Reference AA_REF
1 PINS_TRL_POSITION ACCOUNTING_CODE TRGC_TR_ACC_CODE Accounting Code MANDT
0 PINS_TRL_POSITION COMPANY_CODE T001 Company Codes BUKRS
1 PINS_TRL_POSITION COM_VAL_CLASS TRGC_COM_VALCL General valuation class MANDT
1 PINS_TRL_POSITION COM_VAL_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS
0 PINS_TRL_POSITION COST_CENTER CSKS Cost Center Master Record MANDT
0 PINS_TRL_POSITION COST_CENTER CSKS Cost Center Master Record KOKRS
0 PINS_TRL_POSITION COST_CENTER CSKS Cost Center Master Record KOSTL
0 PINS_TRL_POSITION COST_CENTER CSKS Cost Center Master Record DATBI
1 PINS_TRL_POSITION FUNCTIONAL_AREA TFKB Functional areas FKBER
0 PINS_TRL_POSITION PORTFOLIO TWPOB Portfolio position MANDT
0 PINS_TRL_POSITION PORTFOLIO TWPOB Portfolio position BUKRS
0 PINS_TRL_POSITION PORTFOLIO TWPOB Portfolio position RPORTB
1 PINS_TRL_POSITION POSITION_CURR TCURC Currency Codes WAERS
0 PINS_TRL_POSITION POS_ATTRIB_M1 TRLTC_ATTRVAL_M medium attribute values MANDT
0 PINS_TRL_POSITION POS_ATTRIB_M1 TRLTC_ATTRVAL_M medium attribute values ATTRIB
0 PINS_TRL_POSITION POS_ATTRIB_M1 TRLTC_ATTRVAL_M medium attribute values VALUE
1 PINS_TRL_POSITION POS_ATTRIB_M2 TRLTC_ATTRVAL_M medium attribute values MANDT
1 PINS_TRL_POSITION POS_ATTRIB_M2 TRLTC_ATTRVAL_M medium attribute values ATTRIB
1 PINS_TRL_POSITION POS_ATTRIB_M2 TRLTC_ATTRVAL_M medium attribute values VALUE
0 PINS_TRL_POSITION POS_ATTRIB_M3 TRLTC_ATTRVAL_M medium attribute values MANDT
0 PINS_TRL_POSITION POS_ATTRIB_M3 TRLTC_ATTRVAL_M medium attribute values ATTRIB
0 PINS_TRL_POSITION POS_ATTRIB_M3 TRLTC_ATTRVAL_M medium attribute values VALUE
1 PINS_TRL_POSITION POS_ATTRIB_S1 TRLTC_ATTRVAL_S short attribute values MANDT
1 PINS_TRL_POSITION POS_ATTRIB_S1 TRLTC_ATTRVAL_S short attribute values ATTRIB
1 PINS_TRL_POSITION POS_ATTRIB_S1 TRLTC_ATTRVAL_S short attribute values VALUE
0 PINS_TRL_POSITION POS_ATTRIB_S2 TRLTC_ATTRVAL_S short attribute values MANDT
0 PINS_TRL_POSITION POS_ATTRIB_S2 TRLTC_ATTRVAL_S short attribute values ATTRIB
0 PINS_TRL_POSITION POS_ATTRIB_S2 TRLTC_ATTRVAL_S short attribute values VALUE
1 PINS_TRL_POSITION POS_ATTRIB_S3 TRLTC_ATTRVAL_S short attribute values MANDT
1 PINS_TRL_POSITION POS_ATTRIB_S3 TRLTC_ATTRVAL_S short attribute values ATTRIB
1 PINS_TRL_POSITION POS_ATTRIB_S3 TRLTC_ATTRVAL_S short attribute values VALUE
0 PINS_TRL_POSITION POS_MAN_PROC TRGC_PM_PROC Treasury: Position Management Procedure MANDT
1 PINS_TRL_POSITION PRODUCT_TYPE TZPA Financial Assets Management Product Types MANDT
1 PINS_TRL_POSITION PRODUCT_TYPE TZPA Financial Assets Management Product Types GSART
0 PINS_TRL_POSITION PROFIT_CENTER CEPC Profit Center Master Data Table PRCTR
0 PINS_TRL_POSITION PROFIT_CENTER CEPC Profit Center Master Data Table DATBI
0 PINS_TRL_POSITION PROFIT_CENTER CEPC Profit Center Master Data Table KOKRS
1 PINS_TRL_POSITION VALUATION_AREA TRGC_VAL_AREA Valuation Areas MANDT
1 PINS_TRL_POSITION VALUATION_AREA TRGC_VAL_AREA Valuation Areas VALUATION_AREA
0 PINS_TRL_POSITION VALUATION_CLASS TRGC_VAL_CLASS Treasury: Valuation Class MANDT
0 PINS_TRL_POSITION VALUATION_CLASS TRGC_VAL_CLASS Treasury: Valuation Class VALUATION_AREA
1 PINS_TRL_POSITION WBS_ELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 PINS_TRL_POSITION WBS_ELEMENT PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR