C_QualityCertificateEmail

DDL: C_QUALITYCERTIFICATEEMAIL SQL: CQLTYCERTEMAIL Type: view CONSUMPTION

Quality Certificate Email

C_QualityCertificateEmail is a Consumption CDS View that provides data about "Quality Certificate Email" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 33 fields with key fields DeliveryDocument, DeliveryDocumentItem.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYCERTEMAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Certificate Email view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
DataAging.noAgingRestriction false view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
KEY DeliveryDocumentItem DeliveryDocumentItem
SalesOrganization _DeliveryDocument SalesOrganization
ShippingPoint _DeliveryDocument ShippingPoint
ShipToParty _DeliveryDocument ShipToParty
SoldToParty _DeliveryDocument SoldToParty
DeliveryDocumentType _DeliveryDocument DeliveryDocumentType
OverallGoodsMovementStatus _DeliveryDocument OverallGoodsMovementStatus
OverallPickingStatus _DeliveryDocument OverallPickingStatus
DistributionChannel DistributionChannel
Division Division
MaterialGroup MaterialGroup
Material Material
MaterialByCustomer MaterialByCustomer
MaterialTypePrimary MaterialTypePrimary
SDDocumentCategory SDDocumentCategory
Plant Plant
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
_DeliveryDocument _DeliveryDocument
_SalesOrganization _DeliveryDocument _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Material _Material
_MaterialGroup _MaterialGroup
_ShipToParty _DeliveryDocument _ShipToParty
_SoldToParty _DeliveryDocument _SoldToParty
_DeliveryDocumentType _DeliveryDocument _DeliveryDocumentType
_OverallGoodsMovementStatus _DeliveryDocument _OverallGoodsMovementStatus
_OverallPickingStatus _DeliveryDocument _OverallPickingStatus
_Plant _Plant
_ShippingPoint _DeliveryDocument _ShippingPoint
_SDDocumentCategory _SDDocumentCategory
_ItemCategory _ItemCategory 
@AbapCatalog.sqlViewName: 'CQLTYCERTEMAIL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Quality Certificate Email'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@DataAging.noAgingRestriction: false
@ObjectModel.supportedCapabilities:
    [ #OUTPUT_EMAIL_DATA_PROVIDER ]

define view C_QualityCertificateEmail
  as select from I_DeliveryDocumentItem
{

  key DeliveryDocument,
  key DeliveryDocumentItem,

      _DeliveryDocument.SalesOrganization,
      _DeliveryDocument.ShippingPoint,
      _DeliveryDocument.ShipToParty,
      _DeliveryDocument.SoldToParty,
      _DeliveryDocument.DeliveryDocumentType,
      _DeliveryDocument.OverallGoodsMovementStatus,
      _DeliveryDocument.OverallPickingStatus,

      DistributionChannel,
      Division,
      MaterialGroup,
      Material,
      MaterialByCustomer,
      MaterialTypePrimary,
      SDDocumentCategory,
      Plant,
      DeliveryDocumentItemCategory,

      _DeliveryDocument,
      _DeliveryDocument._SalesOrganization,
      _DistributionChannel,
      _Division,
      _Material,
      _MaterialGroup,
      _DeliveryDocument._ShipToParty,
      _DeliveryDocument._SoldToParty,
      _DeliveryDocument._DeliveryDocumentType,
      _DeliveryDocument._OverallGoodsMovementStatus,
      _DeliveryDocument._OverallPickingStatus,
      _Plant,
      _DeliveryDocument._ShippingPoint,
      _SDDocumentCategory,
      _ItemCategory

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OVERALLGOODSMOVEMENTSTATUS",
"I_OVERALLPICKINGSTATUS",
"I_PLANT",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SHIPPINGPOINT"
],
"BASE":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More