VC_INTEGRATION_AUSP

DDL: VC_INTEGRATION_AUSP SQL: VCIAUSP Type: view
37 Fields 1 Data Sources

Extraction for AUSP

VC_INTEGRATION_AUSP is a CDS View that provides data about "Extraction for AUSP" in SAP S/4HANA. It reads from 1 data source (ausp) and exposes 37 fields with key fields OBJEK, ATINN, ATZHL, MAFID, KLART.

Data Sources (1)

SourceAliasJoin Type
ausp ausp from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIAUSP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for AUSP view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY OBJEK objek Object
KEY ATINN atinn Internal char.
KEY ATZHL atzhl Int counter
KEY MAFID mafid Record type
KEY KLART klart Class Type
KEY ADZHL adzhl Int. counter
ATWRT atwrt Char. Value
ATFLV atflv Value from
ATAWE atawe Internal UoM
ATFLB atflb Value to
ATAW1 ataw1 Internal UoM
ATCOD atcod Interval limits
ATTLV attlv Tolerance from
ATTLB attlb Tolerance to
ATPRZ atprz Percentage
ATINC atinc Increment
ATAUT ataut Justification
AENNR aennr Change Number
DATUV datuv Valid-from date
LKENZ lkenz Deletion Ind.
ATIMB atimb Internal char.
ATZIS atzis Instance cntr
ATSRT atsrt Position
ATVGLART atvglart Comp. type
DATUB datub Valid to
DEC_VALUE_FROM dec_value_from LowrBndry Nmrc
DEC_VALUE_TO dec_value_to UprBndry Nmrc
CURR_VALUE_FROM curr_value_from LowrBndry Crcy
CURR_VALUE_TO curr_value_to UprBndry Crcy
CURRENCY currency Valuation Crcy
DATE_FROM date_from Validity Start Date
DATE_TO date_to Validity End Date
TIME_FROM time_from LowrBndry Time
TIME_TO time_to UprBndry Time
PARTNER_GUID partner_guid Partner GUID
CHANGED_AT changed_at Timestamp
TYPE_BP_GUID type_bp_guid Partner Cat.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view VC_INTEGRATION_AUSP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VCIAUSP

CREATE VIEW VC_INTEGRATION_AUSP AS
SELECT
  OBJEK,
  ATINN,
  ATZHL,
  MAFID,
  KLART,
  ADZHL,
  ATWRT,
  ATFLV,
  ATAWE,
  ATFLB,
  ATAW1,
  ATCOD,
  ATTLV,
  ATTLB,
  ATPRZ,
  ATINC,
  ATAUT,
  AENNR,
  DATUV,
  LKENZ,
  ATIMB,
  ATZIS,
  ATSRT,
  ATVGLART,
  DATUB,
  DEC_VALUE_FROM,
  DEC_VALUE_TO,
  CURR_VALUE_FROM,
  CURR_VALUE_TO,
  CURRENCY,
  DATE_FROM,
  DATE_TO,
  TIME_FROM,
  TIME_TO,
  PARTNER_GUID,
  CHANGED_AT,
  TYPE_BP_GUID
FROM ausp
;

Learn More