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  | HRP1654
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
1ERP EHP76.0HRP1654593Table BD pour infotype 1654
SQL:  selectupdate insert create

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

SELECT MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, VARYF, SEQNR, INFTY, OTJID, AEDTM, UNAME, REASN, HISTO, ITXNR, IDNUM, STATU, NATUR, TYPE, DECRE, DEMIS, DDIFF, DDEMA, DDECI, DGEST, ARCID, DVI01, AVI01, SVI01, DVI02, AVI02, SVI02, DVI03, AVI03, SVI03, DVI04, AVI04, SVI04, DVI05, AVI05, SVI05, DVI06, AVI06, SVI06, DVI07, AVI07, SVI07, DVI08, AVI08, SVI08, DVI09, AVI09, SVI09, DVI10, AVI10, SVI10, TABNR FROM HRP1654
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTMandantnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PLVARVariante de planificationnvarchar20CHAR(N' ')NoT778PPLVAR Allow NULL? 
3OTYPEType d'objetnvarchar20CHAR(N' ')NoT778OOTYPE Allow NULL? 
4OBJIDID d'objetnvarchar80NUMC(N'00000000')NoPLOGIHROBJID Allow NULL? 
5SUBTYSous-typenvarchar40CHAR(N' ')No*SUBTYP Allow NULL? 
6ISTATStatut planif.char10CHAR(N' ')NoT778SISTAT_D Allow NULL? 
7BEGDADate de débutnvarchar80DATS(N'00000000')NoBEGDATUM Allow NULL? 
8ENDDADate de finnvarchar80DATS(N'00000000')NoENDDATUM Allow NULL? 
9VARYFZone variations du fichier PLOGnvarchar100CHAR(N' ')NoVARYF Allow NULL? 
10SEQNRNuméro d'enr. d'infotype avec clé identiquenvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
11INFTYInfotypenvarchar40CHAR(N' ')NoT778TINFOTYP Allow NULL? 
12OTJIDConcaténation type d'objet et ID d'objetnvarchar100CHAR(N' ')NoOTJID Allow NULL? 
13AEDTMDate de la modificationnvarchar80DATS(N'00000000')NoAEDTM Allow NULL? 
14UNAMENom utilisateurnvarchar120CHAR(N' ')NoUSRNAME Allow NULL? 
15REASNMotifnvarchar20CHAR(N' ')NoREASN Allow NULL? 
16HISTOCode d'historisationchar10CHAR(N' ')NoHISTO Allow NULL? 
17ITXNRElément de texte pour infotypenvarchar80NUMC(N'00000000')NoITXNR Allow NULL? 
18IDNUMNuméro de la décisionnvarchar300NUMC(N'000000000000000000000000000000')YesP06P_IDNUMDEC Allow NULL? 
19STATUStatutnvarchar40CHAR(N' ')YesT5FPBSD10P_99S_STATU Allow NULL? 
20NATURDécision collectivechar10CHAR(N' ')YesP06P_NATUREDEC Allow NULL? 
21TYPEType décisionnvarchar40CHAR(N' ')YesT5FPBSD17P06P_TYPEDEC Allow NULL? 
22DECREDécisionnvarchar40CHAR(N' ')YesT5FPBSD0P06P_DECREE Allow NULL? 
23DEMISDate d'émissionnvarchar80DATS(N'00000000')YesP06P_DATEEMI Allow NULL? 
24DDIFFDate d'activationnvarchar80DATS(N'00000000')YesP06P_DATEDIF Allow NULL? 
25DDEMADate de demandenvarchar80DATS(N'00000000')YesP06P_DATEDEMA Allow NULL? 
26DDECIDate de la décisionnvarchar80DATS(N'00000000')YesP06P_DDECI Allow NULL? 
27DGESTDépartement de gestionnvarchar300CHAR(N' ')YesP06P_DGEST Allow NULL? 
28ARCIDSAP ArchivLink : ID objet (code d'identification de l'objet)nvarchar500CHAR(N' ')YesSAEOBJID Allow NULL? 
29DVI01Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
30AVI01Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
31SVI01Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
32DVI02Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
33AVI02Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
34SVI02Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
35DVI03Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
36AVI03Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
37SVI03Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
38DVI04Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
39AVI04Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
40SVI04Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
41DVI05Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
42AVI05Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
43SVI05Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
44DVI06Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
45AVI06Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
46SVI06Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
47DVI07Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
48AVI07Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
49SVI07Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
50DVI08Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
51AVI08Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
52SVI08Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
53DVI09Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
54AVI09Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
55SVI09Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
56DVI10Date de Visanvarchar80DATS(N'00000000')YesP06P_DATEVIS Allow NULL? 
57AVI10Agent Visanvarchar200CHAR(N' ')YesP06P_AGENTVISDEC Allow NULL? 
58SVI10Signature agent Visanvarchar100CHAR(N' ')YesP06P_SIGNATUREDEC Allow NULL? 
59TABNRN° de renvoi à partie de tablenvarchar320CHAR(N' ')NoHRITABNRHRTABNR Allow NULL? 
NamePrimaryUniqueTypeColumns
HRP1654~0YesYesCLUSTEREDSEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1654~1NoNoNONCLUSTEREDMANDT, PLVAR, OTJID
HRP1654~2NoNoNONCLUSTEREDTABNR, 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