P_ProductProposalSlsOrderItem

DDL: P_PRODUCTPROPOSALSLSORDERITEM SQL: PPRODPROPSLSITM Type: view COMPOSITE

P_ProductProposalSlsOrderItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SalesDocument, I_SalesDocumentItem) and exposes 14 fields with key fields SalesDocument, SalesDocumentItem. It has 1 association to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocument Header inner
I_SalesDocumentItem Item from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CustomerSalesArea _CustomerSalesArea Header.SoldToParty = _CustomerSalesArea.Customer and Header.SalesOrganization = _CustomerSalesArea.SalesOrganization and Header.DistributionChannel = _CustomerSalesArea.DistributionChannel and Header.OrganizationDivision = _CustomerSalesArea.Division

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPRODPROPSLSITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItem SalesDocument
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem
SalesDocumentItemUUID I_SalesDocumentItem SalesDocumentItemUUID
SalesDocumentType I_SalesDocument SalesDocumentType
SalesOrganization I_SalesDocument SalesOrganization
DistributionChannel I_SalesDocument DistributionChannel
OrganizationDivision I_SalesDocument OrganizationDivision
SoldToParty I_SalesDocument SoldToParty
Product I_SalesDocumentItem Product
OrderQuantityUnit I_SalesDocumentItem OrderQuantityUnit
BaseUnit I_SalesDocumentItem BaseUnit
Plant I_SalesDocumentItem Plant
Batch I_SalesDocumentItem Batch
RequestedDeliveryDate I_SalesDocument RequestedDeliveryDate 
@AbapCatalog.sqlViewName: 'PPRODPROPSLSITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AccessControl.personalData.blocking 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

define view P_ProductProposalSlsOrderItem

as select from I_SalesDocumentItem as Item

  
  inner join I_SalesDocument                           as Header                         on  Item.SalesDocument = Header.SalesDocument
  association [0..1] to I_CustomerSalesArea            as _CustomerSalesArea             on  Header.SoldToParty = _CustomerSalesArea.Customer                                                                                        
                                                                                         and Header.SalesOrganization = _CustomerSalesArea.SalesOrganization 
                                                                                         and Header.DistributionChannel = _CustomerSalesArea.DistributionChannel 
                                                                                         and Header.OrganizationDivision = _CustomerSalesArea.Division 
   
{
 key  Item.SalesDocument,
 key  Item.SalesDocumentItem,
      Item.SalesDocumentItemUUID,
      Header.SalesDocumentType,
      Header.SalesOrganization,
      Header.DistributionChannel,
      Header.OrganizationDivision,
      Header.SoldToParty,
      Item.Product,
      case
      when Item.OrderToBaseQuantityDnmntr != 0 then
      Item.OrderQuantity * DIVISION( Item.OrderToBaseQuantityNmrtr, Item.OrderToBaseQuantityDnmntr, 3)
      else 0 end as ProductBaseQuantity,
      Item.OrderQuantityUnit,

      Item.BaseUnit,
      Item.Plant,
      Item.Batch,

      Header.RequestedDeliveryDate
      
} where

  Header.SDDocumentCategory = 'C'
  and Item._SalesDocument._SalesDocumentType.SlsDocProdProposalProcedure != ''
  and _CustomerSalesArea.CustProdProposalProcedure != ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERSALESAREA",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTTYPE"
],
"ASSOCIATED":
[
"I_CUSTOMERSALESAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More