C_DDMaterialSOS

DDL: C_DDMATERIALSOS SQL: CDDMATSOS Type: view CONSUMPTION

Source of Supply for DDR Materials

C_DDMaterialSOS is a Consumption CDS View that provides data about "Source of Supply for DDR Materials" in SAP S/4HANA. It reads from 1 data source (P_DDMaterialSOS) and exposes 22 fields with key fields Material, Plant, MRPArea, DDSourceDocument, DDSourceDocumentItem.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
P_DDMaterialSOS P_DDMaterialSOS from

Parameters (1)

NameTypeDefault
P_RequirementDate dats

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDDMATSOS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
EndUserText.label Source of Supply for DDR Materials view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY MRPArea MRPArea
KEY DDSourceDocument SourceDocument
KEY DDSourceDocumentItem SourceDocumentItem
DDSourceDocumentType SourceDocumentType
SOSTypeDescription SOSTypeDescription
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity
SupplyingPlant SupplyingPlant
Supplier Supplier
SupplierName SupplierName
DemandDrivenSOSType SOSType
MRPElementCategory MRPElementCategory
MaterialSOSIsDefault DefaultSOS
BillOfOperationsType BillOfOperationsType
StorageLocation StorageLocation
SourceUnitOfMeasure UoM 
@AbapCatalog.sqlViewName: 'CDDMATSOS'
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XXL, dataClass: #MIXED}
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Source of Supply for DDR Materials'
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view C_DDMaterialSOS
  with parameters
    P_RequirementDate : dats
  as select from P_DDMaterialSOS( P_RequirementDate:$parameters.P_RequirementDate)
{
      @Search: {defaultSearchElement: true }
  key Material,
  key Plant,
  key MRPArea,
  key SourceDocument     as DDSourceDocument,
  key SourceDocumentItem as DDSourceDocumentItem,
      SourceDocumentType as DDSourceDocumentType,
      SOSTypeDescription,
      PurchasingOrganization,
      PurchasingGroup,
      ValidityEndDate,
      ValidityStartDate,
      MaterialMinLotSizeQuantity,
      MaterialMaxLotSizeQuantity,
      SupplyingPlant,
      Supplier,
      SupplierName,
      SOSType            as DemandDrivenSOSType,
      MRPElementCategory,
      DefaultSOS         as MaterialSOSIsDefault,
      BillOfOperationsType,
      StorageLocation,
      UoM                as SourceUnitOfMeasure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_DDMATERIALSOS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More