FAC_AUDIT_Z3_MATERIAL_MASTER_B

DDL: FAC_AUDIT_Z3_MATERIAL_MASTER_B SQL: FAC_AUDMATMSTB Type: view Package: FINS_FI_DART_Z3
44 Fields 5 Data Sources 2 Associations

Material Master based CDS View

FAC_AUDIT_Z3_MATERIAL_MASTER_B is a CDS View that provides data about "Material Master based CDS View" in SAP S/4HANA. It reads from 5 data sources (mara, nsdm_e_marc, materialid, I_Material, FAC_AUDIT_Z3_Plant) and exposes 44 fields with key fields CompanyCode, Material. It has 2 associations to related views. Part of development package FINS_FI_DART_Z3.

Data Sources (5)

SourceAliasJoin Type
mara _mara left_outer
nsdm_e_marc _marc inner
materialid _materialid left_outer
I_Material _Materialledgercube_Lit from
FAC_AUDIT_Z3_Plant _plant inner

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProductHierarchyText _ProductHierarchyText $projection.prdha = _ProductHierarchyText.ProductHierarchy and _ProductHierarchyText.Language = $parameters.P_Language
[0..*] I_ProductCategoryText _ProductCategoryText $projection.attyp = _ProductCategoryText.ProductCategory and _ProductCategoryText.Language = $parameters.P_Language

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAC_AUDMATMSTB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Master based CDS View view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode FAC_AUDIT_Z3_Plant CompanyCode Receiver Company Code
KEY Material I_Material Material Vehicle Model
Plant FAC_AUDIT_Z3_Plant Plant Valuation Area
MaterialType I_Material MaterialType Material Type
MaterialTypeName
MaterialGroup I_Material MaterialGroup Product Group
MaterialGroupName
MaterialName
normt mara normt Ind. Std Desc.
prdha mara prdha Prod.Hierarchy
ProductHierarchyText _ProductHierarchyText ProductHierarchyText
attyp mara attyp Trdg Goods Cat.
MaterialCategoryName _ProductCategoryText Name Zone name
stoff mara stoff Haz. matl no.
kzumw mara kzumw Envt. relevant
taklv mara taklv Tax class.
prctr nsdm_e_marc prctr Profit Centers
atpkz nsdm_e_marc atpkz Replacemt Part
preng nsdm_e_marc preng Vdr decl. date
stdpd nsdm_e_marc stdpd Conf. Material
expme nsdm_e_marc expme Comm. code unit
mtver nsdm_e_marc mtver Intrastat Group
prefe nsdm_e_marc prefe Cus. Preference
prenc nsdm_e_marc prenc Exemption cert.
preno nsdm_e_marc preno Exempt.cert.no.
prend nsdm_e_marc prend Iss.date of crt
prene nsdm_e_marc prene Vendor decl.
herbl nsdm_e_marc herbl State of manufac
herkl mara herkl C/R of Origin
herkr nsdm_e_marc herkr Reg. of Origin
cuobf mara cuobf Int. object no.
otype nsdm_e_marc otype Type of Val.
objid nsdm_e_marc objid Work Center
extwg mara extwg Ext. Matl Group
satnr mara satnr Cross-plant CM
schgt nsdm_e_marc schgt Bulk material
bismt mara bismt Old matl number
ersda mara ersda Entry Date
bwtty nsdm_e_marc bwtty Valuation Cat.
matnr_vers materialid matnr_vers Version Number
ernam mara ernam User Name
steuc nsdm_e_marc steuc Control Code
casnr nsdm_e_marc casnr CAS no.(pharm.)
Language

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_MASTER_B.
-- 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_AUDMATMSTB
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_AUDIT_Z3_MATERIAL_MASTER_B AS
SELECT
  _plant.CompanyCode AS CompanyCode,
  _Materialledgercube_Lit.Material AS Material,
  _plant.Plant AS Plant,
  _Materialledgercube_Lit.MaterialType AS MaterialType,
  _Materialledgercube_Lit._MaterialType._Text[1: Language = $parameters.P_Language].MaterialTypeName AS MaterialTypeName,
  _Materialledgercube_Lit.MaterialGroup AS MaterialGroup,
  _Materialledgercube_Lit._MaterialGroup._Text[1: Language = $parameters.P_Language].MaterialGroupName AS MaterialGroupName,
  _Materialledgercube_Lit._Text[1: Language = $parameters.P_Language].MaterialName AS MaterialName,
  _mara.normt AS normt,
  _mara.prdha AS prdha,
  _ProductHierarchyText.ProductHierarchyText AS ProductHierarchyText,
  _mara.attyp AS attyp,
  _ProductCategoryText.Name AS MaterialCategoryName,
  _mara.stoff AS stoff,
  _mara.kzumw AS kzumw,
  _mara.taklv AS taklv,
  _marc.prctr AS prctr,
  _marc.atpkz AS atpkz,
  _marc.preng AS preng,
  _marc.stdpd AS stdpd,
  _marc.expme AS expme,
  _marc.mtver AS mtver,
  _marc.prefe AS prefe,
  _marc.prenc AS prenc,
  _marc.preno AS preno,
  _marc.prend AS prend,
  _marc.prene AS prene,
  _marc.herbl AS herbl,
  _mara.herkl AS herkl,
  _marc.herkr AS herkr,
  _mara.cuobf AS cuobf,
  _marc.otype AS otype,
  _marc.objid AS objid,
  _mara.extwg AS extwg,
  _mara.satnr AS satnr,
  _marc.schgt AS schgt,
  _mara.bismt AS bismt,
  _mara.ersda AS ersda,
  _marc.bwtty AS bwtty,
  _materialid.matnr_vers AS matnr_vers,
  _mara.ernam AS ernam,
  _marc.steuc AS steuc,
  _marc.casnr AS casnr,
  $parameters.P_Language AS Language
FROM I_Material AS _Materialledgercube_Lit
LEFT OUTER JOIN mara AS _mara ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_marc AS _marc ON /* join condition not captured in parsed metadata */
INNER JOIN FAC_AUDIT_Z3_Plant AS _plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN materialid AS _materialid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductHierarchyText AS _ProductHierarchyText ON prdha = _ProductHierarchyText.ProductHierarchy AND _ProductHierarchyText.Language = $parameters.P_Language  -- association [0..*]
LEFT OUTER JOIN I_ProductCategoryText AS _ProductCategoryText ON attyp = _ProductCategoryText.ProductCategory AND _ProductCategoryText.Language = $parameters.P_Language  -- association [0..*]
;

Learn More