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  | AUPO
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
Logistics - General :: Merchandise Distribution :: Allocation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AUPO732Allocation Table Document ItemAllocation
SQL:  selectupdate insert create

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

SELECT MANDT, ABELN, ABELP, APSTP, ASTAP, PSTAP, SPERR, ERDAT, AEDAT, ERNAM, AENAM, RFKTN, RFKTP, RSNUM, RSPOS, EBELN, EBELP, AKTNR, AKTPO, MATNR, MAKTX, BWART, VZWRK, LIFNR, SBELN, FIKLI, FILKL, PMNGE, IMNGE, MMNGE, AUFME, MEINS, UZAEH, UNENN, LISTG, MANUE, RUNDG, RESTV, ASTRA, LIEFW, VKSDT, VKSTP, AAVIT, MATKL, VZENT, VZLFR, BSART, UMART, BSART_GL_BUKRS, LFART, ABFDT, ABFTP, SVFIX, SIMAM, LGORT, HMNGE, KETYP, VBELN, VBELP, SAPOS, ATTYP, RETPO, BERMIMA, KAART, NREMFIN, EXT_REF_ID, ASTRA_VAR, ERVON, WRF_HIER_CNT, WRF_CDT_LEVEL, WRF_STRUC_NODE, PLID, CONS_MODE FROM AUPO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ABELNAllocation Table Numbernvarchar100CHAR(N' ')NoAUKOABELN Allow NULL? 
3ABELPItem number of allocation tablenvarchar50NUMC(N'00000')NoABELP Allow NULL? 
4APSTPItem category of allocation tablenvarchar40CHAR(N' ')NoT621APSTP Allow NULL? 
5ASTAPActivity status of allocation table itemchar10CHAR(N' ')NoASTAP Allow NULL? 
6PSTAPMaintenance status of alloc. table itemchar10CHAR(N' ')NoPSTAP Allow NULL? 
7SPERRBlocking flag: itemchar10CHAR(N' ')NoT629SPPOS Allow NULL? 
8ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
9AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
10ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
11AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')NoAENAM Allow NULL? 
12RFKTNReference outline agreementnvarchar100CHAR(N' ')NoEKKORFKTN Allow NULL? 
13RFKTPReference outline agreement itemnvarchar50NUMC(N'00000')NoEKPORFKTP Allow NULL? 
14RSNUMNumber of Reservation/Dependent Requirementnvarchar100NUMC(N'0000000000')No*RSNUM Allow NULL? 
15RSPOSItem Number of Reservation/Dependent Requirementnvarchar40NUMC(N'0000')NoRSPOS Allow NULL? 
16EBELNPurchasing Document Numbernvarchar100CHAR(N' ')NoEKKOEBELN Allow NULL? 
17EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')NoEKPOEBELP Allow NULL? 
18AKTNRPromotionnvarchar100CHAR(N' ')NoWAKHWAKTION Allow NULL? 
19AKTPOSub-item for units of measurenvarchar20NUMC(N'00')NoW_MEPOS Allow NULL? 
20MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
21MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')NoMAKTX Allow NULL? 
22BWARTValuation Typenvarchar100CHAR(N' ')NoT149DBWTAR_D Allow NULL? 
23VZWRKDistribution center as plantnvarchar40CHAR(N' ')NoT001WVZWRK Allow NULL? 
24LIFNRVendor Account Numbernvarchar100CHAR(N' ')NoLFA1ELIFN Allow NULL? 
25SBELNNo. of allocation rulenvarchar100CHAR(N' ')No*SBELN Allow NULL? 
26FIKLIInternal class number, plantnvarchar100NUMC(N'0000000000')NoKLAHFCLIN Allow NULL? 
27FILKLPlant group (technical plant class)nvarchar180CHAR(N' ')NoFILKL Allow NULL? 
28PMNGEPlanned Quantity of Itemdecimal133QUAN((0))NoPMNGE
29IMNGEConfirmed qty of itemdecimal133QUAN((0))NoIMNGE
30MMNGEMinimum Quantity Per Plantdecimal133QUAN((0))NoMMNGE
31AUFMEAllocation Unitnvarchar30UNIT(N' ')NoT006AUFME Allow NULL? 
32MEINSBase Unit of Measurenvarchar30UNIT(N' ')NoT006MEINS Allow NULL? 
33UZAEHNumerator for conversion to base units of measuredecimal50DEC((0))NoUZAEH
34UNENNDenominator for conversion to base units of measuredecimal50DEC((0))NoUNENN
35LISTGListing Indicatorchar10CHAR(N' ')NoLISTG Allow NULL? 
36MANUEFlag: allocation table manually changedchar10CHAR(N' ')NoMANUE Allow NULL? 
37RUNDGRounding off in allocation tablechar10CHAR(N' ')NoRUNDG Allow NULL? 
38RESTVSplit remainderchar10CHAR(N' ')NoRESTV Allow NULL? 
39ASTRAAllocation Strategynvarchar40CHAR(N' ')NoT627ASTRA Allow NULL? 
40LIEFWFlag: delivery phase existschar10CHAR(N' ')NoLIEFW Allow NULL? 
41VKSDTDate of start of sales at plantnvarchar80DATS(N'00000000')NoVKIDT Allow NULL? 
42VKSTPDate type (day, week, month, interval)char10CHAR(N' ')NoPRGRS Allow NULL? 
43AAVITNotification Category Allocation: Info Exchance HQ - Plantnvarchar40CHAR(N' ')YesT626AAVIT Allow NULL? 
44MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
45VZENTDistribution center (as customer)nvarchar100CHAR(N' ')YesKNA1VZENT Allow NULL? 
46VZLFRVendor number of plantnvarchar100CHAR(N' ')YesLFA1LIFNR_WK Allow NULL? 
47BSARTOrder type in allocation table (for external vendor)nvarchar40CHAR(N' ')YesT161BSART_LIEF Allow NULL? 
48UMARTOrder type in allocation table (for warehouse/DC)nvarchar40CHAR(N' ')YesT161BSART_LAGER Allow NULL? 
49BSART_GL_BUKRSReplacement order type in alloc tbl in same company codenvarchar40CHAR(N' ')YesT161BSART_GL_BUKRS Allow NULL? 
50LFARTDelivery type of allocation tablenvarchar40CHAR(N' ')YesTVLKLFART_AUFT Allow NULL? 
51ABFDTConfirmation request datenvarchar80DATS(N'00000000')YesAFIDT Allow NULL? 
52ABFTPDate type (day, week, month, interval)char10CHAR(N' ')YesPRGRS Allow NULL? 
53SVFIXPlants fixed in ARchar10CHAR(N' ')YesSVFIX Allow NULL? 
54SIMAMAlloc tbl qty simulationchar10CHAR(N' ')YesSIMAM Allow NULL? 
55LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
56HMNGEMaximum Quantity Per Plantdecimal133QUAN((0))YesHMNGE
57KETYPKey Figure Categorychar10CHAR(N' ')Yes*KETYP Allow NULL? 
58VBELNDeliverynvarchar100CHAR(N' ')YesLIKPVBELN_VL Allow NULL? 
59VBELPDelivery Itemnvarchar60NUMC(N'000000')YesLIPSPOSNR_VL Allow NULL? 
60SAPOSNumber of alloc tbl item of material on higher levelnvarchar50NUMC(N'00000')Yes*POSNR_SA Allow NULL? 
61ATTYPMaterial Categorynvarchar20CHAR(N' ')YesATTYP Allow NULL? 
62RETPOReturns Itemchar10CHAR(N' ')YesRETPO Allow NULL? 
63BERMIMAInclude Minimum and Maximum Quantitieschar10CHAR(N' ')YesBERMIMA Allow NULL? 
64KAARTSales Document Typenvarchar40CHAR(N' ')YesTVAKAUART Allow NULL? 
65NREMFINNumber of Recipient Determinationnvarchar40CHAR(N' ')YesEMFINNREMFIN Allow NULL? 
66EXT_REF_IDExternal Reference Numbernvarchar250CHAR(N' ')YesRDM_EXT_REF_ID Allow NULL? 
67ASTRA_VARAllocation Strategy Variantnvarchar140CHAR(N' ')Yes*ASTRA_VAR Allow NULL? 
68ERVONApplication creating allocation tablechar10CHAR(N' ')YesERVON Allow NULL? 
69WRF_HIER_CNTHierarchynvarchar20CHAR(N' ')YesWRF_HIER_CNT Allow NULL? 
70WRF_CDT_LEVELHierarchy Levelnvarchar20NUMC(N'00')YesWRF_CDT_LEVEL Allow NULL? 
71WRF_STRUC_NODEHierarchy Nodenvarchar180CHAR(N' ')YesWRF_STRUC_NODE Allow NULL? 
72PLIDPurchasing List Numbernvarchar100CHAR(N' ')Yes*WRF_PLID Allow NULL? 
73CONS_MODEConsignment Processing in Allocation Tablechar10CHAR(N' ')YesWRF_AT_CONS_MODE Allow NULL? 
NamePrimaryUniqueTypeColumns
AUPO~0YesYesCLUSTEREDABELP, ABELN, MANDT
AUPO~A01NoNoNONCLUSTEREDMATNR

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