I_PL_SAFTAssetDefinitionKey

DDL: I_PL_SAFTASSETDEFINITIONKEY Type: view_entity BASIC Package: GLO_FIN_IS_SAFT_AA_PL
9 Fields 1 Data Sources

PL SAFT Asset Definition Key

I_PL_SAFTAssetDefinitionKey is a Basic CDS View that provides data about "PL SAFT Asset Definition Key" in SAP S/4HANA. It reads from 1 data source (fiplc_sa_defkey) and exposes 9 fields with key fields CompanyCode, AssetDefinitionKey, AssetDefinitionKeyField, SequenceNumber, ValidityEndDate. Part of development package GLO_FIN_IS_SAFT_AA_PL.

Data Sources (1)

SourceAliasJoin Type
fiplc_sa_defkey fiplc_sa_defkey from

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PL SAFT Asset Definition Key view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY AssetDefinitionKey def_key
KEY AssetDefinitionKeyField def_key_field Asset Def. Key Field
KEY SequenceNumber def_key_seq_nmbr Def. Key Seq. Number
KEY ValidityEndDate validity_end_date End Date
ValidityStartDate validity_start_date Start Date
AssetDefinitionKeyOffsetValue def_key_offset Asset Offset
AssetDefinitionKeyLengthValue def_key_length Asset Length
AssetDefinitionKeyContent def_key_content Asset Content

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_PL_SAFTAssetDefinitionKey.
-- 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_PL_SAFTAssetDefinitionKey AS
SELECT
  comp_code AS CompanyCode,
  def_key AS AssetDefinitionKey,
  def_key_field AS AssetDefinitionKeyField,
  def_key_seq_nmbr AS SequenceNumber,
  validity_end_date AS ValidityEndDate,
  validity_start_date AS ValidityStartDate,
  def_key_offset AS AssetDefinitionKeyOffsetValue,
  def_key_length AS AssetDefinitionKeyLengthValue,
  def_key_content AS AssetDefinitionKeyContent
FROM fiplc_sa_defkey
;

Learn More