/POSDW/DMF_AGGR1 SAP table for – POS aggregate “Sales for DMF”: Section “Sales”

Here we would like to draw your attention to /POSDW/DMF_AGGR1 table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). /POSDW/DMF_AGGR1 is a SAP standard transp table used for storing POS aggregate “Sales for DMF”: Section “Sales” related data in SAP. It comes under the package /POSDW/OUTPUT_CONVERSION_EN.

SAP /POSDW/DMF_AGGR1 table

Table /POSDW/DMF_AGGR1 technical data

Table/POSDW/DMF_AGGR1
Data storingPOS aggregate “Sales for DMF”: Section “Sales”
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/OUTPUT_CONVERSION_EN
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/DMF_AGGR1 Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key of Aggregate Record in Lower-Level Table
    Its a key field.
  • AGGR_NO : POS Aggregate Number
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • REC_ID : Record Number Assigned Uniquely at Aggregate Level
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Key for aggregate “Daily sales per store, product, offer”
    Its a key field.
  • MATERIALNUMBER : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • OFFERID : Offer ID
    Its a key field. Its data type is CHAR (Character String) with field length 36
  • .INCLUDE : Data fields aggr. “Daily sales per store, product, offer”
  • BASEUOM : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BASEQUANTITY : Quantity in Base Unit of Measure
    Its data type is QUAN (Quantity field) with field length 13
  • GROSSSALESAMOUNT : Gross Sales (Including All Taxes)
    Its data type is CURR (Currency Field) with field length 15
  • NETSALESAMOUNT : Net Sales (Without Taxes)
    Its data type is CURR (Currency Field) with field length 15
  • TRANSACTIONCOUNT : Number of Transactions
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SQUAREDBASEQTY : Sales in Base UOM ^2 (per transaction)
    Its data type is FLTP (Floating point number) with field length 16
  • CUBEDBASEQTY : Sales in Base UOM ^3 (per transaction)
    Its data type is FLTP (Floating point number) with field length 16