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

57 columns | Print definition?ERP 6.0  | SSIGN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1IDCFM_ICLTXFLDIRFlow Types for Tax Types with Sign6SSIGNDirection of flownvarchar10
2JBRDBCOMBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction30SSIGNDirection of flownvarchar10
3JBRHCOMBEWEGhRM: Version Table BEWEG for Extended Cat. of Primary Trans.31SSIGNDirection of flownvarchar10
4JBRSVCOMBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets31SSIGNDirection of flownvarchar10
5NWS_EXT_SVALUEData Transport Management Tool SELECT OPTIONS, Values12SSIGNSelection Criteria: SIGNnvarchar10
6VDSEPA_MND_USGOverview of mandates used in Loans Management13SSIGNDirection of flownvarchar10
TOPBasic Functions
7FDT1CMF Line Items for Forex, Money Market, Derivatives9SSIGNDirection of flownvarchar10
TOPBusiness Partner
8VTBSTA1Allocation of Payment Details as Standing Instructions9SSIGNDirection of flownvarchar10
TOPData Transfer
9KCD_TYPUBAExternal Data Transfer: Type Used By Application (TYPUBA)3SSIGNExternal data transfer: signs: +, - and *nvarchar10
TOPGermany
10TZA11RValues for classifying appendices acc. to R96/114SSIGNSelection signnvarchar10
11TZA11R1Values for Classifying Appendix 10 According to R5/974SSIGNSelection signnvarchar10
12TZR96Circular R5/97 Control Table for Report Program RFVZBR003SSIGNSelection signnvarchar10
TOPLoans Management
13TTONFTVZZBEPPTest neue FIMA: VZZBEPP246SSIGNRichtung der Bewegungnvarchar10
14VDBEDSelection conditions for loans10SSIGNSelection signnvarchar10
15VDBEPIPosted line items for document header132SSIGNDirection of flownvarchar10
16VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)132SSIGNDirection of flownvarchar10
17VDBEPPFlow Data - Planned Item156SSIGNDirection of flownvarchar10
18VDBOBEPPBusiness Operation: Entered and Activated Flow Data156SSIGNDirection of flownvarchar10
19VDZVPayment Details for the Loan4SSIGNDirection of flownvarchar10
20VZFZE_VDBEPPCentral Entry Table for Release Procedure159SSIGNDirection of flownvarchar10
TOPOrganizational Management
21T77PRDefinition of Authorization Profiles10SSIGNSignnvarchar10
TOPPatient Accounting
22NLGRIS-H: Dynamic Service Groups10SSIGNIS-H: Indicator whether entered values are to be selectednvarchar10
TOPReal Estate Management
23TIV04Repr.list of rents surcharge/reductions features16SSIGNResidential value sign for fixt./fitt.charact. of RUsnvarchar10
TOPRisk Analysis
24JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction7SSIGNDirection of flownvarchar10
25JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.8SSIGNDirection of flownvarchar10
26JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets8SSIGNDirection of flownvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
27/ISHFR/TNWFR_CCPIS-H FR: Coordinated Care Path7SSIGNIS-H: Indicator whether entered values are to be selectednvarchar10
28/ISHFR/TNWFR_F10IS-H FR: Per Diem Fee11SSIGNIS-H: Indicator whether entered values are to be selectednvarchar10
29TNWCHKTRGRIS-H CH: Dynamische Kostenträgergruppen11SSIGNIS-H: Kz., ob angegebene Werte selektiert werden sollennvarchar10
TOPTransaction Management
30TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table7SSIGNDirection of flownvarchar10
TOPTransaction Manager
31AT13UFlow types for transfer posting for activity transition7SSIGNDirection of flownvarchar10
32ATFTACFM: Assign Transaction Flow Type to Update Type4SSIGNDirection of flownvarchar10
33ATFTA_MIGRMigration: Assignment of Flow Type to Update Type5SSIGNDirection of flownvarchar10
34OTC_CONV_FHAPOBackup Table for Financial Transaction Flows17SSIGNDirection of flownvarchar10
35OTC_CONV_FINKOBackup Table for Financial Transaction Conditions20SSIGNDirection of flownvarchar10
36OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows16SSIGNDirection of flownvarchar10
37OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions19SSIGNDirection of flownvarchar10
38REFCCReferences between CO object numbers, currency differences13SSIGNDirection of flownvarchar10
39TPMTVMFLPosition management variation margin flows at sec. account12SSIGNDirection of flownvarchar10
40TRGC_PL_ASGNFTYPAssignment of Profit/Loss Types to Flow Type5SSIGNDirection of Profit/Lossnvarchar10
41TRGC_PL_ASSIGNAssign Profit/Loss Types to Update Type and Valuation Area6SSIGNDirection of Profit/Lossnvarchar10
42TRLT_VCL_FLOWFlows Valuation Class Transfer29SSIGNDirection of flownvarchar10
43VTBFHAPOTransaction Flow17SSIGNDirection of flownvarchar10
44VTBFHAPO_MIGRMigrated Financial Flows17SSIGNDirection of flownvarchar10
45VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows17SSIGNDirection of flownvarchar10
46VTBFINKOTransaction Condition20SSIGNDirection of flownvarchar10
47VTBFIORFI: open requests8SSIGNDirection of flownvarchar10
48VTBMMORMM: open requests8SSIGNDirection of flownvarchar10
49VTBMRORinvoice verification: open requests8SSIGNDirection of flownvarchar10
50VTBPFHAPOTreasury: Flow Shells17SSIGNDirection of flownvarchar10
51VTBSIANF**Caution! Do not use. Will be deleted!!10SSIGNDirection of flownvarchar10
52VTBZVPayment Details for Transaction4SSIGNDirection of flownvarchar10
53VTIFHAPOUnderlying transaction flows16SSIGNDirection of flownvarchar10
54VTIFINKOUnderlying transaction conditions19SSIGNDirection of flownvarchar10
55VWFL2Assign Flow Types from TR Transaction to Security4SSIGNDirection of flownvarchar10
56VWFL_FT_DECFM: Assign Update Type to Flow Type5SSIGNDirection of flownvarchar10
TOPTreasury
57TZB0ADefinition of flow types33SSIGNDirection of flownvarchar10