1. Home
  2. Resources
  3. SAP Tables
  4. AFFW - Goods Movements with Errors from Confirmations

SAP Table AFFW

Goods Movements with Errors from Confirmations

AFFW (Goods Movements with Errors from Confirmations) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFFW to other SAP tables.

AFFW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
WEBLNR Number of a document from a goods movement with errors WEBLNR CHAR 10 0
WEBLPOS Internal counter CIM_COUNT NUMC 8 0
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS TCURC CUKY 5 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
KZEAR Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP CHAR 10 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Internal counter CIM_COUNT NUMC 8 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
MSGID Application Area ARBGB T100A CHAR 20 0
MSGNO System Message Number MSGNO T100 CHAR 3 0
MSGTY Message Type MSGTY CHAR 1 0
S Message on next screen
I Information
A Cancel
E Error
W Warning
MSGV1 Message variable 01 MSGV1 CHAR 50 0
MSGV2 Message variable 02 MSGV2 CHAR 50 0
MSGV3 Message variable 03 MSGV3 CHAR 50 0
MSGV4 Message variable 04 MSGV4 CHAR 50 0
WABLNR Number of Material Document MBLNR CHAR 10 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
FEVOR Production Supervisor FEVOR T024F CHAR 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
FWDAT Date when the error first arose CO_FWDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
SMBLN Number of Material Document MBLNR CHAR 10 0
SMBLP Item in Material Document MBLPO NUMC 4 0
SJAHR Material Document Year MJAHR NUMC 4 0
RSART Record type RSART CHAR 1 0
MHDAT SLED/Best-Before Date or Date of Production TMHHD DATS 8 0
DNOTW Indicator: Dialog necessary DNOTW CHAR 1 0
X Yes
NULL No
MJAHR Material Document Year MJAHR NUMC 4 0
MBLPO Item in Material Document MBLPO NUMC 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ERZET Entry time ERZET TIMS 6 0
FWZET Time when the error first arose CO_FWZET TIMS 6 0
PRVBE Production Supply Area PRVBE CHAR 10 0
PRTNR Confirmation number PRTNR NUMC 10 0
REFBLN Reference doc. number for linked entries in AFFW RU_WEBLNR CHAR 10 0
INACT Indicator: Planned confirmation RU_VRMKZ CHAR 1 0
X Yes
NULL No
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
PARBU Clearing company code PARBU CHAR 4 0
GRUND Reason for Movement MB_GRBEW NUMC 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
KUNNR Account Number of Customer EKUNN CHAR 10 0
BERKZ Material Staging Indicator for Production Supply BERKZ CHAR 1 0
0 Not relevant for WM
1 Pick list item
2 Crate part
3 Rel.ord.part
4 Manual staging
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6 0
BATCH_TYPE Type of Batch BATCH_TYPE CHAR 1 0
NULL Batch
1 WIP Batch
LICHA Vendor Batch Number LICHN CHAR 15 0
/CWM/ERFMG Quantity in Parallel Unit of Entry /CWM/ERFMG QUAN 13 3
/CWM/ERFME PUoM Entry Unit of Measure /CWM/ERFME UNIT 3 0

AFFW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFFW AUFNR AFFW MANDT AUFK Order master data MANDT
AFFW AUFNR AFFW AUFNR AUFK Order master data AUFNR
AFFW BEMOT AFFW MANDT TBMOT Accounting indicators MANDT
AFFW BEMOT AFFW BEMOT TBMOT Accounting indicators BEMOT
AFFW BWART AFFW MANDT T156 Movement Type MANDT
AFFW BWART AFFW BWART T156 Movement Type BWART
AFFW CHARG AFFW MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
AFFW CHARG AFFW MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
AFFW CHARG AFFW CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
AFFW DISPO AFFW MANDT T024D MRP controllers MANDT
AFFW DISPO AFFW WERKS T024D MRP controllers WERKS
AFFW DISPO AFFW DISPO T024D MRP controllers DISPO
AFFW ERFME AFFW MANDT T006 Units of Measurement MANDT
AFFW ERFME AFFW ERFME T006 Units of Measurement MSEHI
AFFW FEVOR AFFW MANDT T024F Production scheduler MANDT
AFFW FEVOR AFFW WERKS T024F Production scheduler WERKS
AFFW FEVOR AFFW FEVOR T024F Production scheduler FEVOR
AFFW KDAUF AFFW MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
AFFW KDAUF AFFW KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
AFFW LGNUM AFFW MANDT T300 WM Warehouse Numbers MANDT
AFFW LGNUM AFFW LGNUM T300 WM Warehouse Numbers LGNUM
AFFW LGORT AFFW LGORT T001L Storage Locations LGORT
AFFW LGORT AFFW MANDT T001L Storage Locations MANDT
AFFW LGORT AFFW WERKS T001L Storage Locations WERKS
AFFW LGPLA AFFW LGTYP LAGP Storage bins LGTYP
AFFW LGPLA AFFW LGPLA LAGP Storage bins LGPLA
AFFW LGPLA AFFW MANDT LAGP Storage bins MANDT
AFFW LGPLA AFFW LGNUM LAGP Storage bins LGNUM
AFFW LGTYP AFFW MANDT T301 WM Storage Types MANDT
AFFW LGTYP AFFW LGNUM T301 WM Storage Types LGNUM
AFFW LGTYP AFFW LGTYP T301 WM Storage Types LGTYP
AFFW LIFNR AFFW MANDT LFA1 Vendor Master (General Section) MANDT
AFFW LIFNR AFFW LIFNR LFA1 Vendor Master (General Section) LIFNR
AFFW MATNR AFFW MANDT MARA General Material Data MANDT
AFFW MATNR AFFW MATNR MARA General Material Data MATNR
AFFW MSGID AFFW MSGID T100A Message IDs for T100 ARBGB
AFFW MSGNO SYST LANGU T100 Messages SPRSL
AFFW MSGNO AFFW MSGID T100 Messages ARBGB
AFFW MSGNO AFFW MSGNO T100 Messages MSGNR
AFFW SOBKZ AFFW SOBKZ T148 Special Stock Indicator SOBKZ
AFFW SOBKZ AFFW MANDT T148 Special Stock Indicator MANDT
AFFW WAERS AFFW WAERS TCURC Currency Codes WAERS
AFFW WAERS AFFW MANDT TCURC Currency Codes MANDT
AFFW WERKS AFFW MANDT T001W Plants/Branches MANDT
AFFW WERKS AFFW WERKS T001W Plants/Branches WERKS