A_SlsPrcgConditionTableField

DDL: A_SLSPRCGCONDITIONTABLEFIELD Type: view_entity CONSUMPTION Package: VDM_SD_MD_CM
9 Fields 1 Data Sources 1 Associations 1 OData Services

Fields

A_SlsPrcgConditionTableField is a Consumption CDS View that provides data about "Fields" in SAP S/4HANA. It reads from 1 data source (R_SlsPrcgConditionTableField) and exposes 9 fields with key fields ConditionUsage, ConditionApplication, ConditionTable, PricingConditionField. It has 1 association to related views. It is exposed through 1 OData service (API_SLSPRCGCONDITIONTABLE). Part of development package VDM_SD_MD_CM.

Data Sources (1)

SourceAliasJoin Type
R_SlsPrcgConditionTableField R_SlsPrcgConditionTableField projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_SalesPricingConditionTable _SalesPricingConditionTable $projection.ConditionUsage = _SalesPricingConditionTable.ConditionUsage and $projection.ConditionApplication = _SalesPricingConditionTable.ConditionApplication and $projection.ConditionTable = _SalesPricingConditionTable.ConditionTable

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fields view

OData Services (1)

ServiceBindingVersionContractRelease
API_SLSPRCGCONDITIONTABLE API_SLSPRCGCONDITIONTABLE V4 C2 C1

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConditionUsage ConditionUsage Usage
KEY ConditionApplication ConditionApplication Application
KEY ConditionTable ConditionTable Condition Table
KEY PricingConditionField PricingConditionField
PrcgCndnTableFieldIsKey PrcgCndnTableFieldIsKey
PrcgCndnTableFieldIsItem PrcgCndnTableFieldIsItem
PrcgCndnTableFieldHasText PrcgCndnTableFieldHasText
PrcgConditionGlobalFieldName PrcgConditionGlobalFieldName
_SalesPricingConditionTable _SalesPricingConditionTable

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 A_SlsPrcgConditionTableField.
-- 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 A_SlsPrcgConditionTableField AS
SELECT
  ConditionUsage,
  ConditionApplication,
  ConditionTable,
  PricingConditionField,
  PrcgCndnTableFieldIsKey,
  PrcgCndnTableFieldIsItem,
  PrcgCndnTableFieldHasText,
  PrcgConditionGlobalFieldName
FROM R_SlsPrcgConditionTableField
LEFT OUTER JOIN A_SalesPricingConditionTable AS _SalesPricingConditionTable ON ConditionUsage = _SalesPricingConditionTable.ConditionUsage AND ConditionApplication = _SalesPricingConditionTable.ConditionApplication AND ConditionTable = _SalesPricingConditionTable.ConditionTable  -- association [1..1]
;

Learn More