SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | TCORT_CO
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCORT_CO8410Correspondence Administrative DataTransaction Manager
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, CO_UUID, CO_KEY, CODMD_UUID, COSA_UUID, COMPANY_CODE, DEALNUMBER, BUSTRANSID, BUSTRANSCAT, SEC_ACC, SECURITYID, PRODUCTTYPE, TRANSACTIONTYPE, ACTIVITY, ACTIVITYCAT, SFUNKTL, PARTNR, BPGROUP, PROFILE, RECIPIENT_TYPE, RECIPIENT, FUNCTION, CHANNEL, MESSAGE_FORMAT, DIRECTION, OPERATION, REF_CO_KEY, STATUS_GUID, IS_AUTO_CORR, IS_REL_REQD, IS_STATUS_REL, IS_CTRCONF_REQD, IS_AUTO_COMPLETE, IS_UPD_EXT_REF, IS_MANUAL, IS_ACK_REL, IS_RESENT, RECONCILE, SET_DELIVERY, CRUSER, DCRDAT, TCRTIM, UPUSER, DUPDAT, TUPTIM, EXEC_DATE, EXEC_TIME, EXEC_USER, DELV_DATE, DELV_TIME, DELV_USER, RECON_DATE, RECON_TIME, RECON_USER, MTCH_DATE, MTCH_TIME, MTCH_USER, RECV_DATE, RECV_TIME, RECV_USER, MATCH_ID, CO_INT_REF, CO_EXT_REF, IS_COMPLETE, IS_MANUAL_CHNG, MSG_STATUS, MSG_REASON, ERROR_CODE, ERROR_TEXT, ERROR_LINE, CORR_COUNTRY, CORR_LANGUAGE, CORPACT_IND, ADR_COUNTRY, FAX_NO, EMAIL_ADD, SENT_FOR_MATCH, LOG_HANDLE, CORR_ADDTYPE, SAP_USER, IS_AUTOMATCH_OUT, IS_DEAL_REL_REQ, IS_CTRCNF_MAN, ASSIGN_REASON FROM TCORT_CO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CO_UUIDCorrespondence Object UUIDvarbinary160RAWNoFTR_COID
3CO_KEYSemantic key for Corrnvarchar160CHAR(N' ')YesFTR_CO_KEY Allow NULL? 
4CODMD_UUIDCorrespondence Object Deal's main data UUIDvarbinary160RAWYesFTR_CODMDID
5COSA_UUIDCO: Securities account main data idvarbinary160RAWYesFTR_COSAID
6COMPANY_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
7DEALNUMBERFinancial Transactionnvarchar130CHAR(N' ')Yes*TB_RFHA Allow NULL? 
8BUSTRANSIDIdentifier of the Distributor Business Transactionvarbinary160RAWYesTPM_BUSTRANSID
9BUSTRANSCATBusiness Transaction Categorynvarchar40NUMC(N'0000')Yes*TPM_BUSTRANSCAT Allow NULL? 
10SEC_ACCSecurities Accountnvarchar100CHAR(N' ')Yes*VRLDEPO Allow NULL? 
11SECURITYIDSecurity ID Numbernvarchar130CHAR(N' ')Yes*VVRANLW Allow NULL? 
12PRODUCTTYPEProduct Typenvarchar30CHAR(N' ')Yes*VVSART Allow NULL? 
13TRANSACTIONTYPEFinancial Transaction Typenvarchar30CHAR(N' ')Yes*TB_SFHAART Allow NULL? 
14ACTIVITYTransaction activitynvarchar50NUMC(N'00000')YesTB_RFHAZU Allow NULL? 
15ACTIVITYCATTransaction Activity Categorynvarchar20NUMC(N'00')Yes*TB_SFGZUTY Allow NULL? 
16SFUNKTLLatest function used in editing activitynvarchar40CHAR(N' ')Yes*TB_SFUNKTL Allow NULL? 
17PARTNRBusiness Partner Numbernvarchar100CHAR(N' ')YesBUT000BP_PARTNR_NEW Allow NULL? 
18BPGROUPBusiness Partner Group IDnvarchar150CHAR(N' ')YesTCORC_BUSGRPFTR_BPGRP Allow NULL? 
19PROFILECorrespondence Profilenvarchar150CHAR(N' ')YesTCORFC_PROFILEFTR_PROFILE Allow NULL? 
20RECIPIENT_TYPERecipient/Sender Typenvarchar150CHAR(N' ')YesTCORFC_REC_TYPEFTR_RECIPIENT_TYPE Allow NULL? 
21RECIPIENTCorrespondence Recipientnvarchar100CHAR(N' ')YesFTR_RECIPIENT Allow NULL? 
22FUNCTIONCorrespondence Classnvarchar150CHAR(N' ')YesTCORFC_FUNCTIONFTR_FUNCTION Allow NULL? 
23CHANNELCorrespondence Channelnvarchar150CHAR(N' ')YesTCORFTS_CHANNELFTR_CHANNEL Allow NULL? 
24MESSAGE_FORMATFormatnvarchar150CHAR(N' ')YesTCORFTS_FORMATFTR_FORMAT Allow NULL? 
25DIRECTIONDirection of correspondencechar10CHAR(N' ')YesFTR_CODIR Allow NULL? 
26OPERATIONOperation causing the creation of COnvarchar40CHAR(N' ')YesFTR_OPER Allow NULL? 
27REF_CO_KEYReference CO keynvarchar160CHAR(N' ')YesFTR_REFCOID Allow NULL? 
28STATUS_GUIDTCO Status Object Idvarbinary160RAWYesFTR_STATUS_OBJID
29IS_AUTO_CORRAuto Correspondence Required?char10CHAR(N' ')YesFTR_AUTO_CORR_FLG Allow NULL? 
30IS_REL_REQDRelease Required?char10CHAR(N' ')YesFTR_REL_FLG Allow NULL? 
31IS_STATUS_RELDeal Status Relevant?char10CHAR(N' ')YesFTR_STAT_REL_FLG Allow NULL? 
32IS_CTRCONF_REQDCounter Confirmation Required?char10CHAR(N' ')YesFTR_CTRCONF_FLG Allow NULL? 
33IS_AUTO_COMPLETEAutomatic completion required?char10CHAR(N' ')YesFTR_AUTOCOMP Allow NULL? 
34IS_UPD_EXT_REFGet values from counterconfirmationchar10CHAR(N' ')YesFTR_UPD_EXTREF Allow NULL? 
35IS_MANUAL'Is CO manually created' indicatorchar10CHAR(N' ')YesFTR_MANUAL_FLG Allow NULL? 
36IS_ACK_RELIndicator: Is Acknowledgement Relevant?char10CHAR(N' ')YesFTR_ACK_FLAG Allow NULL? 
37IS_RESENTFlag: Is CO resentchar10CHAR(N' ')YesFTR_RESENT_FLAG Allow NULL? 
38RECONCILEReconcilechar10CHAR(N' ')YesFTR_RECONCILE Allow NULL? 
39SET_DELIVERYPhysical Deliverychar10CHAR(N' ')YesFTR_PHYDEL_IND Allow NULL? 
40CRUSEREntered bynvarchar120CHAR(N' ')Yes*FTR_CRUSER Allow NULL? 
41DCRDATEntered Onnvarchar80DATS(N'00000000')YesTB_DCRDAT Allow NULL? 
42TCRTIMEntry Timenvarchar60TIMS(N'000000')YesTB_TCRTIM Allow NULL? 
43UPUSERLast Changed bynvarchar120CHAR(N' ')Yes*FTR_UPUSER Allow NULL? 
44DUPDATChanged onnvarchar80DATS(N'00000000')YesTB_DUPDAT Allow NULL? 
45TUPTIMTime changednvarchar60TIMS(N'000000')YesTB_TUPTIM Allow NULL? 
46EXEC_DATEOutgoing Correspondence Execution Datenvarchar80DATS(N'00000000')YesFTR_EXEC_DATE Allow NULL? 
47EXEC_TIMEOutgoing Correspondence Execution Timenvarchar60TIMS(N'000000')YesFTR_EXEC_TIME Allow NULL? 
48EXEC_USEROutgoing Correspondence Executed by Usernvarchar120CHAR(N' ')Yes*FTR_EXEC_USER Allow NULL? 
49DELV_DATEOutgoing correspondence delivery datenvarchar80DATS(N'00000000')YesFTR_DELV_DATE Allow NULL? 
50DELV_TIMEOutgoing correspondence delivery timenvarchar60TIMS(N'000000')YesFTR_DELV_TIME Allow NULL? 
51DELV_USEROutgoing correspondence delivered by usernvarchar120CHAR(N' ')Yes*FTR_DELV_USER Allow NULL? 
52RECON_DATEOutgoing correspondence counter-confirmed datenvarchar80DATS(N'00000000')YesFTR_RECON_DATE Allow NULL? 
53RECON_TIMEOutgoing correspondence counter-confirmed timenvarchar60TIMS(N'000000')YesFTR_RECON_TIME Allow NULL? 
54RECON_USEROutgoing correspondence counter-confirmed by usernvarchar120CHAR(N' ')Yes*FTR_RECON_USER Allow NULL? 
55MTCH_DATECorrespondence object matched datenvarchar80DATS(N'00000000')YesFTR_MTCH_DATE Allow NULL? 
56MTCH_TIMECorrespondence object matched timenvarchar60TIMS(N'000000')YesFTR_MTCH_TIME Allow NULL? 
57MTCH_USERCorrespondence object matched by usernvarchar120CHAR(N' ')Yes*FTR_MTCH_USER Allow NULL? 
58RECV_DATECorrespondence object received datenvarchar80DATS(N'00000000')YesFTR_RECV_DATE Allow NULL? 
59RECV_TIMECorrespondence Object Receipt Timenvarchar60TIMS(N'000000')YesFTR_RECV_TIME Allow NULL? 
60RECV_USERCorrespondence object received by usernvarchar120CHAR(N' ')Yes*FTR_RECV_USER Allow NULL? 
61MATCH_IDTCOR: Match Id (Number range: FTRN_MATCH)nvarchar160CHAR(N' ')Yes*FTR_MATCH_ID Allow NULL? 
62CO_INT_REFCorrespondence internal referencenvarchar160CHAR(N' ')YesFTR_INT_REF Allow NULL? 
63CO_EXT_REFCorrespondence external referencenvarchar160CHAR(N' ')YesFTR_EXT_REF Allow NULL? 
64IS_COMPLETEIs Correspondence Object completechar10CHAR(N' ')YesFTR_COMPLETE Allow NULL? 
65IS_MANUAL_CHNGIs CO manually changedchar10CHAR(N' ')YesFTR_MANUAL_CHNG Allow NULL? 
66MSG_STATUSMessage status (Filled by customer)nvarchar160CHAR(N' ')YesFTR_MSG_STATUS Allow NULL? 
67MSG_REASONReason for message status (Filled by customer)nvarchar160CHAR(N' ')YesFTR_MSG_REASON Allow NULL? 
68ERROR_CODEError codenvarchar30CHAR(N' ')YesFTR_ERROR_CODE Allow NULL? 
69ERROR_TEXTError textnvarchar300CHAR(N' ')YesFTR_ERROR_TEXT Allow NULL? 
70ERROR_LINEError line numbernvarchar30CHAR(N' ')YesFTR_ERROR_LINE Allow NULL? 
71CORR_COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
72CORR_LANGUAGELanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
73CORPACT_INDCorporate action event indicatornvarchar40CHAR(N' ')YesFTR_CORP_ACTION Allow NULL? 
74ADR_COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1_GP Allow NULL? 
75FAX_NOBusiness partner fax numbernvarchar310CHAR(N' ')YesTB_KOTELFX Allow NULL? 
76EMAIL_ADDE-Mail Addressnvarchar2410CHAR(N' ')YesAD_SMTPADR Allow NULL? 
77SENT_FOR_MATCHIndicator : Is Correspondence Sent For Match?char10CHAR(N' ')YesFTR_SENT_FOR_MATCH Allow NULL? 
78LOG_HANDLEApplication Log: Log Handlenvarchar220CHAR(N' ')YesBALLOGHNDL Allow NULL? 
79CORR_ADDTYPEAlternative Address for Correspondencenvarchar100CHAR(N' ')Yes*TB_CORR_AD_NEW Allow NULL? 
80SAP_USERUser Name in User Master Recordnvarchar120CHAR(N' ')Yes*XUBNAME Allow NULL? 
81IS_AUTOMATCH_OUTAuto. Matching Triggered on Delivery of Outbound Corresp.char10CHAR(N' ')YesFTR_AUTOMATCH_O Allow NULL? 
82IS_DEAL_REL_REQDo Not Send Before Deal Releasechar10CHAR(N' ')YesFTR_DEAL_REL_FLG Allow NULL? 
83IS_CTRCNF_MANIs correspondence counterconfirmed manually?char10CHAR(N' ')YesFTR_CTRCNF_MAN Allow NULL? 
84ASSIGN_REASONReason for Assignmentnvarchar20CHAR(N' ')YesFTR_ASSIGNMENT_REASON Allow NULL? 
NamePrimaryUniqueTypeColumns
TCORT_CO~0YesYesCLUSTEREDCO_UUID, MANDT
TCORT_CO~I10NoNoNONCLUSTEREDCO_EXT_REF, MANDT
TCORT_CO~ID1NoNoNONCLUSTEREDBUSTRANSID, MANDT
TCORT_CO~ID2NoNoNONCLUSTEREDMATCH_ID, MANDT
TCORT_CO~ID3NoNoNONCLUSTEREDCO_INT_REF, MANDT
TCORT_CO~ID4NoNoNONCLUSTEREDCO_KEY, MANDT
TCORT_CO~ID5NoNoNONCLUSTEREDIS_COMPLETE, MANDT
TCORT_CO~ID7NoNoNONCLUSTEREDCOMPANY_CODE, MANDT
TCORT_CO~ID8NoNoNONCLUSTEREDDEALNUMBER, MANDT
TCORT_CO~ID9NoNoNONCLUSTEREDSEC_ACC, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy