P_ProdAllocSalesOrderPartner

DDL: P_PRODALLOCSALESORDERPARTNER SQL: PPASOPART Type: view COMPOSITE

P_ProdAllocSalesOrderPartner is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (vbap) and exposes 3 fields with key fields vbeln, posnr, parvw. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
vbap Item inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] vbpa _ItemPartner _ItemPartner.vbeln = Item.vbeln and _ItemPartner.posnr = Item.posnr and _ItemPartner.parvw = Partner.parvw

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPASOPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbap vbeln
KEY posnr vbap posnr
KEY parvw Partner parvw 
@AbapCatalog.sqlViewName: 'PPASOPART'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
define view P_ProdAllocSalesOrderPartner
  as select distinct from vbpa as Partner
    inner join            vbap as Item on Item.vbeln      = Partner.vbeln
                                       and(
                                         Item.posnr       = Partner.posnr
                                         or Partner.posnr = '000000'
                                       )
  association [0..1] to vbpa as _ItemPartner on  _ItemPartner.vbeln = Item.vbeln
                                             and _ItemPartner.posnr = Item.posnr
                                             and _ItemPartner.parvw = Partner.parvw
{
  key  Item.vbeln,

  key  Item.posnr,

  key  Partner.parvw,

       case
         when _ItemPartner.posnr is not null
           then _ItemPartner.kunnr
         else Partner.kunnr
       end      as kunnr,

       case
         when _ItemPartner.posnr is not null
           then _ItemPartner.parnr
         else Partner.parnr
       end      as parnr,

       case
          when _ItemPartner.posnr is not null
            then _ItemPartner.lifnr
          else Partner.lifnr
        end     as lifnr,
       case
         when _ItemPartner.posnr is not null
           then _ItemPartner.pernr
         else Partner.pernr
       end      as pernr,
       case
          when _ItemPartner.adrnr is not null
            then _ItemPartner.adrnr
            else
            Partner.adrnr
            end as adrnr

}

Learn More