A_ClfnProduct
Product
A_ClfnProduct is a Basic CDS View that provides data about "Product" in SAP S/4HANA. It reads from 1 data source (I_Product) and exposes 72 fields with key field Product. It has 8 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Product | Product | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_ClfnProductDescription | _Description | _Description.Product = $projection.Product |
| [0..*] | A_ClfnProductPlant | _Plant | _Plant.Product = $projection.Product |
| [0..*] | A_ClfnProductSalesDelivery | _SalesDelivery | _SalesDelivery.Product = $projection.Product |
| [0..*] | A_ClfnProductSalesTax | _ProductSalesTax | _ProductSalesTax.Product = $projection.Product |
| [0..*] | A_ProductClass | _ProductClass | $projection.Product = _ProductClass.Product |
| [0..*] | A_ProductCharc | _ProductCharc | $projection.Product = _ProductCharc.Product |
| [1..1] | A_ProductType | _ProductType | $projection.ProductType = _ProductType.ProductType |
| [0..1] | A_ProductGroup | _ProductGroup | $projection.ProductGroup = _ProductGroup.MaterialGroup |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | ACLFNPRODUCT | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Product | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.representativeKey | Product | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view |
Fields (72)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Product | Product | ||
| ProductType | ProductType | |||
| CrossPlantStatus | CrossPlantStatus | |||
| CrossPlantStatusValidityDate | CrossPlantStatusValidityDate | |||
| CreationDate | CreationDate | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeDate | LastChangeDate | |||
| LastChangedByUser | LastChangedByUser | |||
| IsMarkedForDeletion | IsMarkedForDeletion | |||
| ProductOldID | ProductOldID | |||
| GrossWeight | GrossWeight | |||
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | |||
| SourceOfSupply | SourceOfSupply | |||
| WeightUnit | WeightUnit | |||
| NetWeight | NetWeight | |||
| CountryOfOrigin | CountryOfOrigin | |||
| CompetitorID | CompetitorID | |||
| ProductGroup | ProductGroup | |||
| BaseUnit | BaseUnit | |||
| ItemCategoryGroup | ItemCategoryGroup | |||
| ProductHierarchy | ProductHierarchy | |||
| Division | Division | |||
| VarblPurOrdUnitIsActive | VarblPurOrdUnitIsActive | |||
| VolumeUnit | VolumeUnit | |||
| MaterialVolume | MaterialVolume | |||
| ANPCode | ANPCode | |||
| Brand | Brand | |||
| ProcurementRule | ProcurementRule | |||
| ValidityStartDate | ValidityStartDate | |||
| LowLevelCode | LowLevelCode | |||
| ProdNoInGenProdInPrepackProd | ProdNoInGenProdInPrepackProd | |||
| SerialIdentifierAssgmtProfile | SerialIdentifierAssgmtProfile | |||
| SizeOrDimensionText | SizeOrDimensionText | |||
| IndustryStandardName | IndustryStandardName | |||
| ProductStandardID | ProductStandardID | |||
| InternationalArticleNumberCat | InternationalArticleNumberCat | |||
| ProductIsConfigurable | ProductIsConfigurable | |||
| IsBatchManagementRequired | IsBatchManagementRequired | |||
| ExternalProductGroup | ExternalProductGroup | |||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | |||
| SerialNoExplicitnessLevel | SerialNoExplicitnessLevel | |||
| ProductManufacturerNumber | ProductManufacturerNumber | |||
| ManufacturerPartProfile | ManufacturerPartProfile | |||
| ChangeNumber | ChangeNumber | |||
| MaterialRevisionLevel | MaterialRevisionLevel | |||
| HandlingIndicator | HandlingIndicator | |||
| WarehouseProductGroup | WarehouseProductGroup | |||
| WarehouseStorageCondition | WarehouseStorageCondition | |||
| StandardHandlingUnitType | StandardHandlingUnitType | |||
| SerialNumberProfile | SerialNumberProfile | |||
| AdjustmentProfile | AdjustmentProfile | |||
| PreferredUnitOfMeasure | PreferredUnitOfMeasure | |||
| IsPilferable | IsPilferable | |||
| IsRelevantForHzdsSubstances | IsRelevantForHzdsSubstances | |||
| QuarantinePeriod | QuarantinePeriod | |||
| TimeUnitForQuarantinePeriod | TimeUnitForQuarantinePeriod | |||
| QualityInspectionGroup | QualityInspectionGroup | |||
| AuthorizationGroup | AuthorizationGroup | |||
| HandlingUnitType | HandlingUnitType | |||
| HasVariableTareWeight | HasVariableTareWeight | |||
| MaximumPackagingLength | MaximumPackagingLength | |||
| MaximumPackagingWidth | MaximumPackagingWidth | |||
| MaximumPackagingHeight | MaximumPackagingHeight | |||
| UnitForMaxPackagingDimensions | UnitForMaxPackagingDimensions | |||
| _Description | _Description | |||
| _Plant | _Plant | |||
| _SalesDelivery | _SalesDelivery | |||
| _ProductSalesTax | _ProductSalesTax | |||
| _ProductClass | _ProductClass | |||
| _ProductCharc | _ProductCharc | |||
| _ProductType | _ProductType | |||
| _ProductGroup | _ProductGroup |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ACLFNPRODUCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product'
@VDM.viewType:#BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.representativeKey: 'Product'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
define view A_ClfnProduct
as select from I_Product as Product
association [0..*] to A_ClfnProductDescription as _Description on _Description.Product = $projection.Product
association [0..*] to A_ClfnProductPlant as _Plant on _Plant.Product = $projection.Product
association [0..*] to A_ClfnProductSalesDelivery as _SalesDelivery on _SalesDelivery.Product = $projection.Product
association [0..*] to A_ClfnProductSalesTax as _ProductSalesTax on _ProductSalesTax.Product = $projection.Product
//Product Classification node
association [0..*] to A_ProductClass as _ProductClass on $projection.Product = _ProductClass.Product
association [0..*] to A_ProductCharc as _ProductCharc on $projection.Product = _ProductCharc.Product
association [1..1] to A_ProductType as _ProductType on $projection.ProductType = _ProductType.ProductType
association [0..1] to A_ProductGroup as _ProductGroup on $projection.ProductGroup = _ProductGroup.MaterialGroup
// association [0..1] to E_Product as _ProductExt on $projection.Product = _ProductExt.Product
{
key Product,
ProductType,
CrossPlantStatus,
CrossPlantStatusValidityDate,
@ObjectModel.readOnly: true
CreationDate,
@ObjectModel.readOnly: true
CreatedByUser,
@ObjectModel.readOnly: true
LastChangeDate,
@ObjectModel.readOnly: true
LastChangedByUser,
IsMarkedForDeletion,
ProductOldID,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
GrossWeight,
PurchaseOrderQuantityUnit,
SourceOfSupply,
@Semantics.unitOfMeasure: true
WeightUnit,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
NetWeight,
CountryOfOrigin,
CompetitorID,
ProductGroup,
BaseUnit,
ItemCategoryGroup,
ProductHierarchy,
Division,
VarblPurOrdUnitIsActive,
@Semantics.unitOfMeasure: true
VolumeUnit,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
MaterialVolume,
ANPCode,
Brand,
ProcurementRule,
ValidityStartDate,
LowLevelCode,
ProdNoInGenProdInPrepackProd,
SerialIdentifierAssgmtProfile,
SizeOrDimensionText,
IndustryStandardName,
ProductStandardID,
InternationalArticleNumberCat,
ProductIsConfigurable,
IsBatchManagementRequired,
ExternalProductGroup,
CrossPlantConfigurableProduct,
SerialNoExplicitnessLevel,
ProductManufacturerNumber,
ManufacturerPartProfile,
ChangeNumber,
MaterialRevisionLevel,
//EWM fields------------------------
//WM execution
HandlingIndicator,
WarehouseProductGroup,
WarehouseStorageCondition,
StandardHandlingUnitType,
SerialNumberProfile,
AdjustmentProfile,
PreferredUnitOfMeasure,
IsPilferable,
IsRelevantForHzdsSubstances,
QuarantinePeriod,
TimeUnitForQuarantinePeriod,
QualityInspectionGroup,
AuthorizationGroup,//NEWLY ADDED - CDS HARDENING
//WM packaging
HandlingUnitType,
HasVariableTareWeight,
@Semantics.quantity.unitOfMeasure: 'UnitForMaxPackagingDimensions'
MaximumPackagingLength,
@Semantics.quantity.unitOfMeasure: 'UnitForMaxPackagingDimensions'
MaximumPackagingWidth,
@Semantics.quantity.unitOfMeasure: 'UnitForMaxPackagingDimensions'
MaximumPackagingHeight,
@Semantics.unitOfMeasure: true
UnitForMaxPackagingDimensions,
_Description,
_Plant,
_SalesDelivery,
_ProductSalesTax,
_ProductClass ,
_ProductCharc,
@Consumption: { hidden: true }
_ProductType,
@Consumption: { hidden: true }
_ProductGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT"
],
"ASSOCIATED":
[
"A_CLFNPRODUCTDESCRIPTION",
"A_CLFNPRODUCTPLANT",
"A_CLFNPRODUCTSALESDELIVERY",
"A_CLFNPRODUCTSALESTAX",
"A_PRODUCTCHARC",
"A_PRODUCTCLASS",
"A_PRODUCTGROUP",
"A_PRODUCTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA