SAP AFFW Goods Movements with Errors from Confirmations Table
Overview
AFFW is a standard SAP S/4HANA table that stores Goods Movements with Errors from Confirmations data. There are total 87 fields in the AFFW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFFW belongs to Confirmations (PP-SFC-EXE-CON) module and is located in the package R/3 Application development: PP Confirmations (CORU).
In addition, following links provide an overview of foreign key relationships, if any, that link AFFW to other SAP tables and standard CDS views available based on AFFW table in S/4HANA 2020.
Techincal Settings of AFFW
Below are technical details of the table AFFW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFFW Fields
The following table gives you an overview of the fields available in AFFW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10 | |
| WEBLPOS | Internal counter | CIM_COUNT | NUMC | 8 | |
| ERSDA | Created On | ERSDA | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| BWART | Movement type (inventory management) | BWART | T156 | CHAR | 3 |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 |
| KZVBR | Consumption posting | KZVBR | CHAR | 1 | |
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC | 6 | |
| KDEIN | Delivery schedule for sales order | KDEIN | NUMC | 4 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| ERFMG | Quantity in unit of entry | ERFMG | QUAN | 13 | |
| ERFME | Unit of entry | ERFME | T006 | UNIT | 3 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| WEMPF | Goods Recipient | WEMPF | CHAR | 12 | |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 10 | |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| KZEAR | Final issue for this reservation | KZEAR | CHAR | 1 | |
| KZBEW | Movement Indicator | KZBEW | CHAR | 1 | |
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 |
| LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 |
| LGPLA | Storage Bin | LGPLA | LAGP | CHAR | 10 |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| AUFPS | Order item number | CO_POSNR | NUMC | 4 | |
| MSGID | Application Area | ARBGB | T100A | CHAR | 20 |
| MSGNO | System Message Number | MSGNO | T100 | CHAR | 3 |
| MSGTY | Message Type | MSGTY | CHAR | 1 | |
| MSGV1 | Message variable 01 | MSGV1 | CHAR | 50 | |
| MSGV2 | Message variable 02 | MSGV2 | CHAR | 50 | |
| MSGV3 | Message variable 03 | MSGV3 | CHAR | 50 | |
| MSGV4 | Message variable 04 | MSGV4 | CHAR | 50 | |
| WABLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| AUTYP | Order category | AUFTYP | NUMC | 2 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| INSMK | Stock Type | INSMK | CHAR | 1 | |
| FEVOR | Production Supervisor | FEVOR | T024F | CHAR | 3 |
| DISPO | MRP Controller | DISPO | T024D | CHAR | 3 |
| FWDAT | Date when the Error first arose | CO_FWDAT | DATS | 8 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | |
| SMBLN | Number of Material Document | MBLNR | CHAR | 10 | |
| SMBLP | Item in Material Document | MBLPO | NUMC | 4 | |
| SJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| RSART | Record type | RSART | CHAR | 1 | |
| MHDAT | SLED/Best-Before Date or Date of Production | TMHHD | DATS | 8 | |
| DNOTW | Indicator: Dialog necessary | DNOTW | CHAR | 1 | |
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| MBLPO | Item in Material Document | MBLPO | NUMC | 4 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| FWZET | Time when the Error first arose | CO_FWZET | TIMS | 6 | |
| PRVBE | Production Supply Area | PRVBE | CHAR | 10 | |
| PRTNR | Confirmation number | PRTNR | NUMC | 10 | |
| REFBLN | Reference doc. number for linked entries in AFFW | RU_WEBLNR | CHAR | 10 | |
| INACT | Indicator: Planned confirmation | RU_VRMKZ | CHAR | 1 | |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| PARBU | Clearing company code | PARBU | CHAR | 4 | |
| GRUND | Reason for Movement | MB_GRBEW | NUMC | 4 | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | |
| KUNNR | Account number of customer | EKUNN | CHAR | 10 | |
| BERKZ | Material Staging Indicator for Production Supply | BERKZ | CHAR | 1 | |
| LINE_ID | Unique identification of document line | MB_LINE_ID | NUMC | 6 | |
| BATCH_TYPE | Type of Batch | BATCH_TYPE | CHAR | 1 | |
| LICHA | Supplier Batch Number | LICHN | CHAR | 15 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40 | |
| MPE_GM_FLG | Goods Movement is from Manufacturing Processing Execution | MPE_GM_ORIGIN | CHAR | 1 | |
| SERNP | Serial Number Profile | SERAIL | CHAR | 4 | |
| ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | |
| /CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | QUAN | 13 | |
| /CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | UNIT | 3 | |
| XPCBT | Single-Unit Batch Indicator | MILL_XPCBT | CHAR | 1 | |
| FLG_ORIG | Backflush Origin | PPC_FLG_ORIG | CHAR | 1 | |
| VERID | Production Version | VERID | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFFW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFFW | AUFNR | C: CN | AUFK |
| AFFW | BEMOT | : | TBMOT |
| AFFW | BWART | C: CN | T156 |
| AFFW | CHARG | : | MCH1 |
| AFFW | DISPO | C: CN | T024D |
| AFFW | ERFME | : | T006 |
| AFFW | FEVOR | C: CN | T024F |
| AFFW | LGNUM | : | T300 |
| AFFW | LGORT | C: CN | T001L |
| AFFW | LGPLA | : | LAGP |
| AFFW | LGTYP | : | T301 |
| AFFW | LIFNR | : | LFA1 |
| AFFW | MATNR | : | MARA |
| AFFW | MSGID | C: CN | T100A |
| AFFW | MSGNO | C: CN | T100 |
| AFFW | SOBKZ | : | T148 |
| AFFW | WAERS | : | TCURC |
| AFFW | WERKS | C: CN | T001W |