J_1AOFNR3 SAP table for – Exception table for deal type determ.(export/domestic)

Here we would like to draw your attention to J_1AOFNR3 table in SAP. As we know it is being mainly used with the SAP SD-BIL (Billing in SD) component which is coming under SD module (Sales & Distribution). J_1AOFNR3 is a SAP standard transparent table used for storing Exception table for deal type determ.(export/domestic) related data in SAP. It comes under the package J1AS.

SAP J_1AOFNR3 table

Table J_1AOFNR3 technical data

TableJ_1AOFNR3
Data storingException table for deal type determ.(export/domestic)
ModuleSD
ComponentSD-BIL
SAP PackageJ1AS
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP J_1AOFNR3 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 J_1AOFNR3 table.

  • VSTEL
    Its a key field. Its data type is C (Character String) with field length 4
  • REGIO : Region (State, Province, County)
    Its a key field. Its data type is C (Character String) with field length 3