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  | SADLSTRECB
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Sales and Distribution :: Sales Support :: Sales Promotions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SADLSTRECB981Dynamic Part of Address List (Record Body)Sales Promotions
SQL:  selectupdate insert create

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

SELECT MANDT, LISTNR, VERSION, BLKNR, COUNTER, PARGE, PERNR, KUNNR, LIFNR, ANRED_AP, NAMEV_AP, NAME1_AP, SPNAM_AP, TITEL_AP, SPRAS_AP, ANRED, NAME1, NAME2, NAME3, NAME4, SPRAS, NAME_CO, STREET, HOUSE_NUM1, HOUSE_NUM2, STR_SUPPL1, STR_SUPPL2, STR_SUPPL3, CITY1, CITY2, HOME_CITY, POST_CODE1, POST_CODE2, POST_CODE3, PCODE1_EXT, PCODE2_EXT, PCODE3_EXT, PO_BOX, PO_BOX_NUM, PO_BOX_LOC, PO_BOX_REG, PO_BOX_CTY, LOCATION, REGION, COUNTRY, PO_BOX_LOBBY, DELI_SERV_TYPE, DELI_SERV_NUMBER, COUNTY, TOWNSHIP, TELF1, TELFX, KTOKD, DEAR1, DEAR2, DEAR3, DEAR4, BRSCH, BRAN1, BRAN2, BRAN3, BRAN4, BRAN5, NIELS, KUKLA, GFORM, KATR1, KATR2, KATR3, KATR4, KATR5, KATR6, KATR7, KATR8, KATR9, KATR10, PAVIP, FAMST, PARGE_LIS, ABTNR, PAFKT, PARVO, AKVER, PARH1, PARH2, PARH3, PARH4, PARH5, PAKN1, PAKN2, PAKN3, PAKN4, PAKN5, PSTLZ_LIS, PSTL2_LIS, PSTL_LIS, LAND1_LIS, REGIO_LIS FROM SADLSTRECB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LISTNRNumber of the Address Listnvarchar100CHAR(N' ')NoSADLSTIADKTANR Allow NULL? 
3VERSIONVersion numbernvarchar40NUMC(N'0000')NoSADLSTIADCASVERSION Allow NULL? 
4BLKNRCAS usage: Address interval numbernvarchar60CHAR(N' ')NoSADLSTIADCASBLKNR Allow NULL? 
5COUNTERUse in CAS: Artificial key fieldint100INT4((0))NoCASCOUNTER Allow NULL? 
6PARGEPartner's genderchar10CHAR(N' ')YesPARGE Allow NULL? 
7PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
8KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
9LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
10ANRED_APForm of address for contact person (Mr, Mrs...etc)nvarchar300CHAR(N' ')YesANRED_AP Allow NULL? 
11NAMEV_APFirst namenvarchar350CHAR(N' ')YesNAMEV_VP Allow NULL? 
12NAME1_APName 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
13SPNAM_APNicknamenvarchar100CHAR(N' ')YesSPNAM Allow NULL? 
14TITEL_APTitle of contact person (description of function)nvarchar350CHAR(N' ')YesTITEL_AP Allow NULL? 
15SPRAS_APLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
16ANREDTitlenvarchar150CHAR(N' ')YesANRED Allow NULL? 
17NAME1Name 1nvarchar350CHAR(N' ')YesNAME1_BAS Allow NULL? 
18NAME2Name 2nvarchar350CHAR(N' ')YesNAME2_BAS Allow NULL? 
19NAME3Name 3nvarchar350CHAR(N' ')YesNAME3_BAS Allow NULL? 
20NAME4Name 4nvarchar350CHAR(N' ')YesNAME4_BAS Allow NULL? 
21SPRASLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
22NAME_COc/o namenvarchar400CHAR(N' ')YesAD_NAME_CO Allow NULL? 
23STREETStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
24HOUSE_NUM1House Numbernvarchar100CHAR(N' ')YesAD_HSNM1 Allow NULL? 
25HOUSE_NUM2House number supplementnvarchar100CHAR(N' ')YesAD_HSNM2 Allow NULL? 
26STR_SUPPL1Street 2nvarchar400CHAR(N' ')YesAD_STRSPP1 Allow NULL? 
27STR_SUPPL2Street 3nvarchar400CHAR(N' ')YesAD_STRSPP2 Allow NULL? 
28STR_SUPPL3Street 4nvarchar400CHAR(N' ')YesAD_STRSPP3 Allow NULL? 
29CITY1Citynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
30CITY2Districtnvarchar400CHAR(N' ')YesAD_CITY2 Allow NULL? 
31HOME_CITYCity (different from postal city)nvarchar400CHAR(N' ')YesAD_CITY3 Allow NULL? 
32POST_CODE1City postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
33POST_CODE2PO Box Postal Codenvarchar100CHAR(N' ')YesAD_PSTCD2 Allow NULL? 
34POST_CODE3Company Postal Code (for Large Customers)nvarchar100CHAR(N' ')YesAD_PSTCD3 Allow NULL? 
35PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Codenvarchar100CHAR(N' ')YesAD_PST1XT Allow NULL? 
36PCODE2_EXT(Not Supported) PO Box Postal Code Extensionnvarchar100CHAR(N' ')YesAD_PST2XT Allow NULL? 
37PCODE3_EXT(Not Supported) Major Customer Postal Code Extensionnvarchar100CHAR(N' ')YesAD_PST3XT Allow NULL? 
38PO_BOXPO Boxnvarchar100CHAR(N' ')YesAD_POBX Allow NULL? 
39PO_BOX_NUMFlag: PO Box Without Numberchar10CHAR(N' ')YesAD_POBXNUM Allow NULL? 
40PO_BOX_LOCPO Box citynvarchar400CHAR(N' ')YesAD_POBXLOC Allow NULL? 
41PO_BOX_REGRegion for PO Box (Country, State, Province, ...)nvarchar30CHAR(N' ')Yes*AD_POBXREG Allow NULL? 
42PO_BOX_CTYPO box countrynvarchar30CHAR(N' ')Yes*AD_POBXCTY Allow NULL? 
43LOCATIONStreet 5nvarchar400CHAR(N' ')YesAD_LCTN Allow NULL? 
44REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
45COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
46PO_BOX_LOBBYPO Box Lobbynvarchar400CHAR(N' ')YesAD_PO_BOX_LBY Allow NULL? 
47DELI_SERV_TYPEType of Delivery Servicenvarchar40CHAR(N' ')Yes*AD_DELIVERY_SERVICE_TYPE Allow NULL? 
48DELI_SERV_NUMBERNumber of Delivery Servicenvarchar100CHAR(N' ')YesAD_DELIVERY_SERVICE_NUMBER Allow NULL? 
49COUNTYCountynvarchar400CHAR(N' ')YesAD_COUNTY Allow NULL? 
50TOWNSHIPTownshipnvarchar400CHAR(N' ')YesAD_TOWNSHIP Allow NULL? 
51TELF1Addresses: telephone no.nvarchar300CHAR(N' ')YesTLFNR Allow NULL? 
52TELFXFax numbernvarchar310CHAR(N' ')YesTELFX_BAS Allow NULL? 
53KTOKDCustomer Account Groupnvarchar40CHAR(N' ')Yes*KTOKD Allow NULL? 
54DEAR1Indicator: Competitorchar10CHAR(N' ')YesDEAR1 Allow NULL? 
55DEAR2Indicator: Sales partnerchar10CHAR(N' ')YesDEAR2 Allow NULL? 
56DEAR3Indicator: Sales prospectchar10CHAR(N' ')YesDEAR3 Allow NULL? 
57DEAR4Indicator for customer type 4char10CHAR(N' ')YesDEAR4 Allow NULL? 
58BRSCHIndustry keynvarchar40CHAR(N' ')Yes*BRSCH Allow NULL? 
59BRAN1Industry Code 1nvarchar100CHAR(N' ')Yes*BRAN1_D Allow NULL? 
60BRAN2Industry code 2nvarchar100CHAR(N' ')Yes*BRAN2 Allow NULL? 
61BRAN3Industry code 3nvarchar100CHAR(N' ')Yes*BRAN3 Allow NULL? 
62BRAN4Industry code 4nvarchar100CHAR(N' ')Yes*BRAN4 Allow NULL? 
63BRAN5Industry code 5nvarchar100CHAR(N' ')Yes*BRAN5 Allow NULL? 
64NIELSNielsen IDnvarchar20CHAR(N' ')Yes*NIELS Allow NULL? 
65KUKLACustomer classificationnvarchar20CHAR(N' ')Yes*KUKLA Allow NULL? 
66GFORMLegal statusnvarchar20CHAR(N' ')Yes*GFORM Allow NULL? 
67KATR1Attribute 1nvarchar20CHAR(N' ')Yes*KATR1 Allow NULL? 
68KATR2Attribute 2nvarchar20CHAR(N' ')Yes*KATR2 Allow NULL? 
69KATR3Attribute 3nvarchar20CHAR(N' ')Yes*KATR3 Allow NULL? 
70KATR4Attribute 4nvarchar20CHAR(N' ')Yes*KATR4 Allow NULL? 
71KATR5Attribute 5nvarchar20CHAR(N' ')Yes*KATR5 Allow NULL? 
72KATR6Attribute 6nvarchar30CHAR(N' ')Yes*KATR6 Allow NULL? 
73KATR7Attribute 7nvarchar30CHAR(N' ')Yes*KATR7 Allow NULL? 
74KATR8Attribute 8nvarchar30CHAR(N' ')Yes*KATR8 Allow NULL? 
75KATR9Attribute 9nvarchar30CHAR(N' ')Yes*KATR9 Allow NULL? 
76KATR10Attribute 10nvarchar30CHAR(N' ')Yes*KATR10 Allow NULL? 
77PAVIPVIP Partnerchar10CHAR(N' ')Yes*PAVIP Allow NULL? 
78FAMSTMarital Status Keychar10CHAR(N' ')Yes*FAMST Allow NULL? 
79PARGE_LISPartner's genderchar10CHAR(N' ')YesPARGE Allow NULL? 
80ABTNRDepartment numbernvarchar40CHAR(N' ')Yes*ABTNR Allow NULL? 
81PAFKTContact person functionnvarchar20CHAR(N' ')Yes*PAFKT Allow NULL? 
82PARVOPartner's Authoritychar10CHAR(N' ')Yes*PARVO Allow NULL? 
83AKVERBuying habitsnvarchar20CHAR(N' ')Yes*AKVER Allow NULL? 
84PARH1Contact person: Attribute 1nvarchar20CHAR(N' ')Yes*PAAT1 Allow NULL? 
85PARH2Contact person: Attribute 2nvarchar20CHAR(N' ')Yes*PAAT2 Allow NULL? 
86PARH3Contact person: Attribute 3nvarchar20CHAR(N' ')Yes*PAAT3 Allow NULL? 
87PARH4Contact person: Attribute 4nvarchar20CHAR(N' ')Yes*PAAT4 Allow NULL? 
88PARH5Contact person: Attribute 5nvarchar20CHAR(N' ')Yes*PAAT5 Allow NULL? 
89PAKN1Contact person: Attribute 6nvarchar30CHAR(N' ')Yes*PAAT6 Allow NULL? 
90PAKN2Contact person: Attribute 7nvarchar30CHAR(N' ')Yes*PAAT7 Allow NULL? 
91PAKN3Contact person: Attribute 8nvarchar30CHAR(N' ')Yes*PAAT8 Allow NULL? 
92PAKN4Contact person: Attribute 9nvarchar30CHAR(N' ')Yes*PAAT9 Allow NULL? 
93PAKN5Contact person: Attribute 10nvarchar30CHAR(N' ')Yes*PAAT0 Allow NULL? 
94PSTLZ_LISPostal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
95PSTL2_LISP.O. Box Postal Codenvarchar100CHAR(N' ')YesPSTL2 Allow NULL? 
96PSTL_LISPostal code of city or PO boxnvarchar100CHAR(N' ')YesPSTL_LIS Allow NULL? 
97LAND1_LISCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
98REGIO_LISRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
NamePrimaryUniqueTypeColumns
SADLSTRECB~0YesYesCLUSTEREDCOUNTER, BLKNR, VERSION, LISTNR, 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