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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

139 columns | Print definition?ERP 6.0  | COMP_CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/XXFI_TCJSettings for Cash Journal2COMP_CODECompany Codenvarchar40
2/CCEE/XX_SET_LOCLocalization Settings2COMP_CODECompany Codenvarchar40
3/GBT/O_MDOC_ITMMaterial Document Item for Tracking20COMP_CODECompany Codenvarchar40
4/GBT/O_PURO_ITMPurchasing Document Item for Tracking15COMP_CODECompany Codenvarchar40
5/OPT/APPR_COAApproval COA2COMP_CODECompany Codenvarchar40
6/SAPPSSRM/C_UFDIncremental Funding: Customizing for the Unfunded Acctg Line2COMP_CODECompany Codenvarchar40
7/SAPPSSRM/IF_CCIBU PS: Incremental Funding - Active Comp Codes & Obj Types2COMP_CODECompany Codenvarchar40
8/SAPPSSRM/IF_CCTIBU PS: Company Code Descriptions for Incremental Funding2COMP_CODECompany Codenvarchar40
9/SAPPSSRM/IF_PTYIBU PS: Incremental Funding Process Types2COMP_CODECompany Codenvarchar40
10BBP_PCACCProcurement Card: Accounting Data5COMP_CODECompany Codenvarchar40
11BBP_PCIACAccounting Data for Procurement Card Company3COMP_CODECompany Codenvarchar40
12BBP_PCMASProcurement Card Master Data22COMP_CODECompany Codenvarchar40
13BBP_PCMODProcurement Card: Modified Statement Data7COMP_CODECompany Codenvarchar40
14BBP_USR01Internet user data36COMP_CODECompany Codenvarchar40
15CFAFOIACT_DETL_2FO Integration: Selection of Details (Risk Category)4COMP_CODECompany Codenvarchar40
16CNV_20200_CAJODifferences in cash journal master data6COMP_CODECompany Codenvarchar40
17CNV_20200_CJPOSTCash journal master - do postings exist per company code6COMP_CODECompany Codenvarchar40
18CNV_20200_CJTRDifferences in cash journal business transactions6COMP_CODECompany Codenvarchar40
19CNV_20200_CJTR1Merge of cash journal business transactions (identic. sett.)6COMP_CODECompany Codenvarchar40
20EEWA_CJOURN_USERAssignment of Cash Journal to User5COMP_CODECompany Codenvarchar40
21EWA_WA_WEIGHPC_BInformation Relevant for Payment Process5COMP_CODECompany Codenvarchar40
22J_1I_BANK_MASTEREXIM: Bank Master2COMP_CODECompany Codenvarchar40
23LWM_CFS_MSGMT_CCFinFactSheet - Assignment of Company Codes to Groups3COMP_CODECompany Codenvarchar40
TOPAccounts Receivable Accounting Process Integration
24FDM_INVOICE_ACTProvision of Invoice Information: Active Procedure2COMP_CODECompany Codenvarchar40
25FDM_INVOICE_MEMInvoice Information Provided2COMP_CODECompany Codenvarchar40
26FDM_INV_MEM_OBSInvoice Information Provided Obsolete2COMP_CODECompany Codenvarchar40
TOPActual Update and Commitment Update
27GTRRULE_ASSIGNGTR Multi-Funding Rules Assignment To CRM Objects4COMP_CODECompany Codenvarchar40
TOPBack Office
28TRST_RECON_RCETreasury: External Securities Account Statement3COMP_CODECompany Codenvarchar40
TOPBank Accounting
29TCJ_BALANCEFI Cash Journal: Totals Records2COMP_CODECompany Codenvarchar40
TOPBasic Functions
30ETXDCHExternal tax document: header info22COMP_CODECompany code using tax interfacenvarchar40
31TTXUExternal tax interface: Audit file update information2COMP_CODECompany Codenvarchar40
32TTXYExternal tax interface: tax information9COMP_CODECompany Codenvarchar40
TOPBasis Components
33/XFT/INV_QInvoice receipt queue: Header41COMP_CODECompany Codenvarchar40
34/XFT/INV_Q_SInvoice receipt queue: Header41COMP_CODECompany Codenvarchar40
TOPBudgeting and Availability Control
35GMAVCLDGRACTActivation of availability ledger for Grants Management2COMP_CODECompany Codenvarchar40
TOPCollateral Management System
36TCMS_IFL_MORGOrganisation units and company codes3COMP_CODECompany Codenvarchar40
37TCMS_IFL_MORGUOrganisation units and company codes2COMP_CODECompany Codenvarchar40
TOPCollections Management
38UDM_COLL_BI_DELDeleted Collection Items (memorized for BI)2COMP_CODECompany Codenvarchar40
39UDM_COLL_ITEMOpen Items3COMP_CODECompany Codenvarchar40
40UDM_COLL_ITEMCASOpen Items with Dispute Case3COMP_CODECompany Codenvarchar40
41UDM_COLL_KEYFIGBusiness Partner Key Figures3COMP_CODECompany Codenvarchar40
42UDM_COLL_LASTPAYLast Payments of Business Partner3COMP_CODECompany Codenvarchar40
43UDM_COMPCODE_MAPAssignment of FI Company Code to Collection Company Code2COMP_CODECompany Codenvarchar40
44UDM_COMP_CODECompany Codes in Collections Management2COMP_CODECompany Codenvarchar40
45UDM_SGMT_COMPAssignment of Company Code in Collections Mgt - Segment3COMP_CODECompany Codenvarchar40
TOPCross-Application Components
46/OPT/S_INV_HDRVSS Staging Table: Invoice Header18COMP_CODECompany Codenvarchar40
47/OPT/S_INV_LINVSS Staging Table: Invoice lines6COMP_CODECompany Codenvarchar40
48/OPT/S_PAYMENTVSS Staging Table: Payment18COMP_CODECompany Codenvarchar40
49/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices3COMP_CODECompany Codenvarchar40
50/OPT/VPR_PARTNERPartners for Registered Vendor4COMP_CODECompany Codenvarchar40
TOPData Retention Tool
51TXW_INDEXTemporary table for data segment index2COMP_CODECompany Codenvarchar40
52TXW_INDEX_01Temporary table for data segment index2COMP_CODECompany Codenvarchar40
53TXW_INDEX_02Temporary table for data segment index2COMP_CODECompany Codenvarchar40
54TXW_INDEX_03Temporary table for data segment index2COMP_CODECompany Codenvarchar40
55TXW_INDEX_04Temporary table for data segment index2COMP_CODECompany Codenvarchar40
56TXW_INDEX_05Temporary table for data segment index2COMP_CODECompany Codenvarchar40
TOPDefault Risk and Limit System
57LMSDCIACTIntegrated Limit Check in CFM: Activation3COMP_CODECompany Codenvarchar40
TOPDepreciation Simulation
58IMCCIM Summarization: Characteristics that are master data11COMP_CODECompany Codenvarchar40
TOPDistributor-Reseller-Management
59/SAPHT/DRMDETLDRM Audit Trail38COMP_CODECompany Codenvarchar40
60/SAPHT/DRMR3XNDRM relevant ERP Transactions7COMP_CODECompany Codenvarchar40
TOPDSD Connector
61/DSD/ME_CLR_HDDSD CN: Clearing header data9COMP_CODEDSD Connector: Company codenvarchar40
62/DSD/ME_CUST_HDDSD CN: Customer Details56COMP_CODEDSD Connector: Company codenvarchar40
TOPFunctions for U.S. Federal Government
63FMFG_BL_YRCLCustomizing Budgetary Ledger Year End closing2COMP_CODECompany Codenvarchar40
64FMFG_BL_YRCL_TOPCustomizing Budgetary Ledger Year End Multiple Closing Rules2COMP_CODECompany Codenvarchar40
65FMFG_BL_YRCL_TXTMultiple Closing Rule Texts3COMP_CODECompany Codenvarchar40
66FMFG_BUTYPEBudgetary ledger Attributes of the budget type2COMP_CODECompany Codenvarchar40
67FMFG_YE_FLGCollect fields2COMP_CODECompany Codenvarchar40
TOPFund Accounting
68FMCCAVCLDGRACTActivation of control ledger for Cash Control2COMP_CODECompany Codenvarchar40
TOPFunds Management
69FMBLPSTNGFM BL posting customizing for GL line-items collection3COMP_CODECompany Codenvarchar40
70FMBUDACLRules for Closing Residual Ledger Accounts2COMP_CODECompany Codenvarchar40
71FMBUDBCSBudgetary ledger account derivation: BCS4COMP_CODECompany Codenvarchar40
72FMBUDDISBudgetary ledger account derivation: Budgeting (old)4COMP_CODECompany Codenvarchar40
73FMBUDRESBudgetary ledger account derivation: Revenue/Statistical4COMP_CODECompany Codenvarchar40
74FMBUDREVRevenue/Statistical Postings & Open items/actuals Resource4COMP_CODECompany Codenvarchar40
75FMBUDSTABudgetary ledger account derivation: Open items/Actuals bdgt4COMP_CODECompany Codenvarchar40
76FMDERIVEENVIDAssignment Company Code to Derivation Tool Strategy5COMP_CODECompany Codenvarchar40
77FMFG_BL_BALACCBudgetary Ledger balancing account for document split2COMP_CODECompany Codenvarchar40
78FMFG_HEAD_INVHeader Data for Improper Invoices4COMP_CODECompany Codenvarchar40
TOPGeneral Ledger Accounting
79FAGL_VAL_COCODEAllocation to company code5COMP_CODECompany Codenvarchar40
80FAGL_VAL_LEDGRAssignment to Ledger Group5COMP_CODECompany Codenvarchar40
TOPGL Account Posting
81TCJ_CHECK_STACKSCheck Lists in Cash Journal2COMP_CODECompany Codenvarchar40
82TCJ_CJ_NAMESCash Journal Names3COMP_CODECompany Codenvarchar40
83TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items2COMP_CODECompany Codenvarchar40
84TCJ_C_JOURNALSCash Journals2COMP_CODECompany Codenvarchar40
85TCJ_DOCUMENTSCash Journal Documents (Header Data)2COMP_CODECompany Codenvarchar40
86TCJ_MAX_AMOUNTCash Journal: Amount Limit2COMP_CODECompany Codenvarchar40
87TCJ_POSITIONSCash Journal Document Items2COMP_CODECompany Codenvarchar40
88TCJ_TRANSACTIONSCash Journal Business Transactions2COMP_CODECompany Codenvarchar40
89TCJ_TRANS_NAMESCash Journal Business Transaction Names2COMP_CODECompany Codenvarchar40
90TCJ_WTAX_ITEMSWithholding Tax Items for Cash Journal Document Items2COMP_CODECompany Codenvarchar40
TOPGL transfer
91TBKKC_BUKRSBCA Locally Duplicated Values for Corresponding FI2COMP_CODECompany Codenvarchar40
TOPGrantor Management
92GTRFIAPARGrantor: FI AP/AR related data2COMP_CODECompany Codenvarchar40
93GTRFIAPARDOCGrantor: FI AP/AR related data - Payment Type - Doc Type2COMP_CODECompany Codenvarchar40
94GTRFIBILL_HHeader of Grantor FI AP/AR Billing Doc8COMP_CODECompany Codenvarchar40
TOPIncentive and Commission Management ICM
95CACSCD_ACSCDAccount Assignment of Stt.Types for FS-CD Settlement System5COMP_CODECompany Codenvarchar40
96CACSCD_DOCCD_HDSettlement to FS-CD: Reference Document Header5COMP_CODECompany Codenvarchar40
97CACSFA_ACRFAAccount Assignments of Remun.Types for FI-CA settlement5COMP_CODECompany Codenvarchar40
98CACSFA_ACSFAAccount Assignment of Stt.Types for FI-CA Settlement System5COMP_CODECompany Codenvarchar40
99CACSFA_DOCFA_HDSettlement to FI-CA: Reference Document Header5COMP_CODECompany Codenvarchar40
100CACSFI_DOCFI_HDSettlement to FI: Reference Document Header8COMP_CODECompany Codenvarchar40
101CACSNO_NO_ACSFIAccount Assignments Notification Rules FI4COMP_CODECompany Codenvarchar40
102YCRM01_DOCFI_HData Transfer: FI Documents Header Data5COMP_CODECompany Codenvarchar40
103YSVMA_ACCASAccount Assignment Type/Cost Information for Remuneration9COMP_CODECompany Codenvarchar40
104YSVMA_ACCSTAccount Assignment Type/Cost Info for Settlement Types6COMP_CODECompany Codenvarchar40
105YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration5COMP_CODECompany Codenvarchar40
TOPLoans Management
106TDCO_USER_TEXTDefinition of Custom Text for Correspondence Tool10COMP_CODERelational Operatornvarchar20
107TDORGUNITField Catalog - Organizational Unit2COMP_CODECompany Codenvarchar40
108TDPRODPROFILEField Catalog - Assignment of Profiles to Products5COMP_CODECompany Codenvarchar40
TOPPayment Transactions
109TFIBLAPARPVAROnline Payment: Variants9COMP_CODECompany Codenvarchar40
110TFIBLFFPVAROnline Payment: Variants9COMP_CODECompany Codenvarchar40
TOPPersonnel Time Management
111PTARQ_EXTRA_INFOLeave Request: Additional Fields for Attendances/Absences5COMP_CODECompany codenvarchar40
TOPProcurement for Public Sector
112/SAPPSPRO/IF_CCIBU-PS: Incremntl Fundng - Active Comp Codes & Purch Doc Cat2COMP_CODECompany Codenvarchar40
113/SAPPSPRO/IF_DTIBU-PS: Incremental Funding Purchasing Document Types2COMP_CODECompany Codenvarchar40
114/SAPPSPRO/IF_THIncremental Funding: Customizing for GR/IR Thresholds2COMP_CODECompany Codenvarchar40
TOPProfit Center Accounting
115PCA_SCMOIndex from Schedule Manager Run to Corresponding Extracts4COMP_CODECompany Codenvarchar40
TOPRegulatory reporting for insurance companies
116ISSR_BASI_RGRegistrierungseintrag5COMP_CODEBuchungskreisnvarchar40
117ISSR_BASI_RGDONEErledigter Registrierungseintrag5COMP_CODEBuchungskreisnvarchar40
TOPRisk Analysis
118CFAFOIACTFO Integration - Activation4COMP_CODECompany Codenvarchar40
119CFAFOIACT_DETAILFO Integration: Selection of Details4COMP_CODECompany Codenvarchar40
120CFAFOIACT_DETL_1FO Integration: Selection of Details (Valuation Area)4COMP_CODECompany Codenvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
121TNNLCLRUAbschließ regeln6COMP_CODEAbschließ Komponent codenvarchar60
TOPSAP Retail Store
122WOSCR_CBL_COCODECash Balancing: Settings for Each Company Code2COMP_CODECompany Codenvarchar40
123WOSCR_EXI_COCODEVendor Invoice - Assignment for Each Company Code2COMP_CODECompany Codenvarchar40
TOPService Station Retailing
124OIRE_CCODE_CRComplaint Result Handling2COMP_CODECompany Codenvarchar40
TOPStandard Dialogs
125SVALTTest Data for POPUP_GET_VALUES...7COMP_CODERelational Operatornvarchar20
TOPSupply Chain Management
126TCM_C_PUR_MAPMapping TM Organizational Unit to Purchasing Organisation7COMP_CODECompany Codenvarchar40
127TCM_ORG_INO_MAPMapping TCM Organizational Units -> Account Assignment obj4COMP_CODECompany Codenvarchar40
128TCM_ORG_PUR_MAPMapping TCM Organizational unit to purchasing organisation5COMP_CODECompany Codenvarchar40
129TCM_PUR_ORG_MAPMapping TCM Organizational unit to purchasing organisation5COMP_CODECompany Codenvarchar40
TOPTransaction Manager
130TCORT_COSASecurity Account Transfer: Main Data3COMP_CODECO: Company codenvarchar40
TOPTransaction Tax Engine
131TTEPD3_USITEMPersistency TTE Document UsItem4COMP_CODECompany Codenvarchar40
132TTEPDT_USITEMPersistency TTE Document UsItem4COMP_CODECompany Codenvarchar40
133TTESDT_USITEMOutput Exemptions4COMP_CODECompany Codenvarchar40
TOPTravel Expenses
134PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved13COMP_CODECompany Codenvarchar40
135PTRV_REASGN_FMConversion of FM Data in Trip (e.g. Fiscal Year Change)17COMP_CODECompany Codenvarchar40
136PTRV_SCOSTrip Statistics - Cost Assignment6COMP_CODECompany Codenvarchar40
TOPTreasury
137TTXADUser data fields per document11COMP_CODERelational Operatornvarchar20
TOPUS Prompt Payment Act
138FMFG_REASONSReason Codes for Accounting Documents (Item Level)4COMP_CODECompany Codenvarchar40
TOPVehicle Management System
139VLCBATCHACTVELO : Variant for Action Execution in Batch4COMP_CODECompany Codenvarchar40