AFFW SAP (Goods Movements with Errors from Confirmations) Table details

Dictionary Type: Table
Description: Goods Movements with Errors from Confirmations




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




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

AFFW is a standard SAP Table which is used to store Goods Movements with Errors from Confirmations data and is available within R/3 SAP systems depending on the version and release level.

The AFFW table consists of various fields, each holding specific information or linking keys about Goods Movements with Errors from Confirmations data available in SAP. These include WEBLNR (Number of a document from a goods movement with errors), WEBLPOS (Internal counter), ERSDA (Created On), ERNAM (Name of Person who Created the Object).. 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 AFFW 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 MANDTCLNT3Assigned to domainMANDT
WEBLNRNumber of a document from a goods movement with errors WEBLNRCHAR10ALPHABELNR
WEBLPOSInternal counter CIM_COUNTNUMC8CIM_COUNT
ERSDACreated On ERSDADATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
LAEDADate of Last Change LAEDADATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
KZVBRConsumption Posting KZVBRCHAR1KZVBR
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
WEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
ABLADUnloading Point ABLADCHAR25TEXT25
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
KZBEWMovement Indicator KZBEWCHAR1KZBEW
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
RUECKCompletion confirmation number for the operation CO_RUECKNUMC10CO_RUECKRCK
RMZHLInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPSOrder Item Number CO_POSNRNUMC4CO_POSNR
MSGIDApplication Area ARBGBCHAR20T100AARBGBMAG
MSGNOSystem Message Number MSGNOCHAR3T100MSGNR
MSGTYMessage Type MSGTYCHAR1MSGAR
MSGV1Message variable 01 MSGV1CHAR50CHAR50
MSGV2Message variable 02 MSGV2CHAR50CHAR50
MSGV3Message variable 03 MSGV3CHAR50CHAR50
MSGV4Message variable 04 MSGV4CHAR50CHAR50
WABLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
AUTYPOrder category AUFTYPNUMC2AUFTYP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
INSMKStock Type INSMKCHAR1INSMK
FEVORProduction Supervisor FEVORCHAR3T024FFEVORCFV
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
FWDATDate when the error first arose CO_FWDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
SMBLNNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
SMBLPItem in Material Document MBLPONUMC4MBLPOPOS
SJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
RSARTRecord type RSARTCHAR1RSART
MHDATSLED/Best-Before Date or Date of Production TMHHDDATS8DATUM
DNOTWIndicator: Dialog necessary DNOTWCHAR1XFELD
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MBLPOItem in Material Document MBLPONUMC4MBLPOPOS
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
ERZETEntry time ERZETTIMS6UZEIT
FWZETTime when the error first arose CO_FWZETTIMS6UZEIT
PRVBEProduction Supply Area PRVBECHAR10Assigned to domainPRVBEPVB
PRTNRConfirmation number PRTNRNUMC10Assigned to domainPRTNRCONFNUMBER
REFBLNReference doc. number for linked entries in AFFW RU_WEBLNRCHAR10ALPHABELNR
INACTIndicator: Planned confirmation RU_VRMKZCHAR1XFELD
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
PARBUClearing company code PARBUCHAR4Assigned to domainBUKRS
GRUNDReason for Movement MB_GRBEWNUMC4Assigned to domainMB_GRBEW
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
KUNNRAccount Number of Customer EKUNNCHAR10Assigned to domainALPHAKUNNRKUN
BERKZMaterial Staging Indicator for Production Supply BERKZCHAR1LVS_BERKZ
LINE_IDUnique identification of document line MB_LINE_IDNUMC6MB_LINE_ID
BATCH_TYPEType of Batch BATCH_TYPECHAR1BATCH_TYPE
LICHAVendor Batch Number LICHNCHAR15LICHN
.INCLU--AP 0
XPCBTSingle-Unit Batch Indicator MILL_XPCBTCHAR1MILL_XPCBT
.INCLU--AP 0
FLG_ORIGBackflush Origin PPC_FLG_ORIGCHAR1PPC_FLG_ORIG

Key field Non-key field



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

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

SELECT SINGLE *
FROM AFFW
INTO CORRESPONDING FIELDS OF WA_AFFW
WHERE...

How to access SAP table AFFW

Within an ECC or HANA version of SAP you can also view further information about AFFW 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!