P_SupDmndAllDocRetSlsOrdAssgmt

DDL: P_SUPDMNDALLDOCRETSLSORDASSGMT Type: view COMPOSITE

P_SupDmndAllDocRetSlsOrdAssgmt is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocRetSlsOrd) and exposes 32 fields.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocRetSlsOrd _SupDmndAllDocRetSlsOrd from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSUPDMNDRETORDAS view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (32)

KeyFieldSource TableSource FieldDescription
SupplyNumber I_SupDmndAllDocRetSlsOrd SupplyNumber
SupplyItem I_SupDmndAllDocRetSlsOrd SupplyItem
SupplyScheduleLine I_SupDmndAllDocRetSlsOrd SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocRetSlsOrd AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocRetSlsOrd SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocRetSlsOrd SupplyDeliveryDate
ProductAvailabilityDate I_SupDmndAllDocRetSlsOrd ProductAvailabilityDate
RequestedDeliveryDate I_SupDmndAllDocRetSlsOrd RequestedDeliveryDate
TotalQuantity I_SupDmndAllDocRetSlsOrd TotalQuantity
OpenSupplyQuantity
BaseUnit I_SupDmndAllDocRetSlsOrd BaseUnit
Material I_SupDmndAllDocRetSlsOrd Material
MaterialGroup I_SupDmndAllDocRetSlsOrd MaterialGroup
Plant I_SupDmndAllDocRetSlsOrd Plant
OrderType I_SupDmndAllDocRetSlsOrd OrderType
MaterialType I_SupDmndAllDocRetSlsOrd MaterialType
StockSegment I_SupDmndAllDocRetSlsOrd StockSegment
CrossPlantConfigurableProduct I_SupDmndAllDocRetSlsOrd CrossPlantConfigurableProduct
SalesOrganization I_SupDmndAllDocRetSlsOrd SalesOrganization
DistributionChannel I_SupDmndAllDocRetSlsOrd DistributionChannel
Division I_SupDmndAllDocRetSlsOrd Division
SalesDistrict I_SupDmndAllDocRetSlsOrd SalesDistrict
PurchasingOrganization I_SupDmndAllDocRetSlsOrd PurchasingOrganization
PurchasingGroup I_SupDmndAllDocRetSlsOrd PurchasingGroup
Batch I_SupDmndAllDocRetSlsOrd Batch
StorageLocation I_SupDmndAllDocRetSlsOrd StorageLocation
Customer I_SupDmndAllDocRetSlsOrd Customer
CompanyCode I_SupDmndAllDocRetSlsOrd CompanyCode
SDDocumentReason I_SupDmndAllDocRetSlsOrd SDDocumentReason
SalesDocumentRjcnReason I_SupDmndAllDocRetSlsOrd SalesDocumentRjcnReason
NetPriceAmount I_SupDmndAllDocRetSlsOrd NetPriceAmount
DocumentCurrency I_SupDmndAllDocRetSlsOrd DocumentCurrency 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM: {
  viewType: #COMPOSITE
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'PSUPDMNDRETORDAS',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
define view P_SupDmndAllDocRetSlsOrdAssgmt
  as select from    I_SupDmndAllDocRetSlsOrd as _SupDmndAllDocRetSlsOrd
    left outer to one join P_ARunAssgmtSup          as _ARunAssgmtSup on  _SupDmndAllDocRetSlsOrd.SupplyNumber       = _ARunAssgmtSup.SupplyNumber
                                                               and _SupDmndAllDocRetSlsOrd.SupplyItem         = _ARunAssgmtSup.SupplyItem
                                                               and _SupDmndAllDocRetSlsOrd.SupplyScheduleLine = _ARunAssgmtSup.SupplyScheduleLine
                                                               and _SupDmndAllDocRetSlsOrd.Plant              = _ARunAssgmtSup.Plant
                                                               and _SupDmndAllDocRetSlsOrd.Material           = _ARunAssgmtSup.Material
                                                               and _SupDmndAllDocRetSlsOrd.AssignedSupplyType = _ARunAssgmtSup.AssignedSupplyType
{
  _SupDmndAllDocRetSlsOrd.SupplyNumber,
  _SupDmndAllDocRetSlsOrd.SupplyItem,
  _SupDmndAllDocRetSlsOrd.SupplyScheduleLine,
  _SupDmndAllDocRetSlsOrd.AssignedSupplyType,
  _SupDmndAllDocRetSlsOrd.SupAssgmtSource,
  _SupDmndAllDocRetSlsOrd.SupplyDeliveryDate,
  _SupDmndAllDocRetSlsOrd.ProductAvailabilityDate,
  _SupDmndAllDocRetSlsOrd.RequestedDeliveryDate,
  _SupDmndAllDocRetSlsOrd.TotalQuantity,
  ( _SupDmndAllDocRetSlsOrd.OpenSupplyQuantity - coalesce( _ARunAssgmtSup.AssignedQuantityInBaseUnit , 0 ) ) as OpenSupplyQuantity,
  _SupDmndAllDocRetSlsOrd.BaseUnit,
  _SupDmndAllDocRetSlsOrd.Material,
  _SupDmndAllDocRetSlsOrd.MaterialGroup,
  _SupDmndAllDocRetSlsOrd.Plant,
  _SupDmndAllDocRetSlsOrd.OrderType,
  _SupDmndAllDocRetSlsOrd.MaterialType,
  _SupDmndAllDocRetSlsOrd.StockSegment,
  _SupDmndAllDocRetSlsOrd.CrossPlantConfigurableProduct,
  _SupDmndAllDocRetSlsOrd.SalesOrganization,
  _SupDmndAllDocRetSlsOrd.DistributionChannel,
  _SupDmndAllDocRetSlsOrd.Division,
  _SupDmndAllDocRetSlsOrd.SalesDistrict,
  _SupDmndAllDocRetSlsOrd.PurchasingOrganization,
  _SupDmndAllDocRetSlsOrd.PurchasingGroup,
  _SupDmndAllDocRetSlsOrd.Batch,
  _SupDmndAllDocRetSlsOrd.StorageLocation,
  _SupDmndAllDocRetSlsOrd.Customer,
  _SupDmndAllDocRetSlsOrd.CompanyCode,
  _SupDmndAllDocRetSlsOrd.SDDocumentReason,
  _SupDmndAllDocRetSlsOrd.SalesDocumentRjcnReason,
  _SupDmndAllDocRetSlsOrd.NetPriceAmount,
  _SupDmndAllDocRetSlsOrd.DocumentCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDALLDOCRETSLSORD",
"P_ARUNASSGMTSUP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More