1. Home
  2. Resources
  3. SAP Tables
  4. AFPO_CLEAR - AFPOB fields, that are are intialized for orders with ref.

SAP Table AFPO_CLEAR

AFPOB fields, that are are intialized for orders with ref.

AFPO_CLEAR (AFPOB fields, that are are intialized for orders with ref.) 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 AFPO_CLEAR to other SAP tables.

AFPO_CLEAR table fields

Field Data element Checktable Datatype Length Decimals
VBKZ Update indicator VBKZ CHAR 1 0
I Insert
U Update
D Delete
FLG_SEL Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
AUFNR_T Order Number AUFNR CHAR 12 0
FLG_CALCUL Indicator: Order (network etc.) still to be calculated FLG_CALC CHAR 1 0
X
NULL
INSNC Quality inspection indicator cannot be changed INSNC CHAR 1 0
X Yes
NULL No
USEQU Quota arrangement usage USEQU TMQ2 CHAR 1 0
FHWTX Indicator: Production memo exists CO_FHWTEXT CHAR 1 0
SOPNR SOP order number SAFNR CHAR 10 0
KUNNR Sold-to party KUNAG CHAR 10 0
NAME1 Name 1 NAME1_GP CHAR 35 0
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
VRKME Sales unit VRKME UNIT 3 0
BMENG Confirmed Quantity BMENG QUAN 13 3
VSMNG Delivered quantity in sales units VSMNG QUAN 13 3
KETDAT Requested delivery date of the document KETDAT CHAR 10 0
BDATU Committed Date DAT05 DATS 8 0
STTXP System Status CO_STTXT CHAR 40 0
ORT01 City ORT01_GP CHAR 35 0
VDATU Requested delivery date EDATU_VBAK DATS 8 0
PARBK Company Code BUKRS T001 CHAR 4 0
WPSMNG Order item quantity CO_PSMNG QUAN 13 3
WMEINH Unit of measure for in-house production CO_AUFME UNIT 3 0
KZWSO Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
EDATU Schedule line date EDATU DATS 8 0
SERCOM Single-Character Indicator CHAR1 CHAR 1 0
COMP_RES OCM: Result of comparison of two order objects OCM_COMP_RES CHAR 1 0
E '=' Objects are equal
A '+' object also exists
M '-' Object missing
D '<>' Object differs from comparison object
NO_KALKPOS Order item is not relevant to calculation NO_KALKPOS CHAR 1 0
X Yes
NULL No
EXT_CONVERSION Indicator: Convert planned order with RSNUM CO_PLAFKZ CHAR 1 0
PAMNG Fixed quantity of scrap from production AVMNG QUAN 13 3
PSOBS Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
PLNUM Planned order number PLNUM CHAR 10 0
STRMP Start date of the planned order CO_STRMP DATS 8 0
ETRMP Opening date of the planned order CO_ETRMP DATS 8 0
KDAUF Sales order number CO_KDAUF CHAR 10 0
KDPOS Sales order item CO_KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
WEMNG Quantity of goods received for the order item CO_WEMNG QUAN 13 3
IAMNG Expected surplus/deficit for goods receipt CO_IAMNG QUAN 13 3
PGMNG Total planned order quantity GSMNG QUAN 13 3
TPAUF Indicator: Partial conversion TPAUF CHAR 1 0
LTRMI Actual delivery/finish date CO_LTRMI DATS 8 0
LTRMP Delivery date from planned order CO_LTRMP DATS 8 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WEBAZ Goods receipt processing time in days PLWEZ DEC 3 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
SAFNR Run schedule header number SA_AUFNR CHAR 12 0
DGLTP Basic finish date CO_GLTRP DATS 8 0
CHARG Batch Number CHARG_D CHAR 10 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
DGLTS Scheduled finish CO_GLTRS DATS 8 0
DFREI Indicator: Order released/partially released (for MRP) CO_FREI CHAR 1 0
DNREL Indicator: Order item not relevant for MRP CO_DNREL CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
WEAED Indicator: Goods receipt indicator can be changed CO_WEAE CHAR 1 0
X Yes
NULL No
PROJN Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
ANZSN Number of serial numbers ANZSN INT4 10 0
VFMNG Committed quantity for order acc. to ATP check components CO_VFMNG QUAN 13 3

AFPO_CLEAR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFPO_CLEAR PARBK AFPO MANDT T001 Company Codes MANDT
AFPO_CLEAR PARBK AFPO_CLEAR PARBK T001 Company Codes BUKRS
AFPO_CLEAR USEQU AFPO MANDT TMQ2 Quota Arrangement Rules MANDT
AFPO_CLEAR USEQU AFPO_CLEAR USEQU TMQ2 Quota Arrangement Rules USEQU