I_BPSuplrClfnObjCharcValProc

DDL: I_BPSUPLRCLFNOBJCHARCVALPROC Type: view_entity BASIC
38 Fields 1 Data Sources 1 Associations

Supplier Classification Object Characteristic Value

I_BPSuplrClfnObjCharcValProc is a Basic CDS View that provides data about "Supplier Classification Object Characteristic Value" in SAP S/4HANA. It reads from 1 data source (lfa1_ausp_prc) and exposes 38 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ClfnCharcValuePositionNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
lfa1_ausp_prc lfa1_ausp_prc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BPSupplierProcess _Supplier $projection.MasterDataChangeProcess = _Supplier.MasterDataChangeProcess and $projection.MDChgProcessStep = _Supplier.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Supplier.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Supplier.MDChgProcessSrceObject and $projection.BPAssignmentID = _Supplier.BPAssignmentID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Supplier Classification Object Characteristic Value view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id Process Instance ID
KEY MDChgProcessStep process_step_no Step Number
KEY MDChgProcessSrceSystem source_system Source System
KEY MDChgProcessSrceObject source_id UUID
KEY ClfnCharcValuePositionNumber atzhl Int counter
KEY ClfnObjectType mafid Record type
KEY ClassType klart Class Type
KEY TimeIntervalNumber adzhl Int. counter
KEY BPAssignmentID assignment_id Assignment ID
CharcValue atwrt Char. Value
CharcFromNumericValue atflv Value from
CharcBaseUnit atawe Internal UoM
CharcToNumericValue atflb Value to
CharcValueUnit ataw1 Internal UoM
CharcValueIntervalType atcod Interval limits
CharcMinToleranceValue attlv Tolerance from
CharcMaxToleranceValue attlb Tolerance to
CharcToleranceIsPercent atprz Percentage
CharcAuthor ataut Justification
ChangeNumber aennr Change Number
ClfnValidityStartDate datuv Valid-from date
ClfnValidityEndDate datub Valid to
IsDeleted lkenz Deletion Ind.
CharcValueSortPosition atsrt Position
Characteristic atnam Characteristic
CharcFromDecimalValue dec_value_from LowrBndry Nmrc
CharcToDecimalValue dec_value_to UprBndry Nmrc
CharcFromAmount curr_value_from LowrBndry Crcy
CharcToAmount curr_value_to UprBndry Crcy
CharacteristicCurrency currency Valuation Crcy
CharcFromDate date_from Validity Start Date
CharcToDate date_to Validity End Date
CharcFromTime time_from LowrBndry Time
CharcToTime time_to UprBndry Time
MDChgProcessSourceModified source_modified Modified
MDChgProcessSourceModifBinary source_modification_blip Modification
MDChgProcSrceLastChgdDateTime source_recency Last Changed On
_Supplier _Supplier

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 I_BPSuplrClfnObjCharcValProc.
-- 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 I_BPSuplrClfnObjCharcValProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  atzhl AS ClfnCharcValuePositionNumber,
  mafid AS ClfnObjectType,
  klart AS ClassType,
  adzhl AS TimeIntervalNumber,
  assignment_id AS BPAssignmentID,
  atwrt AS CharcValue,
  atflv AS CharcFromNumericValue,
  atawe AS CharcBaseUnit,
  atflb AS CharcToNumericValue,
  ataw1 AS CharcValueUnit,
  atcod AS CharcValueIntervalType,
  attlv AS CharcMinToleranceValue,
  attlb AS CharcMaxToleranceValue,
  atprz AS CharcToleranceIsPercent,
  ataut AS CharcAuthor,
  aennr AS ChangeNumber,
  datuv AS ClfnValidityStartDate,
  datub AS ClfnValidityEndDate,
  lkenz AS IsDeleted,
  atsrt AS CharcValueSortPosition,
  atnam AS Characteristic,
  dec_value_from AS CharcFromDecimalValue,
  dec_value_to AS CharcToDecimalValue,
  curr_value_from AS CharcFromAmount,
  curr_value_to AS CharcToAmount,
  currency AS CharacteristicCurrency,
  date_from AS CharcFromDate,
  date_to AS CharcToDate,
  time_from AS CharcFromTime,
  time_to AS CharcToTime,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM lfa1_ausp_prc
LEFT OUTER JOIN I_BPSupplierProcess AS _Supplier ON MasterDataChangeProcess = _Supplier.MasterDataChangeProcess AND MDChgProcessStep = _Supplier.MDChgProcessStep AND MDChgProcessSrceSystem = _Supplier.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Supplier.MDChgProcessSrceObject AND BPAssignmentID = _Supplier.BPAssignmentID  -- association [0..1]
;

Learn More