AUSP is a standard SAP table in SAP ERP (or) S/4HANA which stores Characteristic Values data. There are total 31 fields in AUSP table.This blog post provides key technical details of SAP table AUSP, including its availability across SAP S/4HANA versions and the list of CDS views for AUSP table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | R/3 Application development: PP Classification System (CL) |
| Technical Component | Classes (CA-CL-CLS) |
SAP AUSP Table Fields
The following is the list of fields that are available in SAP AUSP table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| OBJEK | Key of Object to be Classified | CUOBN | CUOBN | CHAR (90) | |
| ATINN | Internal characteristic | ATINN | ATINN | NUMC (10) | |
| ATZHL | Characteristic value counter | WZAEHL | NUM3 | NUMC (3) | |
| MAFID | Indicator: Object/Class | KLMAF | KLMAF | CHAR (1) | |
| KLART | Class Type | KLASSENART | KLASSENART | TCLA | CHAR (3) |
| ADZHL | Internal Counter for Archiving Objects by ECM | ADZHL | NUMC4 | NUMC (4) | |
| ATWRT | Characteristic Value | ATWRT | ATWRT | CHAR (70) | |
| ATFLV | Internal floating point from | ATFLV | FLTP | FLTP (16) | |
| ATAWE | Unit of Measurement | MSEHI | MEINS | T006 | UNIT (3) |
| ATFLB | Internal floating point value to | ATFLB | FLTP | FLTP (16) | |
| ATAW1 | Unit of Measurement | MSEHI | MEINS | T006 | UNIT (3) |
| ATCOD | Code for value dependency | ATCOD | ATCOD | CHAR (1) | |
| ATTLV | Tolerance from | ATTLV | FLTP | FLTP (16) | |
| ATTLB | Tolerance to | ATTLB | FLTP | FLTP (16) | |
| ATPRZ | Indicator: Tolerance Shown as a Percentage | ATPRZ | ATXFE | CHAR (1) | |
| ATINC | Increment Within a Specified Interval | ATINC | FLTP | FLTP (16) | |
| ATAUT | Classification: Author | ATAUT | ATAUT | CHAR (1) | |
| AENNR | Change Number | AENNR | AENNR | CHAR (12) | |
| DATUV | Valid-From Date | DATUV | DATUM | DATS (8) | |
| LKENZ | Deletion Indicator | LKENZ | XFELD | CHAR (1) | |
| ATIMB | Characteristic Number of User-Defined Data Type | ATIMB | ATINN | * | NUMC (10) |
| ATZIS | Instance counter | ATZIS | NUMC3 | NUMC (3) | |
| ATSRT | Sort field for AUSP char. values | ATSRT | ATSRT | NUMC (4) | |
| ATVGLART | Comparison Type for Char. Value: ” ” .. “7”: Incl./Excl. | ATVGLART | ATVGLART | CHAR (1) | |
| DATUB | Valid-to date | DATUB | DATUM | DATS (8) | |
| CURRENCY | Currency Key | WAERS_CURC | WAERS | * | CUKY (5) |
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | SYSUUID | RAW (16) | |
| CHANGED_AT | Marketing Object: Date of Last Change | CRMT_MKT_CHANGED_AT | BCOS_TSTMP | DEC (15) | |
| CHANGED_BY | Marketing Object: Last Changed By | CRMT_MKT_CHANGED_BY | UNAME | CHAR (12) | |
| TYPE_BP_GUID | Business Partner Category | BU_TYPE | BU_TYPE | CHAR (1) |
Availability
The SAP table AUSP is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AUSP table
The following is the list of AUSP CDS views, which can also be used instead of AUSP table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_CLFNOBJECTCHARCVALUE | BASIC | Clfn Characteristic Value of Object |
| I_CLFNOBJECTCHARCVALUEBASIC | BASIC | Clfn Obj Characteristic Valuation Basic |
| P_MDCHGPROCCUSTVALN | BASIC | Master Data Change Process Customer Valuation |
| P_MDCHGPROCCUSTVALNWTHBUSPART | BASIC | Master Data Change Process Customer Valuation with BP Number |
| P_MDCHGPROCPRODVALN | BASIC | Master Data Change Process Product Valuation |
| P_MDCHGPROCPRODVALNWTHMATLNMBR | BASIC | Master Data Change Process Product Valuation with MATNR |
| P_MDCHGPROCSUPLRVALN | BASIC | Master Data Change Process Supplier Valuation |
| P_MDCHGPROCSUPLRVALNWTHBUSPART | BASIC | Master Data Change Process Supplier Valuation with BP Number |
| P_SPECCHARACTERISTICVALUE | BASIC | Specification Characteristic Value |
| P_SPECPROPERTYAUSPSEARCH | BASIC | Basic Search to get RECN, ACTN from OBJEK |
| P_SPECPROPERTYCHARSEARCH | BASIC | Search via characteristics of type CHAR |
| P_SPECPROPERTYNUMSEARCH | BASIC | Search via characteristics of type NUM |
| A_BATCHCHARCVALUE | COMPOSITE | Batch Characteristics Valuation |
| A_CHANGEMASTERCHARCVALUE | COMPOSITE | Change Number Characteristic Values |
| A_DOCUMENTINFORECORDCHARCVALUE | COMPOSITE | Classification Characteristic Values |
| A_EQUIPMENTCLFNCHARVALUE | COMPOSITE | Equipment Characteristic Values |
| A_PRODSPECCOMPONENTBASEUOM | COMPOSITE | Base UoM for Specification Type |
| A_PRODUCTCHARCVALUE | COMPOSITE | Characteristic Valuations |
| A_RECIPECHARCVALUE | COMPOSITE | Recipe Characteristic Values |
| A_RECPROCEQUIPRQMTCHARCVALUE | COMPOSITE | Recipe Equipment Requirement Characteristic Values |
| A_RECPROCPARAMVALCHARCVALUE | COMPOSITE | Recipe Process Parameter Value Characteristic Values |
| A_SPECCHARBYVALUEASSGMTINST | COMPOSITE | Specification Properties |
| I_BATCHCHARCVALUETP | COMPOSITE | TP for Batch Characteristic Value |
| I_CHFIEXCLFNOBJCHARCFORKEYDATE | COMPOSITE | Classification Obj Charac for Key date |
| I_CLFNOBJECTCHARCVALFORKEYDATE | COMPOSITE | Clfn Charc Val of Obj for Key Date |
| I_CLFNOBJECTCHARCVALUETP | COMPOSITE | TP for Clfn Obj Charc With Value |
| I_NUTRIENTBASEUNITOFMEASURE | COMPOSITE | Nutrient Base Unit of Measure |
| I_NUTRIENTDERIVEDNUTRIENT | COMPOSITE | Nutrient Derived Nutrient |
| I_PRODSPECCOMPONENTBASEUOM | COMPOSITE | Prod Specification Component Base UoM |
| I_PRODSPECPRPTYCHARACTERVALUE | COMPOSITE | Product Specification Property Character Type Value (TP) |
| I_PRODSPECPRPTYCHARCVALUE | COMPOSITE | Product Specification Property Value by Characteristic |
| I_PRODSPECPRPTYNUMERICVALUE | COMPOSITE | Product Specification Property Numeric Type Value |
| I_PRODUCTSUTILSATTRIBUTES | COMPOSITE | Product with Utilities Attributes |
| I_PRSPPRPTYCHARCVALUENONHIST | COMPOSITE | Product Spec. Property Value by Char. Non Historic |
| I_PRSPPRPTYCHARCVALUENONHISTTP | COMPOSITE | Product Spec. Property Value by Char. Non Historic TP |
| I_PURGRELSTRATEGYCHARC | COMPOSITE | Characteristics for Purg Rel Strategy |
| I_SPECCHARBYVALUEASSGMTINST | COMPOSITE | Specification Characteristic by VAI |
| I_UTILITIESPRODUCT | COMPOSITE | IS-U Product |
| I_UTILSBILLINGATTRIBUTESVH | COMPOSITE | Billing Attributes for Reference Utilities Product |
| I_UTILSDISCOUNTVH | COMPOSITE | Discount for Reference Utilities Product |
| I_UTILSPRODATTRIBUTES | COMPOSITE | IS-U Product Attributes |
| I_UTILSPRODBILLINGATTRIBUTE | COMPOSITE | Billing Attributes for a Utilities Product |
| I_UTILSPRODCHARVALUE | COMPOSITE | Utilities Product Characteristics Value |
| I_UTILSPRODCHGONETIME | COMPOSITE | One Time Charge for a Utilities Product |
| I_UTILSPRODCHGPRICECATEGORY | COMPOSITE | Utilities Product Price Key Category |
| I_UTILSPRODCHGRECURRING | COMPOSITE | Recurring Charge for a Utilities Product |
| I_UTILSPRODCHGUSAGE | COMPOSITE | Usage Charge for a Utility Product |
| I_UTILSPRODCRTNMETHCHARCNAME | COMPOSITE | Utilities Product Creation Method for Utilities Product |
| I_UTILSPRODDISCOUNT | COMPOSITE | Discount for Utilities Product |
| I_UTILSPRODRATECAT | COMPOSITE | Rate Category for Utilities Product |
| I_UTILSPRODSALESATTRIBUTE | COMPOSITE | Sales Attributes for Utilities Product |
| I_UTILSPRODSTANDARDATTRIBUTE | COMPOSITE | Utilities Product Standard Attribute Value |
| I_UTILSPRODUCTFACTS | COMPOSITE | Characteristics to Installation Facts for Utilities Product |
| I_UTILSPRODVALIDFROMCHARNAME | COMPOSITE | Valid From Date for Utilities Product |
| I_UTILSPRODVALIDTOCHARNAME | COMPOSITE | Valid To Date for Utilities Product |
| I_UTILSRECURRINGCHARGEVH | COMPOSITE | Recurring Charge for Reference Utilities Product |
| I_UTILSREFERENCEPRODUCT | COMPOSITE | Reference Product for Utilities Product |
| I_UTILSREFERENCEPRODUCTS | COMPOSITE | Reference Product(Utilities) |
| I_UTILSREFPRODCHARCSALL | COMPOSITE | All Characteristics for a Ref. Prod. |
| I_UTILSREFPRODSTDATTRIBUTE | COMPOSITE | Standard Attribute Name for Ref. Product |
| I_UTILSSTANDARDCHARCVALUE | COMPOSITE | Utilities Product Standard Characteristic Value Table |
| I_UTILSUSAGECHARGEVH | COMPOSITE | Usage Charge for Reference Utilities Product |
| P_RELSTRATCHARVALUES | COMPOSITE | Classification for Release Strategy |
| A_NUTRIENTBASEUNITOFMEASURE | CONSUMPTION | Nutrient Base Unit Of Measure |
| A_NUTRIENTDERIVEDNUTRIENT | CONSUMPTION | Derived Nutrient |
| C_DFSSCENCLFNOBJECTCHARCVAL | CONSUMPTION | Consumption View for Scenario Classification values |
| C_RS_CLASSIFICATION | CONSUMPTION | Classification for Release Strategy |
| C_UTILITIESPRODUCT | CONSUMPTION | Utilities Product |
| C_UTILSREFERENCEPRODUCT | CONSUMPTION | Reference Product(Utilities) |
| C_ZA_SUPLRCHARCSANDTAXITEMCUBE | CONSUMPTION | South Africa Supplier Characteristics and Tax Item details |
| C_ZA_SUPLRCHARCSANDTAXITEMQRY | CONSUMPTION | Analytical query South Africa BBBEE Supplier Classification |
| P_ZA_CHARACTERISTICSVALUE | CONSUMPTION | Get the Characteristics Values for ZA BBBEE |
