SAP ABAP Table TRLV_TRANS_POS (Generated Table for View), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `TRLV_TRANS_POS` {Generated Table for View}

Home

                title {label: "SAP ABAP table TRLV_TRANS_POS {Generated Table for View}", size: "20"}

# Entities

[TRLV_TRANS_POS] {bgcolor: "tomato"}
*MANDT {label: "CLNT (3)"}
*OS_GUID {label: "CHAR (32)"}
*+BUSTRANSCAT {label: "NUMC (4)"}
*TRLDATE {label: "DATS (8)"}
*BUSTRANSID {label: "RAW (16)"}
*CREATE_DATE {label: "DATS (8)"}
*CREATE_TIME {label: "TIMS (6)"}
*BUSTRANSSTATE {label: "CHAR (1)"}
*BOOKING_STATE {label: "CHAR (1)"}
*REFBUSTRANSID {label: "RAW (16)"}
*FI_POST_DATE {label: "DATS (8)"}
*FI_POST_PERIOD {label: "NUMC (2)"}
*+USER_DATA_OID {label: "CHAR (32)"}
*USER_DATA_CLS {label: "CHAR (32)"}
*TRLFLOWNUMBER {label: "INT4 (10)"}
*FLOWNUMBER {label: "INT4 (10)"}
*SOURCETARGET_FLG {label: "CHAR (1)"}
*TRANSFER_GROUP {label: "NUMC (4)"}
*FLOWTYPE {label: "CHAR (8)"}
*AMOUNT_FACTOR {label: "FLTP (16)"}
*QUANT_CAT {label: "CHAR (4)"}
*AMOUNT_CAT {label: "CHAR (4)"}
*UNITS {label: "DEC (22)"}
*NOMINAL_AMT {label: "CURR (21)"}
*NOMINAL_CURR {label: "CUKY (5)"}
*POSAMT_IDX_CLEAN {label: "CURR (21)"}
*POSITION_AMT {label: "CURR (21)"}
*POSITION_CURR {label: "CUKY (5)"}
*VALUATION_AMT {label: "CURR (21)"}
*VALUATION_CURR {label: "CUKY (5)"}
*POS_MAN_PROC {label: "CHAR (4)"}
*ACTIVE_PASSIVE {label: "CHAR (1)"}
*SBILK {label: "CHAR (2)"}
*SKWG14NEU {label: "CHAR (2)"}
*+VALUATION_AREA {label: "CHAR (3)"}
*+COM_VAL_CLASS {label: "NUMC (4)"}
*+VALUATION_CLASS {label: "NUMC (4)"}
*+ACCOUNTING_CODE {label: "CHAR (4)"}
*+COMPANY_CODE {label: "CHAR (4)"}
*+PRODUCT_TYPE {label: "CHAR (3)"}
*+SECURITY_ACCOUNT {label: "CHAR (10)"}
*+SECURITY_ID {label: "CHAR (13)"}
*+PORTFOLIO {label: "CHAR (10)"}
*+TRADER {label: "CHAR (12)"}
*+ACCOUNT_GROUP {label: "CHAR (10)"}
*+LOANS_CONTRACT {label: "CHAR (13)"}
*+POSITION_ACCOUNT {label: "CHAR (10)"}
*FLAG_LONG_SHORT {label: "CHAR (1)"}
*LOT_ID {label: "RAW (16)"}
*+DEAL_NUMBER {label: "CHAR (13)"}
*NOMINAL_ORG_AMT {label: "CURR (21)"}
*CALCULATION_DATE {label: "DATS (8)"}
*CALC_DATE_INCL {label: "NUMC (1)"}
*DUE_DATE {label: "DATS (8)"}
*CALC_BEGIN {label: "DATS (8)"}
*CALC_END {label: "DATS (8)"}
*EFF_INT_RATE_U {label: "DEC (10)"}
*EFF_INT_RATE_N {label: "DEC (10)"}
*+IDENTIFIER_OID {label: "CHAR (32)"}

[DIFT_POS_IDENT] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*OS_GUID {label: "CHAR (32)"}

[T001] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BUKRS {label: "CHAR (4)"}

[TRDTS_BT_CAT] {bgcolor: "#d0e0d0"}
*BUSTRANSCAT {label: "NUMC (4)"}

[TRFT_POS_ACCOUNT] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*+COMPANY_CODE {label: "CHAR (4)"}
*POS_ACCOUNT {label: "CHAR (10)"}

