AUFI SAP (Allocation Table, Document Sub-item, Stores) Table details

Dictionary Type: Table
Description: Allocation Table, Document Sub-item, Stores




ABAP Code to SELECT data from AUFI
Related tables to AUFI
Access table AUFI




Table field list including key, data, relationships and ABAP select examples

AUFI is a standard SAP Table which is used to store Allocation Table, Document Sub-item, Stores data and is available within R/3 SAP systems depending on the version and release level.

The AUFI table consists of various fields, each holding specific information or linking keys about Allocation Table, Document Sub-item, Stores data available in SAP. These include ABELN (Allocation Table Number), ABELP (Item number of allocation table), ABELG (Sub-item no. of plant group (alloc tbl)), ABELF (Sub.item no. of plant (alloc. tbl)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AUFI table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ABELNAllocation Table Number ABELNCHAR10AUKOALPHAABELNABE
ABELPItem number of allocation table ABELPNUMC5AUPOABELP
ABELGSub-item no. of plant group (alloc tbl) ABELGNUMC5AUFGABELG
ABELFSub.item no. of plant (alloc. tbl) ABELFNUMC5ABELF
FILNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
FIWRKStore as plant FIWRKCHAR4T001WWERKSWRK
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
LFNRUAccount no. of vendor / creditor of sub-item LFNRUCHAR10LFA1ALPHALIFNRLIF
PMNGUPlanned qty of sub-item PMNGUQUAN13(3) MENG13
IMNGUConfirmed qty of plant IMNGUQUAN13(3) MENG13
MMNGUMinimum Quantity of Plant in Plant Group MMNGUQUAN13(3) MENG13
WMNGEQuantity requested by store WMNGEQUAN13(3) MENG13
AUFMEAllocation Unit AUFMEUNIT3T006CUNITMEINS
LIEFWFlag: delivery phase exists LIEFWCHAR1CHAR1
EBLNUPurchase Order Generated for Vendor EBLNUCHAR10Assigned to domainALPHAEBELNBES
EBLPUGenerated purchase order item EBLPUNUMC5Assigned to domainEBELPPOS
UBSTNGenerated warehouse order UBSTNCHAR10Assigned to domainALPHAEBELNBES
UBSTPGenerated stock transport order item UBSTPNUMC5Assigned to domainEBELPBSP
VBLNUGenerated delivery number VBLNUCHAR10Assigned to domainALPHAVBELNAUN
VBLPUGenerated delivery note item VBLPUNUMC6Assigned to domainPOSNR
BEDATPurchase Order Date BEDATDATS8DATUM
BEDTPDate type (day, week, month, interval) PRGRSCHAR1PRGRS
VKDATDate of start of sales at plant VKIDTDATS8DATUM
VKTYPDate type (day, week, month, interval) PRGRSCHAR1PRGRS
LEWEDLatest Possible Goods Receipt LEWEDDATS8DATUM
VZENTDistribution center (as customer) VZENTCHAR10KNA1ALPHAKUNNR
VZWRKDistribution center as plant VZWRKCHAR4T001WWERKSVZW
VZLFRVendor number of plant LIFNR_WKCHAR10LFA1ALPHALIFNR
AAVITNotification Category Allocation: Info Exchance HQ - Plant AAVITCHAR4T626AAVIT
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
ABFDTConfirmation request date AFIDTDATS8DATUM
ABFTPDate type (day, week, month, interval) PRGRSCHAR1PRGRS
PSTABMaint. status of plant PSTABCHAR1PSTAK
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
BSTMGPurchase Order Quantity BSTMGQUAN13(3) MENG13
BSTMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
UMLMGPurchase Order Quantity BSTMGQUAN13(3) MENG13
UMLMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
LFMNGGR qty assigned after alloc tbl adjustment made EFMNGQUAN13(3) MENG13
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
SPERRBlocking flag, plant SPBTRCHAR1T629SPERR_A
VQUOTQuotas (Base for qty calculation) VQUOTNUMC13VQUOT
WMERFSingle-Character Indicator CHAR1CHAR1CHAR1
BMERFSingle-Character Indicator CHAR1CHAR1CHAR1
BEWZAEvaluation figure of plant UPOBZNUMC13UPOBZ
LABSTValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
HMNGUMaximum Quantity for Plants in Plant Group HMNGUQUAN13(3) MENG13
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
LAND1Country Key LAND1CHAR3T005LAND1LND
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
ABFSTStatus plant notification ABFSTCHAR1ASTAB
ABASTDetails status, plant notification ABASTCHAR1ABAST
BLGTPDoc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble BLGTPCHAR1BLGTP
EXPECTED_SALESEvaluation figure of plant UPOBZNUMC13UPOBZ
OPEN_ORDERSPurchase Order Quantity BSTMGQUAN13(3) MENG13
TREND_FACTORTrend Factor TREND_ALLNUMC4NUMC04

Key field Non-key field



How do I retrieve data from SAP table AUFI using ABAP code

The following ABAP code Example will allow you to do a basic selection on AUFI to SELECT all data from the table
DATA: WA_AUFI TYPE AUFI.

SELECT SINGLE *
FROM AUFI
INTO CORRESPONDING FIELDS OF WA_AUFI
WHERE...

How to access SAP table AUFI

Within an ECC or HANA version of SAP you can also view further information about AUFI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!