APS_IAM_BC_RT_FLD

DDL: APS_IAM_BC_RT_FLD SQL: APS_IAM_BCRTFD Type: view Package: SR_APS_IAM_BU_CAT
3 Fields 2 Data Sources

Business Catalog Restriction Type Field

APS_IAM_BC_RT_FLD is a CDS View that provides data about "Business Catalog Restriction Type Field" in SAP S/4HANA. It reads from 2 data sources (aps_iam_w_rtfld, aps_iam_w_buc_rt) and exposes 3 fields with key fields BusinessCatalogID, RestrictionTypeID, FieldName. Part of development package SR_APS_IAM_BU_CAT.

Data Sources (2)

SourceAliasJoin Type
aps_iam_w_rtfld _rt_fld inner
aps_iam_w_buc_rt bc_rt from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAM_BCRTFD view
EndUserText.label Business Catalog Restriction Type Field view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BusinessCatalogID bu_catalog_id
KEY RestrictionTypeID restriction_type_id
KEY FieldName aps_iam_w_rtfld field_name VAT Declaration Fld

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 APS_IAM_BC_RT_FLD.
-- 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: APS_IAM_BCRTFD

CREATE VIEW APS_IAM_BC_RT_FLD AS
SELECT
  bu_catalog_id AS BusinessCatalogID,
  restriction_type_id AS RestrictionTypeID,
  _rt_fld.field_name AS FieldName
FROM aps_iam_w_buc_rt AS bc_rt
INNER JOIN aps_iam_w_rtfld AS _rt_fld ON /* join condition not captured in parsed metadata */
;

Learn More