FAC_AUDIT_Z3_Material_Cocod

DDL: FAC_AUDIT_Z3_MATERIAL_COCOD SQL: FAC_DZMATCOCD Type: view Package: FINS_FI_DART_Z3
3 Fields 1 Data Sources

Material Change Document Base

FAC_AUDIT_Z3_Material_Cocod is a CDS View that provides data about "Material Change Document Base" in SAP S/4HANA. It reads from 1 data source (FAC_AUDIT_Z3_Plant) and exposes 3 fields with key fields Material, CompanyCode. Part of development package FINS_FI_DART_Z3.

Data Sources (1)

SourceAliasJoin Type
FAC_AUDIT_Z3_Plant _plant inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZMATCOCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Material Change Document Base view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Material _MaterialPlant Material Vehicle Model
KEY CompanyCode FAC_AUDIT_Z3_Plant CompanyCode Receiver Company Code
SystemClient System Client

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 FAC_AUDIT_Z3_Material_Cocod.
-- 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: FAC_DZMATCOCD

CREATE VIEW FAC_AUDIT_Z3_Material_Cocod AS
SELECT
  _MaterialPlant.Material AS Material,
  _plant.CompanyCode AS CompanyCode,
  $session.client AS SystemClient
INNER JOIN FAC_AUDIT_Z3_Plant AS _plant ON /* join condition not captured in parsed metadata */
;

Learn More