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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

142 columns | Print definition?ERP 6.0  | DUE_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD030MIItems for Class SD03 - Raw Data27DUE_DATEInvoice Due Datenvarchar80
2/1RA/0SD032MIItems for Class SD03 - Processable28DUE_DATEInvoice Due Datenvarchar80
3/1RA/0SD034MIItems for Class SD03 - Processed29DUE_DATEInvoice Due Datenvarchar80
4/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data5DUE_DATERBD: Valuation Datenvarchar80
5/IBS/TRB_ECF_PCFRBD ECF - Provision Cash Flow4DUE_DATERBD: Due Datenvarchar80
6/IBS/TRB_ECF_PCORBD ECF - Provision Collateral4DUE_DATERBD: Date, Recovery Timenvarchar80
7/IBS/TRB_ECF_PUTRBD ECF - Provision Utilization4DUE_DATERBD: Due Datenvarchar80
8/IBS/TRB_ECF_VCFRBD ECF - Value Adjustment - Cash Flow4DUE_DATERBD: Due Datenvarchar80
9/IBS/TRB_ECF_VCORBD ECF - Value Adjustment - Collateral4DUE_DATERBD: Date, Recovery Timenvarchar80
10/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data6DUE_DATERBD: Valuation Datenvarchar80
11/IBS/TRB_ECH_PCFRBD ECF - Provision History - Cash Flow5DUE_DATERBD: Due Datenvarchar80
12/IBS/TRB_ECH_PCORBD ECF - Provision History - Collateral5DUE_DATERBD: Date, Recovery Timenvarchar80
13/IBS/TRB_ECH_PUTRBD ECF - Provision History - Utilization5DUE_DATERBD: Due Datenvarchar80
14/IBS/TRB_ECH_VCFRBD ECF - Value Adjustment History - Cash Flow5DUE_DATERBD: Due Datenvarchar80
15/IBS/TRB_ECH_VCORBD ECF - Value Adjustment History - Collateral5DUE_DATERBD: Date, Recovery Timenvarchar80
16/OPT/VT_KPI_SRCSource Table for the Aggregations of the KPI Dashboard16DUE_DATEDue Datenvarchar80
17BOE_PLE_ITEMPledge item data table of BoE management25DUE_DATEPledge Due Datenvarchar80
18EHHSSD_PCI_INQUIProcess Control - Inquiry21DUE_DATETask Due Datenvarchar80
19EHHSSD_RPL_INQUIProcess Control - Mass Replace Controls - Inquiry21DUE_DATETask Due Datenvarchar80
20EHPRCD_PSI_INQUIProcess Control - Inquiry22DUE_DATETask Due Datenvarchar80
21FARR_D_INVOICEInvoice Entries9DUE_DATEInvoice Due Datenvarchar80
22FIAPPLD_INV_DATECleared Overdue Invoice Details (Poland)8DUE_DATEDue Datenvarchar80
23FIAPPTD_BALANCETable to store the Balances for Vendor/Customer/Bank Account21DUE_DATEDue Datenvarchar80
24FIAPPTD_TRANSTable to store the transaction details of the CBR PT26DUE_DATEDue Datenvarchar80
25FMSAVE_RETSave Retention Period for Archived Document12DUE_DATEDatenvarchar80
26GRFNCASEISCase table of Issue6DUE_DATEEnd Datenvarchar80
27GRFNMWRTINSTAPPLMSMP Runtime - Application Specific Attributes8DUE_DATEDue Datenvarchar80
28GRRMOBAGRUNAggregation Run9DUE_DATEAggregation Run - Due Datenvarchar80
29GRRMRESPResponse attributes4DUE_DATEResponse due datenvarchar80
30GRRMRISKCONSORGOrgnization hierarchy of Risk Consolidations6DUE_DATEDatenvarchar80
31GRRMRISKCONSPLANInfomation for one plan of risk consolidation.7DUE_DATEDatenvarchar80
32HRFPM_FM_POS_ARCArchiving Status of Financing Documents6DUE_DATEDue Datenvarchar80
33QAM_L_BCV_AQIM: Temporary Storage Activities f. Business Context Viewer16DUE_DATEDue Datenvarchar80
34THAEXT_EXPOS_COPObsolet: Commodity exposure pricing data7DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
35THAEXT_TRANS_COPCommodity exposure pricing data21DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
36THAEXT_TRAN_DCSPCommodity exposure DCS pricing data22DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
37HRT1890Table Part Infotype 18905DUE_DATEDue Datenvarchar80
TOPAccounts Receivable Accounting Process Integration
38EBPP_ORDER_PAYPayment Orders via Biller Direct: Payment Data8DUE_DATEDatenvarchar80
39FDM_INVOICE_MEMInvoice Information Provided10DUE_DATENet Due Datenvarchar80
TOPAuto-ID Infrastructure
40/AIN/DM_DOCTable with Document information.7DUE_DATEDue Datedecimal150
TOPBack Office
41TRFT_MAN_POSTManual Posting9DUE_DATEDue Datenvarchar80
TOPBasic Functions
42BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases7DUE_DATECase Due Datenvarchar80
43EMMA_CASEClarification Case23DUE_DATECase Due Datenvarchar80
TOPBusiness Objects, Common Components
44EHFNDD_PAM_AMTSSpecific Data for Amounts6DUE_DATETask Due Datenvarchar80
TOPContract Accounts Receivable and Payable
45FKK_FDT_EXPR000BFR/BPEM case expression C table8DUE_DATEOriginal Date of Clarification Casenvarchar80
46FKK_FDT_EXPR000ABFR/BPEM case expression table A8DUE_DATEOriginal Date of Clarification Casenvarchar80
47FKK_FDT_EXPR000SBFR/BPEM case expression table S7DUE_DATEOriginal Date of Clarification Casenvarchar80
48FKK_FDT_EXPR000TBFR/BPEM case expression table T7DUE_DATEOriginal Date of Clarification Casenvarchar80
TOPCorporate Performance Monitor
49UMC_TD100Task List14DUE_DATESystem Datenvarchar80
TOPCross-Application Components
50/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices18DUE_DATEDue Datenvarchar80
51/OPT/VIM_HD_NPOVIM IE Monitor: Header Data for Parked NPO Invoices21DUE_DATEDue Datenvarchar80
52/OPT/VIM_HD_POVIM IE Monitor: Header Data for Parked PO Invoices24DUE_DATEDue Datenvarchar80
TOPE-Recruiting
53HRP5135DB Table for Infotype 513521DUE_DATEDue Datenvarchar80
54HRP5136DB Table for Infotype 513621DUE_DATEDue Datenvarchar80
55HRP5137DB Table for Infotype 513721DUE_DATEDue Datenvarchar80
56HRP5138DB Table for Infotype 513821DUE_DATEDue Datenvarchar80
57HRP5139DB Table for Infotype 513921DUE_DATEDue Datenvarchar80
58HRP5140DB Table for Infotype 514021DUE_DATEDue Datenvarchar80
59HRP5141DB Table for Infotype 514121DUE_DATEDue Datenvarchar80
60HRP5142DB Table for Infotype 514221DUE_DATEDue Datenvarchar80
61HRP5143Database Table for Infotype 514321DUE_DATEDue Datenvarchar80
62HRP5144Database Table for Infotype 514421DUE_DATEDue Datenvarchar80
63HRP5145Database Table for Infotype 514521DUE_DATEDue Datenvarchar80
TOPEnvironment, Health and Safety
64/TDAG/EHSRCD_MATable for persisting TBOs of type /TDAG/CL_TBO_MA19DUE_DATEDatenvarchar80
TOPFinancial Accounting
65/OPT/VIM_1HEADDocument Header182DUE_DATEDue Datenvarchar80
TOPFunctions for U.S. Federal Government
66FMRES_INST_HISTLog of all installments created10DUE_DATEDatenvarchar80
67FMROLINEFM Recurring Obligations - schedule lines4DUE_DATESchedule due datenvarchar80
TOPGeneral
68LWMHR_D_MYM_AGNDAgenda Header7DUE_DATESystem Datenvarchar80
TOPGovernance, Risk and Compliance
69GRFNDMFPCCNDataMart: Facts PC Control21DUE_DATECases Due Datenvarchar80
70GRFNDMFPCECDataMart: Facts ELC20DUE_DATECases Due Datenvarchar80
71GRFNDMFPCSPDataMart: Facts PC Subprocess20DUE_DATECases Due Datenvarchar80
72GRFNMDCRMaster Data Change Request12DUE_DATEField of type DATSnvarchar80
73GRFNTASKPLANGRPData for task plan group27DUE_DATEDatenvarchar80
TOPGrantor Management
74GTRFIBILL_IGrantor Billing Document Items13DUE_DATEDue date for net paymentnvarchar80
TOPGRC Risk Management
75GRRMRESPONSETable for Response3DUE_DATEResponse due datenvarchar80
TOPIncentive and Commission Management ICM
76CACS00_DOCSECommission Document, Settlement10DUE_DATEDue Date of Line Itemnvarchar80
77CACS25_SESITSettlement Schedule Item13DUE_DATEDue Date of Line Itemnvarchar80
78YCRM01_DOCSECommission Document: Due Dates10DUE_DATEDue Date of Line Itemnvarchar80
79YCRM01_SESITSettlement Schedule Item13DUE_DATEDue Date of Line Itemnvarchar80
80YHITEC_DOCSECommission Document: Due Dates10DUE_DATEDue Date of Line Itemnvarchar80
81YSVMA_DOCSECommission Document: Due Dates10DUE_DATEDue Date of Line Itemnvarchar80
82YSVMA_SESITSettlement Schedule Item13DUE_DATEDue Date of Line Itemnvarchar80
83YTEL01_DOCSECommission Document: Due Dates27DUE_DATEDue Date of Line Itemnvarchar80
84YTEL05_DOCSECommission Document: Due Dates16DUE_DATEDue Date of Line Itemnvarchar80
85YTEL05_SESITSettlement Schedule Item13DUE_DATEDue Date of Line Itemnvarchar80
86ZICMAG_DOCSECommission Document: Due Dates10DUE_DATEDue Date of Line Itemnvarchar80
TOPIncident Reporting
87EHHSSD_IRT_RPTReport8DUE_DATEReport Due Datenvarchar80
TOPIncident Workflow and Tasks
88EHHSSD_PII_INQUIProcess Control - Inquiry21DUE_DATETask Due Datenvarchar80
TOPLoans Management
89VDCBR_CONTROLData Selection for Credit Bureau5DUE_DATEDue Datenvarchar80
TOPLocalization
90J1B_ERROR_DDAMaster Table for DDA_Brazil (Segment G)11DUE_DATEDue date, format DDMMYYYYnvarchar80
TOPPortfolio
91VDBILL_CONTROLBill Control7DUE_DATEDue datenvarchar80
92VDBILL_HISTBilling History12DUE_DATEDue date/calculation datenvarchar80
93VDBILL_ITEMSBilling Items10DUE_DATEPayment Datenvarchar80
94VDBILL_RES_HEADBill Results Header9DUE_DATEDue date/calculation datenvarchar80
TOPPortfolio Management
95RPM_CTEMPLATECustom Development Template6DUE_DATEDatenvarchar80
TOPPosition Budgeting and Control
96HRFPM_DIFFERENCEHRFPM: Personnel Costs Savings/ Overrun26DUE_DATEDue Datenvarchar80
97HRFPM_FM_POSHRFPM: FM Documents - Items11DUE_DATEDue Datenvarchar80
98HRFPM_FM_POS_BUHRFPM: FM Documents - Items for Budget12DUE_DATEDue Datenvarchar80
99HRFPM_FPM_POSHRFPM: FPM Documents - Items24DUE_DATEDue Datenvarchar80
100HRFPM_FPM_POS_BUHRFPM: FPM Documents - Items for Budget25DUE_DATEDue Datenvarchar80
101HRFPM_OBJECTSHRFPM: Object table of the commitment engine43DUE_DATEDue Datenvarchar80
TOPProcess Controls
102GRPCAODINFOaod infos10DUE_DATEEnd Datenvarchar80
103GRPCCAPAACTIONCorrective Actions & Preventive Actions for CAPA Plan5DUE_DATEDue Datenvarchar80
104GRPCCASEASAssessment18DUE_DATEDue Datenvarchar80
105GRPCCASECPCAPA Plan9DUE_DATEDue Datenvarchar80
106GRPCCASEISIssue22DUE_DATEEnd Datenvarchar80
107GRPCCASETLTest log27DUE_DATEDue Datenvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
108DFMCA_BRF131BRF: Parameter for Inbound Correspondence Request11DUE_DATEBRF: Expressionnvarchar200
109DFMCA_RETURNData Table for Tax Returns41DUE_DATEDue Date for Tax Returnnvarchar80
110DFMCA_RETURN_OData Table for Tax Returns44DUE_DATEDue Date for Tax Returnnvarchar80
111TFMCA_BRF216BRF: Parameter for Inbound Correspondence Request12DUE_DATEBRF: Expressionnvarchar200
TOPReceivablesPayment Management
112VDAD_HISTAuto Debits, Historical Data10DUE_DATEDue date/calculation datenvarchar80
113VDAD_RESULTResult Table for Auto Debit Collection5DUE_DATEDue datenvarchar80
TOPRights
114CMS_RIGCMS: Rights table. Includes claims, patents, other rights.19DUE_DATEDue date of a claimnvarchar80
TOPSocial Services and Social Security
115PSSCD_GPDITEMGross Payment Docment Item Data26DUE_DATEDue Datenvarchar80
116PSSCD_NCDNet Calculation Document Header Data11DUE_DATEDue Datenvarchar80
TOPTransaction Manager
117SLDT_FLOWSubledger Distributor Transactions53DUE_DATEDue Datenvarchar80
118TCORT_COSAFLSecurity Account Transfer: Flows17DUE_DATEDue datenvarchar80
119TEMT_RAWEXPOSRaw Exposure8DUE_DATEDate to Which Exposure Refersnvarchar80
120TEMT_VERSEXPOSVersioned Exposure9DUE_DATEDate to Which Exposure Refersnvarchar80
121TEXT_POSITIONSExposure Positions28DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
122TEXT_POS_FLOWExposure Position Flows27DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
123TEXT_REXP_ITEMRaw Exposure Item8DUE_DATEDate on Which Exposure Is Due / Expiresnvarchar80
124TEXT_TRANSACTIONUnmatched Exposure Business Transactions27DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80
125TRDT_FLOWPersistent distributor flows51DUE_DATEDue Datenvarchar80
TOPTransfer to Financial Accounting
126TRLT_FLOWTreasury Ledger Flows22DUE_DATEDue Datenvarchar80
TOPTreasury and Risk Management
127TREAT_FLOWTreasury: TREA Flows33DUE_DATEDue Datenvarchar80
TOPValue Adjustment
128/IBS/TRB_GUIDKVVRBD: GUID Table Key fields of Contract21DUE_DATERBD: Valuation Datenvarchar80
129/IBS/TRB_KVVRBD Assignment RBD Account - Contract Source System21DUE_DATERBD: Valuation Datenvarchar80
130/IBS/TRB_SCHISTRBD IAS - History Value Adjustment Collateral5DUE_DATERBD: Date, Recovery Timenvarchar80
131/IBS/TRB_SCHISTRRBD IAS - History Provision Collaterals5DUE_DATERBD: Date, Recovery Timenvarchar80
132/IBS/TRB_SHCOLRBD IAS - Value Adjustment Collateral4DUE_DATERBD: Date, Recovery Timenvarchar80
133/IBS/TRB_SHCOL_RRBD IAS - Provision Collaterals4DUE_DATERBD: Date, Recovery Timenvarchar80
134/IBS/TRB_SHEETRBD IAS - Value Adjustment Cash Flow Positions4DUE_DATERBD: Due Datenvarchar80
135/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet5DUE_DATERBD: Valuation Datenvarchar80
136/IBS/TRB_SHEET_IRBD IAS - Provision Utilization4DUE_DATERBD: Due Datenvarchar80
137/IBS/TRB_SHEET_RRBD IAS - Provision Cash Flow Positions4DUE_DATERBD: Due Datenvarchar80
138/IBS/TRB_SHISTRBD IAS - History Value Adjustment Cash Flow Positions5DUE_DATERBD: Due Datenvarchar80
139/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet6DUE_DATERBD: Valuation Datenvarchar80
140/IBS/TRB_SHIST_IRBD IAS - History Provision Utilization5DUE_DATERBD: Due Datenvarchar80
141/IBS/TRB_SHIST_RRBD IAS - History Provision Cash Flow Positions5DUE_DATERBD: Due Datenvarchar80
TOPWorkflows and Tasks for Risk Assessment
142EHHSSD_EVL_INQUIProcess Control - Inquiry21DUE_DATETask Due Datenvarchar80