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  | VBLB
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
Sales and Distribution :: Sales
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBLB571Sales document: Release order dataSales
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, ABRLI, ABART, DOCNUM, ABEFZ, ABRAB, ABRBI, LABNK, ABRDT, TERSL, LFDKD, LFNKD, ABFDA, ABFDE, ABMDA, ABMDE, ABLLI, HIFFZ, HIFFZLI, HIMFZ, HIMFZLI, ERDAT, ERZEI, ERNAM, HILFZ, HILFZLI, ABHOR, GJKUN, VJKUN, AKMFZ, AKFFZ, AKLFZ, KRITB, LABKY, VBRST, EDLLS, EDLDT, LFMKD, UMVKZ, UMVKN, USR01, USR02, USR03, USR04, USR05, CYEFZ, CYDAT, MFLAUF, MFEIN, FFLAUF, FFEIN, ABRDT_ORG, LFMAIS, MAIDT, AEDAT FROM VBLB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNSales Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VA Allow NULL? 
3POSNRSales Document Itemnvarchar60NUMC(N'000000')NoVBUPPOSNR_VA Allow NULL? 
4ABRLIInternal delivery schedule numbernvarchar40NUMC(N'0000')NoABRLI Allow NULL? 
5ABARTRelease typechar10CHAR(N' ')NoABART Allow NULL? 
6DOCNUMIDoc numbernvarchar160NUMC(N'0000000000000000')NoEDI_DOCNUM Allow NULL? 
7ABEFZCumulative Quantity Received by Customerdecimal153QUAN((0))NoABKFZ
8ABRABDlv. sched. valid fromnvarchar80DATS(N'00000000')NoABRAB Allow NULL? 
9ABRBISA rel. valid tonvarchar80DATS(N'00000000')NoABRBI Allow NULL? 
10LABNKCustomer number for forecast / JIT dlv. sched.nvarchar170CHAR(N' ')NoLABNK Allow NULL? 
11ABRDTDelivery Schedule Datenvarchar80DATS(N'00000000')NoABRDT Allow NULL? 
12TERSLDate key for schedule line dateschar10CHAR(N' ')NoTERSL Allow NULL? 
13LFDKDDate of last delivery posted by the customernvarchar80DATS(N'00000000')NoLFDKD Allow NULL? 
14LFNKDLast delivery confirmed by the customernvarchar100CHAR(N' ')NoLIKPLFNKD Allow NULL? 
15ABFDAStart of production go-aheadnvarchar80DATS(N'00000000')NoABFDA Allow NULL? 
16ABFDEEnd of production go-aheadnvarchar80DATS(N'00000000')NoABFDE Allow NULL? 
17ABMDAStart of material go-aheadnvarchar80DATS(N'00000000')NoABMDA Allow NULL? 
18ABMDEEnd of material go-aheadnvarchar80DATS(N'00000000')NoABMDE Allow NULL? 
19ABLLILast internal release order numbernvarchar40NUMC(N'0000')NoVBLBABLLI Allow NULL? 
20HIFFZHighest cumulative production go-ahead quantitydecimal153QUAN((0))NoHIFFZ
21HIFFZLIInternal schedule no.for highest prod.go-ahead cml.qtynvarchar40NUMC(N'0000')NoVBLBHIFFZLI Allow NULL? 
22HIMFZHighest cumulative material go-ahead quantitydecimal153QUAN((0))NoHIMFZ
23HIMFZLIInternal schedule number for highest mat.go-ahead cml.qtynvarchar40NUMC(N'0000')NoVBLBHIMFZLI Allow NULL? 
24ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
25ERZEIEntry timenvarchar60TIMS(N'000000')NoERZET Allow NULL? 
26ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
27HILFZHighest delivery go-ahead cumulative quantitydecimal153QUAN((0))NoHILFZ
28HILFZLIInternal schedule number for highest dlv.go-ahead cml.qtynvarchar40NUMC(N'0000')NoVBLBHILFZLI Allow NULL? 
29ABHORJIT horizonnvarchar80DATS(N'00000000')NoABHOR Allow NULL? 
30GJKUNCustomer fiscal yearnvarchar40NUMC(N'0000')NoGJKUN Allow NULL? 
31VJKUNCustomer fiscal year which is not yet closednvarchar40NUMC(N'0000')NoVJKUN Allow NULL? 
32AKMFZActual cumulative material go-ahead quantitydecimal153QUAN((0))NoAKMFZ
33AKFFZActual cumulative production go-ahead quantitydecimal153QUAN((0))NoAKFFZ
34AKLFZActual cumulative delivery go-ahead quantitydecimal153QUAN((0))NoAKLFZ
35KRITBKey for high priority stockchar10CHAR(N' ')NoKRITB Allow NULL? 
36LABKYRequirements status keychar10CHAR(N' ')NoBSTAS Allow NULL? 
37VBRSTCustomer point of consumptionnvarchar140CHAR(N' ')NoVBRST Allow NULL? 
38EDLLSLast dlv. note sent by ext. service agent to the customernvarchar200CHAR(N' ')NoLFEDL Allow NULL? 
39EDLDTDate of last delivery sent by external agent to customernvarchar80DATS(N'00000000')NoEDLDT Allow NULL? 
40LFMKDLast delivery quantity received by the customerdecimal133QUAN((0))NoLFMKD
41UMVKZNumerator (factor) for conversion of sales quantity into SKUdecimal50DEC((0))NoUMVKZ
42UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUdecimal50DEC((0))NoUMVKN
43USR01Additional data field 1 for delivery schedulesnvarchar350CHAR(N' ')NoUSR01_D Allow NULL? 
44USR02Additional data field 2 for delivery schedulesnvarchar350CHAR(N' ')NoUSR02_D Allow NULL? 
45USR03Additional data field 3 for delivery schedulesnvarchar350CHAR(N' ')NoUSR03_D Allow NULL? 
46USR04Additional data field 4 for delivery schedulesnvarchar100CHAR(N' ')NoUSR04_D Allow NULL? 
47USR05Additional data field 5 for delivery schedulesnvarchar100CHAR(N' ')NoUSR05_D Allow NULL? 
48CYEFZCumulative quantity reached on date zero setting madedecimal153QUAN((0))YesCYEFZ
49CYDATDate on which cumulative received quantity set to zeronvarchar80DATS(N'00000000')YesCYDAT Allow NULL? 
50MFLAUFMaterial go-ahead - validity periodnvarchar30NUMC(N'000')YesMFLAUF Allow NULL? 
51MFEINMaterial go-ahead - unit validity periodchar10CHAR(N' ')YesMFEIN Allow NULL? 
52FFLAUFProduction go-ahead - validity periodnvarchar30NUMC(N'000')YesFFLAUF Allow NULL? 
53FFEINProduction go-ahead - Unit validity periodchar10CHAR(N' ')YesFFEIN Allow NULL? 
54ABRDT_ORGDelivery schedule date of creationnvarchar80DATS(N'00000000')YesABRDT_ORG Allow NULL? 
55LFMAISLast pick-up sheet sent by the customernvarchar200CHAR(N' ')YesLFMAIS Allow NULL? 
56MAIDTDate of last pick-up sheetnvarchar80DATS(N'00000000')YesMAIDT Allow NULL? 
57AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
VBLB~0YesYesCLUSTEREDMANDT, VBELN, POSNR, ABRLI, ABART

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