AUSP
Characteristic Values
AUSP is an SAP database table in S/4HANA. Characteristic Values. It contains 11 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCLM_BAM_DOC_CHARA_INOB | view | from | Chara value of object with internal no | |
| Fclm_Bam_Doc_Chara_V | view | from | Chara Value of Bank Account Document | |
| I_ClfnObjectCharcValueBasic | view | from | BASIC | Clfn Obj Characteristic Valuation Basic |
| P_MDChgProcCustValn | view | from | BASIC | Master Data Change Process Customer Valuation |
| P_MDChgProcCustValn | view | inner | BASIC | Master Data Change Process Customer Valuation |
| P_MDChgProcProdValn | view | from | BASIC | Master Data Change Process Product Valuation |
| P_MDChgProcProdValn | view | inner | BASIC | Master Data Change Process Product Valuation |
| P_MDChgProcSuplrValn | view | from | BASIC | Master Data Change Process Supplier Valuation |
| P_MDChgProcSuplrValn | view | inner | BASIC | Master Data Change Process Supplier Valuation |
| P_SpecCharacteristicValue | view | from | BASIC | Specification Characteristic Value |
| P_SpecPropertyAuspSearch | view | from | BASIC | Basic Search to get RECN, ACTN from OBJEK |
| VC_INTEGRATION_AUSP | view | from | Extraction for AUSP |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | objek | cuobn | Object | |||
| KEY | atinn | atinn | Internal char. | |||
| KEY | atzhl | wzaehl | Counter | |||
| KEY | mafid | klmaf | Object/Class | |||
| KEY | klart | klassenart | Class Type | |||
| KEY | adzhl | adzhl | Int. counter | |||
| aennr | aennr | Change Number | ||||
| datuv | datuv | Valid From | ||||
| lkenz | lkenz | Deletion Ind. | ||||
| datub | datub | to |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Characteristic Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUSP (
MANDT, -- Client [mandt]
OBJEK, -- Object [cuobn]
ATINN, -- Internal char. [atinn]
ATZHL, -- Counter [wzaehl]
MAFID, -- Object/Class [klmaf]
KLART, -- Class Type [klassenart]
ADZHL, -- Int. counter [adzhl]
AENNR, -- Change Number [aennr]
DATUV, -- Valid From [datuv]
LKENZ, -- Deletion Ind. [lkenz]
DATUB, -- to [datub]
PRIMARY KEY (MANDT, OBJEK, ATINN, ATZHL, MAFID, KLART, ADZHL)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA