SANO1 SAP table for – Address-object relationship

Here we would like to draw your attention to SANO1 table in SAP. As we know it is being mainly used with the SAP Treasury module. SANO1 is a SAP standard transparent table used for storing Address-object relationship related data in SAP. It comes under the package FVV.

SAP SANO1 table

Table SANO1 technical data

TableSANO1
Data storingAddress-object relationship
ModuleTR
ComponentTR
SAP PackageFVV
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ADRNR : Addresses: Address Number
    Its a key field. Its data type is C (Character String) with field length 10
  • OBJNR : Object number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • NAME3 : Name 3
    Its data type is C (Character String) with field length 35
  • ADRZUS
    Its data type is C (Character String) with field length 35
  • PFACH
    Its data type is C (Character String) with field length 10