A147 SAP table for – Customer Hierarchy (Sales Deal)

Here we would like to draw your attention to A147 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). A147 is a SAP standard transparent table used for storing Customer Hierarchy (Sales Deal) related data in SAP. It comes under the package VF.

SAP A147 table

Table A147 technical data

TableA147
Data storingCustomer Hierarchy (Sales Deal)
ModuleSD
ComponentSD-BIL
SAP PackageVF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KUNRG : Payer
    Its a key field. Its data type is C (Character String) with field length 10
  • KUNAG : Sold-to party
    Its a key field. Its data type is C (Character String) with field length 10
  • KUNWE : Ship-to party
    Its a key field. Its data type is C (Character String) with field length 10
  • KNUMA_AG : Sales deal
    Its a key field. Its data type is C (Character String) with field length 10
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KEXCL_D : Indicator condition exclusive
    Its data type is C (Character String) with field length 1
  • KNUMH : Condition record number
    Its data type is C (Character String) with field length 10
  • KAPPL : Application
    Its a key field. Its data type is C (Character String) with field length 2
  • KSCHL : Condition Type
    Its a key field. Its data type is C (Character String) with field length 4
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • VKBUR : Sales office
    Its a key field. Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its a key field. Its data type is C (Character String) with field length 3
  • KDGRP : Customer group
    Its a key field. Its data type is C (Character String) with field length 2