[TRGC_COM_VALCL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*COM_VAL_CLASS {label: "NUMC (4)"}

[TRGC_TR_ACC_CODE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TR_ACC_CODE {label: "CHAR (4)"}

[TRGC_VAL_AREA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*VALUATION_AREA {label: "CHAR (3)"}

[TRGC_VAL_CLASS] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+VALUATION_AREA {label: "CHAR (3)"}
*VALUATION_CLASS {label: "NUMC (4)"}

[TRGT_SECACCGRP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+COMPANY_CODE {label: "CHAR (4)"}
*SEC_ACCT_GRP {label: "CHAR (10)"}

[TRGT_USER_DATA] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*OS_GUID {label: "CHAR (32)"}

[TWD01] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RLDEPO {label: "CHAR (10)"}

[TWPOB] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RPORTB {label: "CHAR (10)"}

[TZDEA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RDEALER {label: "CHAR (12)"}

[TZPA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GSART {label: "CHAR (3)"}

[VDARL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*SARCHIV {label: "CHAR (1)"}
*RANL {label: "CHAR (13)"}

[VTBFHA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*RFHA {label: "CHAR (13)"}

[VWPANLA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*RANL {label: "CHAR (13)"}

# Relationships

TRLV_TRANS_POS *--* TRGC_TR_ACC_CODE {label: "TRLV_TRANS_POS-ACCOUNTING_CODE = TRGC_TR_ACC_CODE-TR_ACC_CODE"}
TRLV_TRANS_POS *--* TRGT_SECACCGRP {label: "TRLV_TRANS_POS-ACCOUNT_GROUP = TRGT_SECACCGRP-SEC_ACCT_GRP"}
TRLV_TRANS_POS *--* TRDTS_BT_CAT {label: "TRLV_TRANS_POS-BUSTRANSCAT = TRDTS_BT_CAT-BUSTRANSCAT"}
TRLV_TRANS_POS *--* T001 {label: "TRLV_TRANS_POS-COMPANY_CODE = T001-BUKRS"}
TRLV_TRANS_POS *--* TRGC_COM_VALCL {label: "TRLV_TRANS_POS-COM_VAL_CLASS = TRGC_COM_VALCL-COM_VAL_CLASS"}
TRLV_TRANS_POS 1--* VTBFHA {label: "TRLV_TRANS_POS-DEAL_NUMBER = VTBFHA-RFHA"}
TRLV_TRANS_POS *--* DIFT_POS_IDENT {label: "TRLV_TRANS_POS-IDENTIFIER_OID = DIFT_POS_IDENT-OS_GUID"}
TRLV_TRANS_POS *--* VDARL {label: "TRLV_TRANS_POS-LOANS_CONTRACT = VDARL-RANL"}
TRLV_TRANS_POS *--* TWPOB {label: "TRLV_TRANS_POS-PORTFOLIO = TWPOB-RPORTB"}
TRLV_TRANS_POS 1--* TRFT_POS_ACCOUNT {label: "TRLV_TRANS_POS-POSITION_ACCOUNT = TRFT_POS_ACCOUNT-POS_ACCOUNT"}
TRLV_TRANS_POS *--* TZPA {label: "TRLV_TRANS_POS-PRODUCT_TYPE = TZPA-GSART"}
TRLV_TRANS_POS *--* TWD01 {label: "TRLV_TRANS_POS-SECURITY_ACCOUNT = TWD01-RLDEPO"}
TRLV_TRANS_POS *--* VWPANLA {label: "TRLV_TRANS_POS-SECURITY_ID = VWPANLA-RANL"}
TRLV_TRANS_POS *--* TZDEA {label: "TRLV_TRANS_POS-TRADER = TZDEA-RDEALER"}
TRLV_TRANS_POS *--* TRGT_USER_DATA {label: "TRLV_TRANS_POS-USER_DATA_OID = TRGT_USER_DATA-OS_GUID"}
TRLV_TRANS_POS *--* TRGC_VAL_AREA {label: "TRLV_TRANS_POS-VALUATION_AREA = TRGC_VAL_AREA-VALUATION_AREA"}
TRLV_TRANS_POS *--* TRGC_VAL_CLASS {label: "TRLV_TRANS_POS-VALUATION_CLASS = TRGC_VAL_CLASS-VALUATION_CLASS"}

E-R Diagram for table TRLV_TRANS_POS (Generated Table for View)

Foreign Key tables (17)

DIFT_POS_IDENT {Persistent Flow Selectors}
T001 {Company Codes}
TRDTS_BT_CAT {Treasury: Business Transaction Categories}
TRFT_POS_ACCOUNT {Treasury: Futures Account Master Data}
TRGC_COM_VALCL {General valuation class}
TRGC_TR_ACC_CODE {Accounting Code}
TRGC_VAL_AREA {Valuation Areas}
TRGC_VAL_CLASS {Treasury: Valuation Class}
TRGT_SECACCGRP {Securities Account Groups (Definition)}
TRGT_USER_DATA {TR Position Management - User Data}
TWD01 {Treasury: Securities Account Master Data}
TWPOB {Portfolio position}
TZDEA {Trader register}
TZPA {Financial Assets Management Product Types}
VDARL {Loans}
VTBFHA {Transaction}
VWPANLA {Asset master for securities}

SAP ABAP Table TRLV_TRANS_POS {Generated Table for View}

Foreign Key tables (17)

SAP ABAP Table `TRLV_TRANS_POS` {Generated Table for View}