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

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