TCORS_NODE_MAINDATA SAP (TCO Data: Deal Main data) Structure details

Dictionary Type: Structure
Description: TCO Data: Deal Main data




ABAP Code to SELECT data from TCORS_NODE_MAINDATA
Related tables to TCORS_NODE_MAINDATA
Access table TCORS_NODE_MAINDATA




Structure field list including key, data, relationships and ABAP select examples

TCORS_NODE_MAINDATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "TCO Data: Deal Main data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TCORS_NODE_MAINDATA TYPE TCORS_NODE_MAINDATA.

The TCORS_NODE_MAINDATA table consists of various fields, each holding specific information or linking keys about TCO Data: Deal Main data data available in SAP. These include COMPANYCODE (CO: Company code), DEAL_NUMBER (Position-Generating Financial Transaction), SE_DEAL_NUMBER (Securities/Futures Transaction), SIDE (Direction of Transaction).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP TCORS_NODE_MAINDATA structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
COMPANYCODECO: Company code FTR_CO_BUKRSCHAR4Assigned to domainBUKRSC_T001
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SE_DEAL_NUMBERSecurities/Futures Transaction FTI_SE_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SIDEDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
REFERENCE_NOReference number (unit no.) KL_NRCHAR10Assigned to domainALPHAKL_NRT30
REFERENCE_TYPEReference Category (Unit Category) KL_TYPCHAR3Assigned to domainKL_TYPT31
OBJECTNUMBERObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
CREATE_USEREntered by TB_CRUSERCHAR12SYCHAR12
CREATE_DATEEntered On TB_DCRDATDATS8DATUM
CREATE_TIMEEntry Time TB_TCRTIMTIMS6UZEIT
UPDATE_USERLast Changed by TB_UPUSERCHAR12SYCHAR12
UPDATE_DATEChanged on TB_DUPDATDATS8DATUM
UPDATE_TIMETime changed TB_TUPTIMTIMS6UZEIT
CONTRACT_TYPEContract Type RANTYPCHAR1RANTYP
PRODUCT_CATProduct Category SANLFNUMC3Assigned to domainVVSANLF
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
TRANSACTION_CATTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
ACTIVITY_CATTransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
TRANSACTION_TYPEFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
START_TERMStart of Term FTI_DBLFZ_DEALDATS8DATUM
END_TERMEnd of Term FTI_DELFZ_DEALDATS8DATUM
ROLLOVER_TERMRollover Date FTI_ROLLOVER_DEALDATS8DATUM
START_INCLUSIVECalculation Period: Start Inclusive vs. End Inclusive FTI_SINCLBECHAR1T_SINCLBE
END_INCLUSIVEEnd of Term Inclusive Indicator TB_SINCLECHAR1XFELD
NOTICE_DATEOTC Notice Date TB_NOTICE_DATEDATS8DATUM
LIMIT_DATELimit date TB_LIMITDADATS8DATUM
CONTRACT_DATEContract Conclusion Date TB_DVTRABDATS8DATUM
CONTRACT_TIMETime of contract conclusion TB_TVTRABTIMS6UZEIT
TRADERTrader RDEALERCHAR12Assigned to domainRDEALER
COUNTERPARTYCounterparty TB_KONTRHCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
CONTACT_PERSONContact Person TB_GSPPARTCHAR19TEXT19
GUARANTORGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
EXTERNAL_REFNCEExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FINANCE_PROJECTFinance Project TB_TFPROJCHAR13T_TFPROJ
MASTER_AGREEMENTMaster Agreement TB_RMAIDCHAR10Assigned to domainALPHAT_RMAIDTMAVTMA
ASSIGNMENTAssignment TB_ZUONDCHAR18TEXT18
INTERNAL_REFNCEInternal Reference TB_REFERCHAR16CHAR16
CHARACTERISTICSCharacteristics TB_MERKMCHAR25CHAR25
VALUATION_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4Assigned to domainTPM_COM_VAL_CLASSCVC
FACILITY_DEALNOTransaction Number of Facility TB_FACILITYNRCHAR13Assigned to domainALPHAT_RFHAF4_FTR_FC
FACILITY_CCODECompany Code of Facility TB_FACILITYBUKRSCHAR4Assigned to domainBUKRSH_T001
DEAL_ACTIVEActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
RELEASE_STATUSTransaction Release: Release Status TB_FRGZUSTCHAR1T_FRGZUST
REVERSAL_REASONReason for Reversal SSTOGRDCHAR2Assigned to domainSSTOGRD
CONFIRM_STATUSConfirmation Status TB_CONFNUMC1TB_CONF
CONFIRM_DATEConfirmation Date TB_DCONFDATS8DATUM
CONFIRM_USERConfirmation Executed By (User Responsible) TB_UCONFCHAR12USNAM
CNTRCONFIRMCounterconfirmation TB_RECONFNUMC1TB_RECONF
CNTRCONFIRM_DATECounterconfirmation Date TB_DREDATDATS8DATUM
CNTRCONFIRM_USERCounterconfirmation Executed by (User Responsible) TB_URENAMCHAR12USNAM
CURRENCYCurrency of Transaction FTI_WGSCHFTCUKY5Assigned to domainWAERS
CURRENCY_RCVCurrency of Incoming Side of Transaction FTI_WGSCHF2CUKY5Assigned to domainWAERS
CURRENCY_PAYCurrency of Outgoing Side of Transaction FTI_WGSCHF1CUKY5Assigned to domainWAERS
NOM_AMOUNTNominal Amount FTI_NOMAMTCURR13(2) WERTV7
NOM_AMOUNT_RCVNominal Amount: Incoming Side of Transaction FTI_BGSCHF2CURR13(2) WERTV7
NOM_AMOUNT_PAYNominal Amount: Outgoing Side of Transaction FTI_BGSCHF1CURR13(2) WERTV7
UNITSUnits FTI_POSITIONS_UNITSDEC22(6) TPM_UNITS
LEAD_CURRENCYLeading Currency FTI_LWAERSCUKY5Assigned to domainWAERS
FOLL_CURRENCYFollowing Currency FTI_FWAERSCUKY5Assigned to domainWAERS
RATERate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
SPOTRATESpot Rate TB_KKASSADEC13(9) TB_KKURS
SWAPRATESwap Rate TB_KSWAPDEC13(9) T_SWKURS
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
QUANTITY_TRADEDCommodity Quantity to Be Delivered FTI_CTY_QUAN_DELVRDQUAN25(5) FTI_CTY_QUAN
COMMODITY_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
CONTRACT_PRICECommodity Contract Price FTI_CTY_PRICEDEC13(5) FTR_COMPRICE
CTY_SPOT_PRICECommodity spot price FTI_CTY_SPOT_PRCDEC13(5) FTR_COMPRICE
CONT_BACKCommodity Contango / Backwardation FTR_CONBACKDEC13(5) FTR_COMPRICE
EFF_INTEffective Interest Rate TB_PYIELDDEC10(7) DECV3_7
EFF_INT_METHODEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
INT_CATInterest Category FTI_INTTYPECHAR1FTI_INTEREST_TYPE
INT_CURRENTNominal Interest Rate FTI_NOMINALZINSDEC10(7) DEC3_7
INT_REFReference Interest Rate FTI_INTREFCHAR10Assigned to domainZIREFKU
INT_FORMULAString for Interest Formula FTI_XINTFORMULACHAR132TEXT132
INT_STATUSInterest Fixing Status FTI_INTSTATUSCHAR1FTI_INTSTATUS
INT_NEXT_FIXNext Interest Rate Adjustment Date FTI_NEXT_FIXDATEDATS8DATUM
INT_NEXT_DUENext Interest Due Date FTI_NEXT_DUEDATEDATS8DATUM
INT_AMOUNTInterest Amount FTI_INTAMOUNTCURR21(2) TPM_AMOUNT
INT_CURRENCYPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
INT_CAT_INInterest Category of Incoming Side FTI_INTTYPE_INCHAR1FTI_INTEREST_TYPE
INT_CURRENT_INNominal Interest Rate of Incoming Side FTI_NOMINALZINS_INDEC10(7) DEC3_7
INT_REF_INReference Interest Rate Incoming Side FTI_INTREF_INCHAR10Assigned to domainZIREFKU
INT_FORMULA_INString for Interest Formula of Incoming Side FTI_XINTFORMULA_INCHAR132TEXT132
INT_STATUS_INInterest Fixing Status: Incoming Side FTI_INTSTATUS_INCHAR1FTI_INTSTATUS
INT_NEXT_FIX_INNext Interest Rate Adjustment Date of Incoming Side FTI_NEXT_FIXDATE_INDATS8DATUM
INT_NEXT_DUE_INNext Interest Due Date FTI_NEXT_DUEDATEDATS8DATUM
INT_AMOUNT_INInterest Amount of Incoming Side FTI_INTAMOUNT_INCURR21(2) TPM_AMOUNT
INT_CURRENCY_INPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
INT_CAT_OUTInterest Category of Outgoing Side FTI_INTTYPE_OUTCHAR1FTI_INTEREST_TYPE
INT_CURRENT_OUTNominal Interest Rate of Outgoing Side FTI_NOMINALZINS_OUTDEC10(7) DEC3_7
INT_REF_OUTReference Interest Rate of Outgoing Side FTI_INTREF_OUTCHAR10Assigned to domainZIREFKU
INT_FORMULA_OUTString for Interest Formula of Outgoing Side FTI_XINTFORMULA_OUTCHAR132TEXT132
INT_STATUS_OUTInterest Fixing Status: Outgoing Side FTI_INTSTATUS_OUTCHAR1FTI_INTSTATUS
INT_NEXT_FIX_OUTNext Interest Rate Adjustment Date of Outgoing Side FTI_NEXT_FIXDATE_OUTDATS8DATUM
INT_NEXT_DUE_OUTNext Interest Due Date FTI_NEXT_DUEDATEDATS8DATUM
INT_AMOUNT_OUTInterest Amount of Outgoing Side FTI_INTAMOUNT_OUTCURR21(2) TPM_AMOUNT
INT_CURRENCY_OUTPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
PUT_CALLPut/Call Indicator FTI_SPUTCALNUMC1T_SPUTCAL
EXPIRATION_DATEExercise Date FTI_DMATURDATS8DATUM
STRIKE_CURRENCYStrike Currency of Option/Future FTI_OFWAERSCUKY5Assigned to domainWAERS
STRIKE_AMOUNTOption Strike Amount FTI_OSTRIKECURR13(2) WERTV7
STRIKE_PRICEStrike Price (Upper Limit for Cap, Lower Limit for Floor) FTI_STRIKE_PRICEDEC10(7) DECV3_7
EXERCISE_TYPEExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
SETTLEMENT_TYPESettlement indicator TI_SETTLFLCHAR1T_SETTLFL
OPTION_CATEGORYOriginal option category (on closing) TV_OPTTYPNUMC3Assigned to domainT_OPTTYP
DIR_STRIKEAMOUNTDirection of Strike Amount FTI_OSSIGNCHAR1T_SSIGN
BARRIER_CATEGORYCategory of Knock-In/Knock-Out Level TI_SLEVELTNUMC2T_SLEVELT
LEAD_CURR_ULLeading Currency of Underlying Transaction FTI_LWAERS_ULCUKY5Assigned to domainWAERS
FOLLOW_CURR_ULFollowing Currency of Underlying Transaction FTI_FWAERS_ULCUKY5Assigned to domainWAERS
BARRIERBarrier as forex rate for exotic options TX_KWKURB1DEC13(9) TB_KKURS
BARRIER2Barrier 2 as forex rate for exotic options TX_KWKURB2DEC13(9) TB_KKURS
PREMIUM_AMT_PYCOption Premium in Payment Currency FTI_PREMIUM_PYCCURR13(2) WERTV7
PREMIUM_DATEPremium Payment Date FTI_PREMIUM_DATEDATS8DATUM
POSITION_CCYPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
LOCAL_CCYLocal Currency TB_SHWHRCUKY5Assigned to domainWAERS
NUMBER_TRADEDTraded Number of Units for Unit-Quoted Securities/Futures FTI_NUMBER_TRADEDDEC15(5) ASTUECK
NOM_AMT_TRADEDTraded Nominal Amount FTI_NOMAMT_TRADEDCURR13(2) WERTV7
NOMORGAMT_TRADEDTraded Original Nominal Amount FTI_NOMORGAMT_TRADEDCURR13(2) WERTV7
PRICE_TRADEDTraded Price of Security (Mixed Representation) FTI_PRICE_TRADEDDEC15(6) FTI_PRICE_TRADED
PRICE_CCYUNTCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
PRICE_CCYUNT_PRCQuotation Currency Unit / Percent (Mixed Representation) FTI_QUOT_UNIT_PRCTCHAR5FTI_QUOT_UNIT_PRCT
QUOTATIONQuotation type for option, future, security etc. TB_NOTTYPECHAR1T_NOTTYPE
QUOTATION_CCYQuotation Currency FTI_QUOT_CCYCUKY5Assigned to domainWAERS
FX_RATE_TO_LCLocal currency rate TB_KHWKURSDEC9(5) EXCRTUKURS
HOUSEBNK_INShort Key for Own House Bank: Incoming Side FTI_HBANK_INCHAR5Assigned to domainHBKID
HOUSEBNKACCT_INShort Key for House Bank Account: Incoming Side FTI_HBACCT_INCHAR5Assigned to domainHKTID
PAYER_PAYEE_INPayer/Payee of Incoming Side FTI_PAYERPAYEE_INCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNERBNK_INPartner Bank Details of Incoming Side FTI_PBANK_INCHAR4BVTYP
HOUSEBNK_OUTShort Key for Own House Bank: Outgoing Side FTI_HBANK_OUTCHAR5Assigned to domainHBKID
HOUSEBNKACCT_OUTShort Key for House Bank Account: Outgoing Side FTI_HBACCT_OUTCHAR5Assigned to domainHKTID
PAYER_PAYEE_OUTPayer/Payee of Outgoing Side FTI_PAYERPAYEE_OUTCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNERBNK_OUTPartner Bank Details of Outgoing Side FTI_PBANK_OUTCHAR4BVTYP
QUOTATION_NAMEQuotation Name FTI_QUOTNAMECHAR18FTI_QUOTNAME
QUOTATION_SOURCEQuotation Source TCR_CTY_QUOTSRCCHAR2Assigned to domainTCR_CTY_QUOTSRC
QUOTATION_TYPECommodity Quotation Type TCR_CTY_QUOTTYPECHAR5Assigned to domainTCR_CTY_QUOTTYPE
SPREADCommodity Spread FTR_COMSPREADDEC13(5) FTR_COMPRICE
COMMODITY_ID1Commodity ID Outgoing FTI_COMM_ID_OUTCHAR18TPM_CTY_ID
QUANTITY_INIncoming Commodity Quantity FTI_QUAN_INQUAN13(3) FTR_QUAN
UOM_INUnit of Measure for Incoming Commodity FTI_UOM_INUNIT3Assigned to domainCUNITMEINS
CTY_PRICE_INIncoming Comodity Price FTI_CTY_PRICE_INDEC13(5) FTR_COMPRICE
QUOT_NAME_INIncoming Quotation Name FTI_QUOTNAME_INCHAR18FTI_QUOTNAME
QUOT_SOURC_INIncoming Quotation Source FTI_QUOTSOURCE_INCHAR2Assigned to domainTCR_CTY_QUOTSRC
QUOT_TYPE_INIncoming Quotation Type FTI_QUOTTYPE_INCHAR5Assigned to domainTCR_CTY_QUOTTYPE
CTY_SPREAD_INSpread Incoming Side FTI_SPREAD_INDEC10(7) DECV3_7
COMMODITY_ID2Commodity ID Incoming FTI_COMM_ID_INCHAR18TPM_CTY_ID
QUANTITY_OUTOutgoing Commodity Quantity FTI_QUAN_OUTQUAN13(3) FTR_QUAN
UOM_OUTUnit of Measure for Outgoing Commodity FTI_UOM_OUTUNIT3Assigned to domainCUNITMEINS
CTY_PRICE_OUTOutgoing Commodity Price FTI_CTY_PRICE_OUTDEC13(5) FTR_COMPRICE
QUOT_NAME_OUTOutgoing Quotation Name FTI_QUOTNAME_OUTCHAR18FTI_QUOTNAME
QUOT_SOURC_OUTOutgoing Quotation Source FTI_QUOTSOURCE_OUTCHAR2Assigned to domainTCR_CTY_QUOTSRC
QUOT_TYPE_OUTOutgoing Quotation Type FTI_QUOTTYPE_OUTCHAR5Assigned to domainTCR_CTY_QUOTTYPE
CTY_SPREAD_OUTSpread Outgoing Side FTI_SPREAD_OUTDEC10(7) DECV3_7
COMMODITY_ID_ULUnderlying Commodity ID FTI_CTY_ID_ULCHAR18TPM_CTY_ID
QUANTITY_ULUnderlying Quantity FTI_QUAN_ULQUAN13(3) FTR_QUAN
UOM_ULUnderlying Unit of Measure FTI_UOM_ULUNIT3Assigned to domainCUNITMEINS
DIV_PCTC_OTCPercentage of Dividend agreed for Payment in OTC Instruments TB_DIV_PCTC_OTCDEC7(4) T_DIV_PCTC_OTC
FIXING_DATEFixing date TB_DFIXDATS8DATUM
UNDERLYING 0
PAY_INFO 0
INTEREST_ADJ 0
CONDITIONS 0
FLOWS 0
ROLLOVER_PLAN 0
DIVIDEND_PLAN 0
COMMODITY_ADJ 0
SECURITY_ADJ 0

Key field Non-key field



How do I retrieve data from SAP structure TCORS_NODE_MAINDATA using ABAP code?

As TCORS_NODE_MAINDATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TCORS_NODE_MAINDATA as there is no data to select.

How to access SAP table TCORS_NODE_MAINDATA

Within an ECC or HANA version of SAP you can also view further information about TCORS_NODE_MAINDATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!