/BEV3/CHBDMDHST SAP table for – History of Condit. Modifications from Temp. Settlement Items

Here we would like to draw your attention to /BEV3/CHBDMDHST table in SAP. As we know it is being mainly used with the SAP SD-SLS (Sales in SD) component which is coming under SD module (Sales & Distribution). /BEV3/CHBDMDHST is a SAP standard transparent table used for storing History of Condit. Modifications from Temp. Settlement Items related data in SAP. It comes under the package /BEV3/CH.

SAP /BEV3/CHBDMDHST table

Table /BEV3/CHBDMDHST technical data

Table/BEV3/CHBDMDHST
Data storingHistory of Condit. Modifications from Temp. Settlement Items
ModuleSD
ComponentSD-SLS
SAP Package/BEV3/CH
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /BEV3/CHBDMDHST 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 /BEV3/CHBDMDHST table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is /BEV3/CHABRKEY
  • VBKL_SUPER
    Its data type is C (Character String) with field length 8
  • SACHKTO
    Its data type is C (Character String) with field length 20
  • KOST_ST
    Its data type is C (Character String) with field length 20
  • I_AUFTRG
    Its data type is C (Character String) with field length 24
  • PRFTCNTR
    Its data type is C (Character String) with field length 20
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 4
  • BTRG_STR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BTRG_STRBAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WAERK_STR
    Its data type is C (Character String) with field length 10
  • EVENT_NR
    Its data type is N (Character String with Digits Only) with field length 32
  • BUZEI : Document Item in Invoice Document
    Its data type is N (Character String with Digits Only) with field length 6
  • RI_SUPER
    Its data type is N (Character String with Digits Only) with field length 12
  • TXT_BCH
    Its data type is C (Character String) with field length 100
  • BK_LFDNR
    Its data type is N (Character String with Digits Only) with field length 32
  • UMSSTAFFEL
    Its data type is C (Character String) with field length 12
  • ABSSTAFFEL
    Its data type is C (Character String) with field length 12
  • GLTG_AB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • MEINH_VG
    Its data type is C (Character String) with field length 6
  • WAERK_VG
    Its data type is C (Character String) with field length 10
  • ABSBASIS_VG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BTRG_VG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • PRT_ID
    Its data type is N (Character String with Digits Only) with field length 8
  • VBIN_SUPER
    Its data type is N (Character String with Digits Only) with field length 8
  • PART_SUPER
    Its data type is C (Character String) with field length 16
  • PTIN_SUPER
    Its data type is N (Character String with Digits Only) with field length 8
  • VBKL
    Its data type is C (Character String) with field length 8
  • RI
    Its data type is N (Character String with Digits Only) with field length 12
  • VBIN
    Its data type is N (Character String with Digits Only) with field length 8
  • VBNR
    Its data type is N (Character String with Digits Only) with field length 18
  • VBDTA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • ABR_KZ
    Its data type is N (Character String with Digits Only) with field length 8
  • VBEWAR
    Its data type is C (Character String) with field length 8
  • STR_VRG
    Its data type is C (Character String) with field length 2
  • VWD_LAND
    Its data type is C (Character String) with field length 6
  • VWD_STRKZ
    Its data type is C (Character String) with field length 2
  • ERG_NR
    Its data type is C (Character String) with field length 20
  • STAT_KZ
    Its data type is C (Character String) with field length 2
  • STAT_BZNR
    Its data type is N (Character String with Digits Only) with field length 12
  • VERD_KZ
    Its data type is C (Character String) with field length 2
  • SP_TAG
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • BLG_NR
    Its a key field. Its data type is C (Character String) with field length 20
  • VB_STRKZ
    Its data type is C (Character String) with field length 2
  • VERTSI_BCH
    Its data type is C (Character String) with field length 2
  • ABR_KZ_BCH
    Its data type is N (Character String with Digits Only) with field length 8
  • PARTTM_BCH
    Its data type is C (Character String) with field length 16
  • RI_BCH
    Its data type is N (Character String with Digits Only) with field length 12
  • VKORG_BCH
    Its data type is C (Character String) with field length 8
  • VTWEG_BCH
    Its data type is C (Character String) with field length 4
  • SPART_BCH
    Its data type is C (Character String) with field length 4
  • BUKRS_BCH
    Its data type is C (Character String) with field length 8
  • WERK_BCH
    Its data type is C (Character String) with field length 8
  • POS_NR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 12
  • VWDNR_BCH
    Its data type is N (Character String with Digits Only) with field length 26
  • RG_BCH
    Its data type is C (Character String) with field length 20
  • WE_BCH
    Its data type is C (Character String) with field length 20
  • AG_BCH
    Its data type is C (Character String) with field length 20
  • RE_BCH
    Its data type is C (Character String) with field length 20
  • DE_BCH
    Its data type is C (Character String) with field length 20
  • VRL_BCH
    Its data type is C (Character String) with field length 20
  • SPD_BCH
    Its data type is C (Character String) with field length 20
  • RG_STAT
    Its data type is C (Character String) with field length 20
  • WE_STAT
    Its data type is C (Character String) with field length 20
  • ABR_NR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 20
  • AG_STAT
    Its data type is C (Character String) with field length 20
  • RE_STAT
    Its data type is C (Character String) with field length 20
  • VB_PERSNO
    Its data type is N (Character String with Digits Only) with field length 16
  • BTRG_BCH
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • WAERK_BCH
    Its data type is C (Character String) with field length 10
  • LAST_BDG
    Its data type is N (Character String with Digits Only) with field length 8
  • SPRAS : Language Key
    Its data type is C (Character String) with field length 2
  • ZUORDNR
    Its data type is C (Character String) with field length 36
  • BSCHL : Posting Key
    Its data type is C (Character String) with field length 4
  • PBANKTYP
    Its data type is C (Character String) with field length 8
  • YVWDNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 26
  • ZAHLWEG
    Its data type is C (Character String) with field length 2
  • ZAHLSP
    Its data type is C (Character String) with field length 2
  • MAHNSP
    Its data type is C (Character String) with field length 2
  • MSCHL
    Its data type is C (Character String) with field length 2
  • ZAHLBED
    Its data type is C (Character String) with field length 8
  • MAHNBER
    Its data type is C (Character String) with field length 4
  • BUCHDT_AB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • BUCHDT_BIS
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • BRCHDT_AB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • BRCHDT_BIS
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • MOD_LFDNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • VKORG_LSTG
    Its data type is C (Character String) with field length 8
  • VTWEG_LSTG
    Its data type is C (Character String) with field length 4
  • SPART_LSTG
    Its data type is C (Character String) with field length 4
  • BUKRS_LSTG
    Its data type is C (Character String) with field length 8
  • WERK_LSTG
    Its data type is C (Character String) with field length 8
  • VWDNR_LSTG
    Its data type is N (Character String with Digits Only) with field length 26
  • BTRG_LSTG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • WAERK_LSTG
    Its data type is C (Character String) with field length 10
  • UKURS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • KURSTYP
    Its data type is C (Character String) with field length 8
  • YVORGE
    Its data type is N (Character String with Digits Only) with field length 8
  • PRZSTZ_ZNS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • PRZSTZ_MAX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • PRZSTZ_MIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • PRZSTZ_ABW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • BTRG_ZNS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • WAERK_ZNS
    Its data type is C (Character String) with field length 10
  • I_ZNSCHL
    Its data type is C (Character String) with field length 12
  • E_ZNSCHL
    Its data type is C (Character String) with field length 20
  • SZBMETH
    Its data type is C (Character String) with field length 2
  • STGBASIS
    Its data type is C (Character String) with field length 2
  • ABASTAGE
    Its data type is N (Character String with Digits Only) with field length 12
  • ATAGE
    Its data type is X (Byte string) with field length 4
  • MAT_NR
    Its data type is C (Character String) with field length 36
  • SORTIMENT
    Its data type is C (Character String) with field length 36
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINH : Unit of Measure
    Its data type is C (Character String) with field length 6
  • MENGE_LSTG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINH_LSTG
    Its data type is C (Character String) with field length 6
  • BTRG_UMS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • WAERK_UMS
    Its data type is C (Character String) with field length 10