R_VarCnfExclCharcDetail

DDL: R_VARCNFEXCLCHARCDETAIL Type: view_entity TRANSACTIONAL Package: VCH_HL_CHARC_EXCL

Characteristics Exclusion Details

R_VarCnfExclCharcDetail is a Transactional CDS View that provides data about "Characteristics Exclusion Details" in SAP S/4HANA. It reads from 1 data source (I_VarCnfExclCharcDetail) and exposes 6 fields with key fields Product, Plant, CharcInternalID. Part of development package VCH_HL_CHARC_EXCL.

Data Sources (1)

SourceAliasJoin Type
I_VarCnfExclCharcDetail I_VarCnfExclCharcDetail from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Characteristics Exclusion Details view
ObjectModel.sapObjectNodeType.name VarConfignCharcExclusion view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY CharcInternalID CharcInternalID Characteristic Internal ID
CharcIsExclFromProdVarMatch CharcIsExclFromProdVarMatch
CharcIsExclFromSerialNoMatch CharcIsExclFromSerialNoMatch
ExclCharcChangeDateTime ExclCharcChangeDateTime Time Stamp

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 R_VarCnfExclCharcDetail.
-- 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.

CREATE VIEW R_VarCnfExclCharcDetail AS
SELECT
  Product,
  Plant,
  CharcInternalID,
  CharcIsExclFromProdVarMatch,
  CharcIsExclFromSerialNoMatch,
  ExclCharcChangeDateTime
FROM I_VarCnfExclCharcDetail
;