AFSPREL SAP table for – Relation Between Orders in an Order Split

Here we would like to draw your attention to AFSPREL table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). AFSPREL is a SAP standard transparent table used for storing Relation Between Orders in an Order Split related data in SAP. It comes under the package CO.

SAP AFSPREL table

Table AFSPREL technical data

TableAFSPREL
Data storingRelation Between Orders in an Order Split
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFSPREL Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AFSPREL table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SDATE : Created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STIME : Time created
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SUSER : User Name
    Its data type is C (Character String) with field length 12
  • BYPROD_MAT_DOC : Material Document for Goods Receipt By-Product Order Split
    Its data type is C (Character String) with field length 10
  • BYPROD_MAT_ITEM : Material Document Item GR By-Product Order Split
    Its data type is N (Character String with Digits Only) with field length 4
  • BYPROD_MAT_YEAR : Material Document Year Goods Receipt By-Product Order Split
    Its data type is N (Character String with Digits Only) with field length 4
  • COMPONENT_BATCH : Component Batch Used for Order Split
    Its data type is C (Character String) with field length 10
  • WIP_BATCH : WIP Batch Used for Order Split
    Its data type is C (Character String) with field length 10
  • CANCELED : Order Split Cancelled
    Its data type is C (Character String) with field length 1
  • CANCEL_USER : User Who Carried Out Order Split Cancellation
    Its data type is C (Character String) with field length 12
  • C_AUFNR : Child order of a split hierarchy
    Its a key field. Its data type is C (Character String) with field length 12
  • CANCEL_DATE : Cancellation Date Order Split
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • CANCEL_TIME : Time of Cancellation
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • BYPRODUCT : Material Number By-Product Order Split
    Its a key field. Its data type is C (Character String) with field length 18
  • BYPRODUCT_BATCH : Batch Number By-Product Order Split
    Its a key field. Its data type is C (Character String) with field length 10
  • SPLCNT : Counter for the Parent-Child Order Relationships
    Its data type is N (Character String with Digits Only) with field length 4
  • P_AUFNR : Parent order of a split hierarchy
    Its data type is C (Character String) with field length 12
  • L_AUFNR : Leading order of a split hierarchy
    Its data type is C (Character String) with field length 12
  • SPLQ : Split Quantity in Order Split
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • QUNIT : Unit of measure for activity
    Its data type is C (Character String) with field length 3