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  | ADRC
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Basis Services Communication Interfaces :: Address ManagementBusiness Address
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ADRC995Addresses (Business Address Services)Address ManagementBusiness Address
SQL:  selectupdate insert create

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

SELECT CLIENT, ADDRNUMBER, DATE_FROM, NATION, DATE_TO, TITLE, NAME1, NAME2, NAME3, NAME4, NAME_TEXT, NAME_CO, CITY1, CITY2, CITY_CODE, CITYP_CODE, HOME_CITY, CITYH_CODE, CHCKSTATUS, REGIOGROUP, POST_CODE1, POST_CODE2, POST_CODE3, PCODE1_EXT, PCODE2_EXT, PCODE3_EXT, PO_BOX, DONT_USE_P, PO_BOX_NUM, PO_BOX_LOC, CITY_CODE2, PO_BOX_REG, PO_BOX_CTY, POSTALAREA, TRANSPZONE, STREET, DONT_USE_S, STREETCODE, STREETABBR, HOUSE_NUM1, HOUSE_NUM2, HOUSE_NUM3, STR_SUPPL1, STR_SUPPL2, STR_SUPPL3, LOCATION, BUILDING, FLOOR, ROOMNUMBER, COUNTRY, LANGU, REGION, ADDR_GROUP, FLAGGROUPS, PERS_ADDR, SORT1, SORT2, SORT_PHN, DEFLT_COMM, TEL_NUMBER, TEL_EXTENS, FAX_NUMBER, FAX_EXTENS, FLAGCOMM2, FLAGCOMM3, FLAGCOMM4, FLAGCOMM5, FLAGCOMM6, FLAGCOMM7, FLAGCOMM8, FLAGCOMM9, FLAGCOMM10, FLAGCOMM11, FLAGCOMM12, FLAGCOMM13, ADDRORIGIN, MC_NAME1, MC_CITY1, MC_STREET, EXTENSION1, EXTENSION2, TIME_ZONE, TAXJURCODE, ADDRESS_ID, LANGU_CREA, ADRC_UUID, UUID_BELATED, ID_CATEGORY, ADRC_ERR_STATUS, PO_BOX_LOBBY, DELI_SERV_TYPE, DELI_SERV_NUMBER, COUNTY_CODE, COUNTY, TOWNSHIP_CODE, TOWNSHIP, MC_COUNTY, MC_TOWNSHIP, XPCPT FROM ADRC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ADDRNUMBERAddress numbernvarchar100CHAR(N' ')NoAD_ADDRNUM Allow NULL? 
3DATE_FROMValid-from date - in current Release only 00010101 possiblenvarchar80DATS(N'00000000')NoAD_DATE_FR Allow NULL? 
4NATIONVersion ID for International Addresseschar10CHAR(N' ')NoTSADVAD_NATION Allow NULL? 
5DATE_TOValid-to date in current Release only 99991231 possiblenvarchar80DATS(N'00000000')NoAD_DATE_TO Allow NULL? 
6TITLEForm-of-Address Keynvarchar40CHAR(N' ')NoTSAD3AD_TITLE Allow NULL? 
7NAME1Name 1nvarchar400CHAR(N' ')NoAD_NAME1 Allow NULL? 
8NAME2Name 2nvarchar400CHAR(N' ')NoAD_NAME2 Allow NULL? 
9NAME3Name 3nvarchar400CHAR(N' ')NoAD_NAME3 Allow NULL? 
10NAME4Name 4nvarchar400CHAR(N' ')NoAD_NAME4 Allow NULL? 
11NAME_TEXTConverted name field (with form of address)nvarchar500CHAR(N' ')YesAD_NAMETXT Allow NULL? 
12NAME_COc/o namenvarchar400CHAR(N' ')NoAD_NAME_CO Allow NULL? 
13CITY1Citynvarchar400CHAR(N' ')NoAD_CITY1 Allow NULL? 
14CITY2Districtnvarchar400CHAR(N' ')NoAD_CITY2 Allow NULL? 
15CITY_CODECity code for city/street filenvarchar120CHAR(N' ')NoADRCITYAD_CITYNUM Allow NULL? 
16CITYP_CODEDistrict code for City and Street filenvarchar80CHAR(N' ')YesADRCITYPRTAD_CITYPNM Allow NULL? 
17HOME_CITYCity (different from postal city)nvarchar400CHAR(N' ')YesAD_CITY3 Allow NULL? 
18CITYH_CODEDifferent city for city/street filenvarchar120CHAR(N' ')YesADRCITYAD_CITYHNM Allow NULL? 
19CHCKSTATUSCity file test statuschar10CHAR(N' ')YesAD_CHECKST Allow NULL? 
20REGIOGROUPRegional structure groupingnvarchar80CHAR(N' ')YesADRREGGRPREGIOGROUP Allow NULL? 
21POST_CODE1City postal codenvarchar100CHAR(N' ')NoAD_PSTCD1 Allow NULL? 
22POST_CODE2PO Box Postal Codenvarchar100CHAR(N' ')NoAD_PSTCD2 Allow NULL? 
23POST_CODE3Company Postal Code (for Large Customers)nvarchar100CHAR(N' ')NoAD_PSTCD3 Allow NULL? 
24PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Codenvarchar100CHAR(N' ')YesAD_PST1XT Allow NULL? 
25PCODE2_EXT(Not Supported) PO Box Postal Code Extensionnvarchar100CHAR(N' ')YesAD_PST2XT Allow NULL? 
26PCODE3_EXT(Not Supported) Major Customer Postal Code Extensionnvarchar100CHAR(N' ')YesAD_PST3XT Allow NULL? 
27PO_BOXPO Boxnvarchar100CHAR(N' ')NoAD_POBX Allow NULL? 
28DONT_USE_PPO Box Address Undeliverable Flagnvarchar40CHAR(N' ')YesTSAD12AD_NO_USEP Allow NULL? 
29PO_BOX_NUMFlag: PO Box Without Numberchar10CHAR(N' ')YesAD_POBXNUM Allow NULL? 
30PO_BOX_LOCPO Box citynvarchar400CHAR(N' ')NoAD_POBXLOC Allow NULL? 
31CITY_CODE2City PO box code (City file)nvarchar120CHAR(N' ')YesADRCITYAD_CIT2NUM Allow NULL? 
32PO_BOX_REGRegion for PO Box (Country, State, Province, ...)nvarchar30CHAR(N' ')YesT005SAD_POBXREG Allow NULL? 
33PO_BOX_CTYPO box countrynvarchar30CHAR(N' ')YesT005AD_POBXCTY Allow NULL? 
34POSTALAREA(Not Supported) Post Delivery Districtnvarchar150CHAR(N' ')NoAD_PSTLAR Allow NULL? 
35TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100CHAR(N' ')NoTZONELZONE Allow NULL? 
36STREETStreetnvarchar600CHAR(N' ')NoAD_STREET Allow NULL? 
37DONT_USE_SStreet Address Undeliverable Flagnvarchar40CHAR(N' ')YesTSAD12AD_NO_USES Allow NULL? 
38STREETCODEStreet Number for City/Street Filenvarchar120CHAR(N' ')NoADRSTREETAD_STRNUM Allow NULL? 
39STREETABBR(Not Supported) Abbreviation of Street Namenvarchar20CHAR(N' ')NoADRSTRTYPEAD_STRABBR Allow NULL? 
40HOUSE_NUM1House Numbernvarchar100CHAR(N' ')NoAD_HSNM1 Allow NULL? 
41HOUSE_NUM2House number supplementnvarchar100CHAR(N' ')NoAD_HSNM2 Allow NULL? 
42HOUSE_NUM3(Not supported) House Number Rangenvarchar100CHAR(N' ')NoAD_HSNM3 Allow NULL? 
43STR_SUPPL1Street 2nvarchar400CHAR(N' ')NoAD_STRSPP1 Allow NULL? 
44STR_SUPPL2Street 3nvarchar400CHAR(N' ')NoAD_STRSPP2 Allow NULL? 
45STR_SUPPL3Street 4nvarchar400CHAR(N' ')YesAD_STRSPP3 Allow NULL? 
46LOCATIONStreet 5nvarchar400CHAR(N' ')NoAD_LCTN Allow NULL? 
47BUILDINGBuilding (Number or Code)nvarchar200CHAR(N' ')NoAD_BLDNG Allow NULL? 
48FLOORFloor in buildingnvarchar100CHAR(N' ')NoAD_FLOOR Allow NULL? 
49ROOMNUMBERRoom or Appartment Numbernvarchar100CHAR(N' ')NoAD_ROOMNUM Allow NULL? 
50COUNTRYCountry Keynvarchar30CHAR(N' ')NoT005LAND1 Allow NULL? 
51LANGULanguage Keychar10LANG(N' ')NoT002SPRAS Allow NULL? 
52REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')NoT005SREGIO Allow NULL? 
53ADDR_GROUPAddress Group (Key) (Business Address Services)nvarchar40CHAR(N' ')NoTSAD7AD_GROUP Allow NULL? 
54FLAGGROUPSFlag: There are more address group assignmentschar10CHAR(N' ')YesAD_FLGGP Allow NULL? 
55PERS_ADDRFlag: This is a personal addresschar10CHAR(N' ')NoAD_PRSADDR Allow NULL? 
56SORT1Search Term 1nvarchar200CHAR(N' ')NoAD_SORT1 Allow NULL? 
57SORT2Search Term 2nvarchar200CHAR(N' ')NoAD_SORT2 Allow NULL? 
58SORT_PHN(Not Supported) Phonetic Search Sort Fieldnvarchar200CHAR(N' ')NoAD_SRTPHN Allow NULL? 
59DEFLT_COMMCommunication Method (Key) (Business Address Services)nvarchar30CHAR(N' ')NoTSACAD_COMM Allow NULL? 
60TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300CHAR(N' ')NoAD_TLNMBR1 Allow NULL? 
61TEL_EXTENSFirst Telephone No.: Extensionnvarchar100CHAR(N' ')NoAD_TLXTNS1 Allow NULL? 
62FAX_NUMBERFirst fax no.: dialling code+numbernvarchar300CHAR(N' ')NoAD_FXNMBR1 Allow NULL? 
63FAX_EXTENSFirst fax no.: extensionnvarchar100CHAR(N' ')NoAD_FXXTNS1 Allow NULL? 
64FLAGCOMM2Flag: Telephone number(s) maintainedchar10CHAR(N' ')NoAD_FLGCM02 Allow NULL? 
65FLAGCOMM3Flag: Fax number(s) maintainedchar10CHAR(N' ')NoAD_FLGCM03 Allow NULL? 
66FLAGCOMM4Flag: Teletex number(s) maintainedchar10CHAR(N' ')NoAD_FLGCM04 Allow NULL? 
67FLAGCOMM5Flag: Telex number(s) maintainedchar10CHAR(N' ')NoAD_FLGCM05 Allow NULL? 
68FLAGCOMM6Indicator: E-Mail Address(es) Maintainedchar10CHAR(N' ')NoAD_FLGCM06 Allow NULL? 
69FLAGCOMM7Flag: RML (remote mail) addresse(s) maintainedchar10CHAR(N' ')NoAD_FLGCM07 Allow NULL? 
70FLAGCOMM8Flag: X.400 addresse(s) maintainedchar10CHAR(N' ')NoAD_FLGCM08 Allow NULL? 
71FLAGCOMM9Flag: RFC destination(s) maintainedchar10CHAR(N' ')NoAD_FLGCM09 Allow NULL? 
72FLAGCOMM10Flag: Printer maintainedchar10CHAR(N' ')YesAD_FLGCM10 Allow NULL? 
73FLAGCOMM11Flag: SSF maintainedchar10CHAR(N' ')YesAD_FLGCM11 Allow NULL? 
74FLAGCOMM12Flag: URI/FTP address maintainedchar10CHAR(N' ')YesAD_FLGCM12 Allow NULL? 
75FLAGCOMM13Flag: Pager address maintainedchar10CHAR(N' ')YesAD_FLGCM13 Allow NULL? 
76ADDRORIGIN(Not Supported) Address Data Source (Key)nvarchar40CHAR(N' ')NoTSAD6AD_ORIGINA Allow NULL? 
77MC_NAME1Name (field NAME1) in upper case for matchcodenvarchar250CHAR(N' ')NoAD_MC_NAME Allow NULL? 
78MC_CITY1City name in upper case for search helpnvarchar250CHAR(N' ')NoAD_MC_CITY Allow NULL? 
79MC_STREETStreet name in upper case for search helpnvarchar250CHAR(N' ')NoAD_MC_STRT Allow NULL? 
80EXTENSION1Extension (only for data conversion) (e.g. data line)nvarchar400CHAR(N' ')NoAD_EXTENS1 Allow NULL? 
81EXTENSION2Extension (only for data conversion) (e.g. telebox)nvarchar400CHAR(N' ')NoAD_EXTENS2 Allow NULL? 
82TIME_ZONEAddress time zonenvarchar60CHAR(N' ')NoTTZZAD_TZONE Allow NULL? 
83TAXJURCODETax Jurisdictionnvarchar150CHAR(N' ')NoAD_TXJCD Allow NULL? 
84ADDRESS_ID(Not supported) Physical address IDnvarchar100CHAR(N' ')YesAD_ADDR_ID Allow NULL? 
85LANGU_CREAAddress record creation original languagechar10LANG(N' ')Yes*AD_LANGUCR Allow NULL? 
86ADRC_UUIDUUID Used in the Addressvarbinary160RAWYesAD_UUID
87UUID_BELATEDIndicator: UUID was generated laterchar10CHAR(N' ')YesAD_UUID_BELATED Allow NULL? 
88ID_CATEGORYCategory of an Address IDchar10CHAR(N' ')YesAD_ID_CATEGORY Allow NULL? 
89ADRC_ERR_STATUSError Status of Addresschar10CHAR(N' ')YesAD_ERR_STATUS Allow NULL? 
90PO_BOX_LOBBYPO Box Lobbynvarchar400CHAR(N' ')YesAD_PO_BOX_LBY Allow NULL? 
91DELI_SERV_TYPEType of Delivery Servicenvarchar40CHAR(N' ')YesADDRC_DELI_SERVAD_DELIVERY_SERVICE_TYPE Allow NULL? 
92DELI_SERV_NUMBERNumber of Delivery Servicenvarchar100CHAR(N' ')YesAD_DELIVERY_SERVICE_NUMBER Allow NULL? 
93COUNTY_CODECounty code for countynvarchar80CHAR(N' ')Yes*AD_CNTYNUM Allow NULL? 
94COUNTYCountynvarchar400CHAR(N' ')YesAD_COUNTY Allow NULL? 
95TOWNSHIP_CODETownship code for Townshipnvarchar80CHAR(N' ')Yes*AD_TWSHPNUM Allow NULL? 
96TOWNSHIPTownshipnvarchar400CHAR(N' ')YesAD_TOWNSHIP Allow NULL? 
97MC_COUNTYCounty name in upper case for search helpnvarchar250CHAR(N' ')YesAD_MC_COUNTY Allow NULL? 
98MC_TOWNSHIPTownship name in upper case for search helpnvarchar250CHAR(N' ')YesAD_MC_TWSHP Allow NULL? 
99XPCPTBusiness Purpose Completed Flagchar10CHAR(N' ')YesAD_XPCPT Allow NULL? 
NamePrimaryUniqueTypeColumns
ADRC~0YesYesCLUSTEREDNATION, DATE_FROM, ADDRNUMBER, CLIENT
ADRC~I01NoNoNONCLUSTEREDMC_NAME1
ADRC~I03NoNoNONCLUSTEREDMC_CITY1
ADRC~I09NoNoNONCLUSTEREDMC_STREET
ADRC~I13NoNoNONCLUSTEREDSORT1

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