A_ClfnProduct

DDL: A_CLFNPRODUCT SQL: ACLFNPRODUCT Type: view BASIC

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)

SourceAliasJoin Type
I_Product Product from

Associations (8)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/