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
1ERP EHP76.0REQADDRESS881Delivery Address for Requirement Coverage Request Lines
SQL:  selectupdate insert create

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

SELECT CLIENT, REQNO, REQLLINE, REQSLINE, PARTNER_GUID, PARTNER_FCT, ADDR_TYPE, ADDR_ORIGIN, DEL_IND, CHANGED, PERS_NO, ADDR_NO, TITLE_P, FIRSTNAME, LASTNAME, BIRTH_NAME, MIDDLENAME, SECONDNAME, FULLNAME, FULLNAME_X, TITLE_ACA1, TITLE_ACA2, PREFIX1, PREFIX2, TITLE_SPPL, NICKNAME, INITIALS, NAMEFORMAT, NAMCOUNTRY, LANGU_P, LANGUP_ISO, SORT1_P, SORT2_P, DEPARTMENT, FUNCTION, BUILDING_P, FLOOR_P, ROOM_NO_P, INITS_SIG, INHOUSE_ML, COMM_TYPE, TITLE, NAME, NAME_2, NAME_3, NAME_4, C_O_NAME, CITY, DISTRICT, CITY_NO, DISTRCT_NO, CHCKSTATUS, POSTL_COD1, POSTL_COD2, POSTL_COD3, PO_BOX, PO_BOX_CIT, PBOXCIT_NO, DELIV_DIS, TRANSPZONE, STREET, STREET_NO, STR_ABBR, HOUSE_NO, HOUSE_NO2, STR_SUPPL1, STR_SUPPL2, STR_SUPPL3, LOCATION, BUILDING, FLOOR, ROOM_NO, COUNTRY, COUNTRYISO, LANGU, LANGU_ISO, REGION, SORT1, SORT2, TIME_ZONE, TAXJURCODE, ADR_NOTES, TEL1_NUMBR, TEL1_EXT, FAX_NUMBER, FAX_EXTENS, E_MAIL, BUILD_LONG FROM REQADDRESS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2REQNORequirement Coverage Request Document Numbernvarchar100CHAR(N' ')No*EC_REQNO Allow NULL? 
3REQLLINEAdministrative line number of requirement coverage requestnvarchar100NUMC(N'0000000000')NoREQLLINE Allow NULL? 
4REQSLINETemporary Item Number of Requirement Coverage Requestnvarchar100NUMC(N'0000000000')YesREQSLINE Allow NULL? 
5PARTNER_GUIDGUID for an Individual Partnervarbinary160RAWYesCRMT_PARTNER_GUID
6PARTNER_FCTPartner func.nvarchar80CHAR(N' ')YesCRMT_PARTNER_FCT Allow NULL? 
7ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person)char10CHAR(N' ')YesAD_ADRTYPE Allow NULL? 
8ADDR_ORIGINOrigin for a Partner Addresschar10CHAR(N' ')YesBBP_ADDR_ORIGIN Allow NULL? 
9DEL_INDDeletion Indicator SRM Purchasing Documentchar10CHAR(N' ')YesBBP_DEL_IND Allow NULL? 
10CHANGEDCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
11PERS_NOPerson numbernvarchar100CHAR(N' ')YesADRPAD_PERSNUM Allow NULL? 
12ADDR_NOAddress numbernvarchar100CHAR(N' ')YesADRCAD_ADDRNUM Allow NULL? 
13TITLE_PTitle textnvarchar300CHAR(N' ')YesAD_TITLETX Allow NULL? 
14FIRSTNAMEFirst namenvarchar400CHAR(N' ')YesAD_NAMEFIR Allow NULL? 
15LASTNAMELast namenvarchar400CHAR(N' ')YesAD_NAMELAS Allow NULL? 
16BIRTH_NAMEName of person at birthnvarchar400CHAR(N' ')YesAD_NAME2_P Allow NULL? 
17MIDDLENAMEMiddle name or second forename of a personnvarchar400CHAR(N' ')YesAD_NAMEMID Allow NULL? 
18SECONDNAMESecond surname of a personnvarchar400CHAR(N' ')YesAD_NAMLAS2 Allow NULL? 
19FULLNAMEFull Name of Personnvarchar800CHAR(N' ')YesAD_NAMTEXT Allow NULL? 
20FULLNAME_XStatus of Field 'Full Name' NAME_TEXTchar10CHAR(N' ')YesAD_NAMCONV Allow NULL? 
21TITLE_ACA1Academic Title: Written Formnvarchar200CHAR(N' ')YesAD_TITLE1T Allow NULL? 
22TITLE_ACA2Academic Title: Written Formnvarchar200CHAR(N' ')YesAD_TITLE1T Allow NULL? 
23PREFIX1Name prefixnvarchar200CHAR(N' ')YesAD_PREFIXT Allow NULL? 
24PREFIX2Name prefixnvarchar200CHAR(N' ')YesAD_PREFIXT Allow NULL? 
25TITLE_SPPLName supplement, e.g. noble title (written form)nvarchar200CHAR(N' ')YesAD_TITLEST Allow NULL? 
26NICKNAMENickname or name usednvarchar400CHAR(N' ')YesAD_NICKNAM Allow NULL? 
27INITIALS"Middle Initial" or personal initialsnvarchar100CHAR(N' ')YesAD_INITS Allow NULL? 
28NAMEFORMATName formatnvarchar20CHAR(N' ')YesT005NAD_FORMAT Allow NULL? 
29NAMCOUNTRYCountry for name format rulenvarchar30CHAR(N' ')YesT005AD_NAMCTRY Allow NULL? 
30LANGU_PLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
31LANGUP_ISO2-Character SAP Language Codenvarchar20CHAR(N' ')YesLAISO Allow NULL? 
32SORT1_PSearch Term 1nvarchar200CHAR(N' ')YesAD_SORT1 Allow NULL? 
33SORT2_PSearch Term 2nvarchar200CHAR(N' ')YesAD_SORT2 Allow NULL? 
34DEPARTMENTDepartmentnvarchar400CHAR(N' ')YesAD_DPRTMNT Allow NULL? 
35FUNCTIONFunctionnvarchar400CHAR(N' ')YesAD_FNCTN Allow NULL? 
36BUILDING_PBuilding (number or code)nvarchar100CHAR(N' ')YesAD_BLDNG_P Allow NULL? 
37FLOOR_PFloor in buildingnvarchar100CHAR(N' ')YesAD_FLOOR Allow NULL? 
38ROOM_NO_PRoom or Appartment Numbernvarchar100CHAR(N' ')YesAD_ROOMNUM Allow NULL? 
39INITS_SIGShort name for correspondencenvarchar100CHAR(N' ')YesAD_ID_CODE Allow NULL? 
40INHOUSE_MLInt. mail postal codenvarchar100CHAR(N' ')YesAD_IH_MAIL Allow NULL? 
41COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30CHAR(N' ')YesTSACAD_COMM Allow NULL? 
42TITLETitle textnvarchar300CHAR(N' ')YesAD_TITLETX Allow NULL? 
43NAMEName 1nvarchar400CHAR(N' ')YesAD_NAME1 Allow NULL? 
44NAME_2Name 2nvarchar400CHAR(N' ')YesAD_NAME2 Allow NULL? 
45NAME_3Name 3nvarchar400CHAR(N' ')YesAD_NAME3 Allow NULL? 
46NAME_4Name 4nvarchar400CHAR(N' ')YesAD_NAME4 Allow NULL? 
47C_O_NAMEc/o namenvarchar400CHAR(N' ')YesAD_NAME_CO Allow NULL? 
48CITYCitynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
49DISTRICTDistrictnvarchar400CHAR(N' ')YesAD_CITY2 Allow NULL? 
50CITY_NOCity code for city/street filenvarchar120CHAR(N' ')YesADRCITYAD_CITYNUM Allow NULL? 
51DISTRCT_NODistrict code for City and Street filenvarchar80CHAR(N' ')YesADRCITYPRTAD_CITYPNM Allow NULL? 
52CHCKSTATUSCity file test statuschar10CHAR(N' ')YesAD_CHECKST Allow NULL? 
53POSTL_COD1City postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
54POSTL_COD2PO Box Postal Codenvarchar100CHAR(N' ')YesAD_PSTCD2 Allow NULL? 
55POSTL_COD3Company Postal Code (for Large Customers)nvarchar100CHAR(N' ')YesAD_PSTCD3 Allow NULL? 
56PO_BOXPO Boxnvarchar100CHAR(N' ')YesAD_POBX Allow NULL? 
57PO_BOX_CITPO Box citynvarchar400CHAR(N' ')YesAD_POBXLOC Allow NULL? 
58PBOXCIT_NOCity PO box code (City file)nvarchar120CHAR(N' ')YesADRCITYAD_CIT2NUM Allow NULL? 
59DELIV_DIS(Not Supported) Post Delivery Districtnvarchar150CHAR(N' ')YesAD_PSTLAR Allow NULL? 
60TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100CHAR(N' ')YesTZONELZONE Allow NULL? 
61STREETStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
62STREET_NOStreet Number for City/Street Filenvarchar120CHAR(N' ')YesADRSTREETAD_STRNUM Allow NULL? 
63STR_ABBR(Not Supported) Abbreviation of Street Namenvarchar20CHAR(N' ')YesADRSTRTYPEAD_STRABBR Allow NULL? 
64HOUSE_NOHouse Numbernvarchar100CHAR(N' ')YesAD_HSNM1 Allow NULL? 
65HOUSE_NO2House number supplementnvarchar100CHAR(N' ')YesAD_HSNM2 Allow NULL? 
66STR_SUPPL1Street 2nvarchar400CHAR(N' ')YesAD_STRSPP1 Allow NULL? 
67STR_SUPPL2Street 3nvarchar400CHAR(N' ')YesAD_STRSPP2 Allow NULL? 
68STR_SUPPL3Street 4nvarchar400CHAR(N' ')YesAD_STRSPP3 Allow NULL? 
69LOCATIONStreet 5nvarchar400CHAR(N' ')YesAD_LCTN Allow NULL? 
70BUILDINGold: building (no. or abbreviation)nvarchar100CHAR(N' ')YesAD_BLD_OLD Allow NULL? 
71FLOORFloor in buildingnvarchar100CHAR(N' ')YesAD_FLOOR Allow NULL? 
72ROOM_NORoom or Appartment Numbernvarchar100CHAR(N' ')YesAD_ROOMNUM Allow NULL? 
73COUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
74COUNTRYISOCountry ISO codenvarchar20CHAR(N' ')YesINTCA Allow NULL? 
75LANGULanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
76LANGU_ISO2-Character SAP Language Codenvarchar20CHAR(N' ')YesLAISO Allow NULL? 
77REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
78SORT1Search Term 1nvarchar200CHAR(N' ')YesAD_SORT1 Allow NULL? 
79SORT2Search Term 2nvarchar200CHAR(N' ')YesAD_SORT2 Allow NULL? 
80TIME_ZONEAddress time zonenvarchar60CHAR(N' ')YesTTZZAD_TZONE Allow NULL? 
81TAXJURCODETax Jurisdictionnvarchar150CHAR(N' ')YesAD_TXJCD Allow NULL? 
82ADR_NOTESAddress notesnvarchar500CHAR(N' ')YesAD_REMARK1 Allow NULL? 
83TEL1_NUMBRFirst telephone no.: dialling code+numbernvarchar300CHAR(N' ')YesAD_TLNMBR1 Allow NULL? 
84TEL1_EXTFirst Telephone No.: Extensionnvarchar100CHAR(N' ')YesAD_TLXTNS1 Allow NULL? 
85FAX_NUMBERFirst fax no.: dialling code+numbernvarchar300CHAR(N' ')YesAD_FXNMBR1 Allow NULL? 
86FAX_EXTENSFirst fax no.: extensionnvarchar100CHAR(N' ')YesAD_FXXTNS1 Allow NULL? 
87E_MAILE-Mail Addressnvarchar2410CHAR(N' ')YesAD_SMTPADR Allow NULL? 
88BUILD_LONGBuilding (Number or Code)nvarchar200CHAR(N' ')YesAD_BLDNG Allow NULL? 
NamePrimaryUniqueTypeColumns
REQADDRESS~0YesYesCLUSTEREDREQLLINE, REQNO, CLIENT