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  | P01E2_ADM
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
Payroll :: Germany :: Net :: Tax
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P01E2_ADM334ELStAM Procedure: Administration DataTax
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, PERNR, WERKS, BTRTL, WERKS_SUM, BTRTL_SUM, WERKS_DL, BTRTL_DL, WERKS_E2, BTRTL_E2, GUID_CNECT, NDTIC, NDTIC_IN, AUSDATUM, GUID_CANCEL, TESTD, SPEZ_TYP, REFABMELDUNG, GUID_REF_ANAB, EINDATUM, B2AID_LISTMTL, B2AID_LIST, SYSID, SYMDT, AGSTNR, BEGDA0012, ELSTAM_VH, MELDUNG_OK, TFTIC_TH_IN, TFTIC_NDB_IN, EFOLGE, QUARANTAENE FROM P01E2_ADM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDELStAM Procedure: Unique Key for Identifying Notificationsnvarchar320CHAR(N' ')NoP01_STGUID Allow NULL? 
3PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
4WERKSELStAM: Personnel Areanvarchar40CHAR(N' ')Yes*P01_TX_E2_WERKS Allow NULL? 
5BTRTLELStAM: Personnel Subareanvarchar40CHAR(N' ')Yes*P01_TX_E2_BTRTL Allow NULL? 
6WERKS_SUMELStAM: Personnel Area Company Office for Employment Taxnvarchar40CHAR(N' ')Yes*P01_TX_E2_WERKS_SUM Allow NULL? 
7BTRTL_SUMPersonnel Subarea Company Office for Employment Taxnvarchar40CHAR(N' ')Yes*P01_TX_E2_BTRTL_SUM Allow NULL? 
8WERKS_DLELStAM Procedure: Personnel Area Data Providernvarchar40CHAR(N' ')Yes*P01_TX_E2_WERKS_DL Allow NULL? 
9BTRTL_DLELStAM Procedure: Personnel Subarea Data Providernvarchar40CHAR(N' ')Yes*P01_TX_E2_BTRTL_DL Allow NULL? 
10WERKS_E2Personnel Area ELStAM Procedurenvarchar40CHAR(N' ')Yes*P01_TX_E2_WERKS_E2 Allow NULL? 
11BTRTL_E2Personnel Subarea ELStAM Procedurenvarchar40CHAR(N' ')Yes*P01_TX_E2_BTRTL_E2 Allow NULL? 
12GUID_CNECTELStAM Procedure: Unique Key for Identifying Notificationsnvarchar320CHAR(N' ')YesP01_STGUID Allow NULL? 
13NDTICELStAM: Processing Data Ticket Numbernvarchar320CHAR(N' ')YesP01_TX_E2_NDTIC Allow NULL? 
14NDTIC_INELStAM: Processing Data Ticket Number of Inbound Notificatnnvarchar320CHAR(N' ')YesP01_TX_E2_NDTIC_IN Allow NULL? 
15AUSDATUMELStAM: Leaving Datenvarchar80DATS(N'00000000')YesP01_TX_E2_AUSDATUM Allow NULL? 
16GUID_CANCELELStAM: GUID of Withdrawn Notificationnvarchar320CHAR(N' ')YesP01_TX_E2_STGUID_CANCEL Allow NULL? 
17TESTDTest Processchar10CHAR(N' ')YesP01T_TESTD Allow NULL? 
18SPEZ_TYPELStAM: Special Notification Typechar10CHAR(N' ')YesP01_TX_E2_SPEZ_TYP Allow NULL? 
19REFABMELDUNGELStAM: Reference from Registration to Deregistrationnvarchar80DATS(N'00000000')YesP01_TX_E2_REFABMELDUNG Allow NULL? 
20GUID_REF_ANABELStAM: GUID of Registration or Deregistrationnvarchar320CHAR(N' ')YesP01_TX_E2_STGUID_REF_ANAB Allow NULL? 
21EINDATUMELStAM: Entry Datenvarchar80DATS(N'00000000')YesP01_TX_E2_EINDATUM Allow NULL? 
22B2AID_LISTMTLELStAM: B2AID of Month List That Contains Notificationnvarchar320CHAR(N' ')YesP01_TX_E2_B2AID_LISTMTL Allow NULL? 
23B2AID_LISTELStAM: B2AID of List That Contains Notificationnvarchar320CHAR(N' ')YesP01_TX_E2_B2AID_LIST Allow NULL? 
24SYSIDName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
25SYMDTClient IDnvarchar30CLNT(N'000')Yes*SYMANDT Allow NULL? 
26AGSTNREmployer Tax Number in ELSTER Formatnvarchar150CHAR(N' ')YesP01_TX_E2_AGSTNR Allow NULL? 
27BEGDA0012Start Date Infotype 0012nvarchar80DATS(N'00000000')YesP01_TX_E2_BEGDA0012 Allow NULL? 
28ELSTAM_VHELStAM: Note Number of Clearing Housenvarchar90NUMC(N'000000000')YesP01_TX_E2_FEHLER_NR Allow NULL? 
29MELDUNG_OKIndicator Registration/Dereg./Change of Reg. Successfulchar10CHAR(N' ')YesP01_TX_E2_MELDUNG_OK Allow NULL? 
30TFTIC_TH_INELStAM: Transfer Ticket Transfer Header Inboxnvarchar700CHAR(N' ')YesP01T_TFTIC_TH_IN Allow NULL? 
31TFTIC_NDB_INELStAM: Transfer Ticket Processing Data Block Inboxnvarchar700CHAR(N' ')YesP01T_TFTIC_NDB_IN Allow NULL? 
32EFOLGEELStAM Procedure: Sequence of ELStAM Procedure Importnvarchar100CHAR(N' ')YesP01_TX_E2_EFOLGE Allow NULL? 
33QUARANTAENEELStAM Procedure: Quarantine Indicator for Process Controlnvarchar20CHAR(N' ')YesP01_TX_E2_QUARANTAENE Allow NULL? 
NamePrimaryUniqueTypeColumns
P01E2_ADM~0YesYesCLUSTEREDGUID, MANDT
P01E2_ADM~001NoNoNONCLUSTEREDPERNR, MANDT
P01E2_ADM~002NoNoNONCLUSTEREDGUID_CNECT, MANDT
P01E2_ADM~003NoNoNONCLUSTEREDNDTIC, 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