P_SlsDocFlfllmntAnalyzerIss1

DDL: P_SLSDOCFLFLLMNTANALYZERISS1 SQL: PSOFANALYSISI1 Type: view CONSUMPTION Package: ODATA_SD_SOFA

SOFA Main List: Issues Step 1

P_SlsDocFlfllmntAnalyzerIss1 is a Consumption CDS View that provides data about "SOFA Main List: Issues Step 1" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderFlfmtIssueBasic) and exposes 17 fields with key fields SalesOrder, IssueCategory. Part of development package ODATA_SD_SOFA.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderFlfmtIssueBasic SalesOrderFulfillmentIssue from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PSOFANALYSISI1 view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
KEY IssueCategory IssueCategory
SalesOrderType SalesOrderType
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
RequestedDeliveryDate RequestedDeliveryDate
OverallSDProcessStatus
SalesGroup SalesGroup
SalesOffice SalesOffice
SoldToParty SoldToParty
PurchaseOrderByCustomer
NmbrOfIssuesInOrder
NmbrOfIssuesInDelivery
NmbrOfIssuesInInvoice
NmbrOfIssuesInSupply
NmbrOfAllIssues 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PSOFANALYSISI1'

define view P_SlsDocFlfllmntAnalyzerIss1

as select from I_SalesOrderFlfmtIssueBasic
as SalesOrderFulfillmentIssue    
{ 
   //SalesOrder

   key SalesOrder,
   key IssueCategory,
   
   SalesOrderType,
   
   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,     
   
    //Misc

    RequestedDeliveryDate,
    --OverallSDProcessStatus, --AT14.2.2020 no longer needed after vbap enhancement
    SalesDocumentDate,
    SalesGroup,
    SalesOffice,
    SoldToParty,
   -- PurchaseOrderByCustomer, --AT11.08.2020 VBKD-BSTKD no longer provided by issues (no true hdr attribute & too expensive)
      
   min(DueDays) as DueDays,
   
   sum( NmbrOfIssuesInOrder)    as NmbrOfIssuesInOrder,
   
   cast(
   case 
     when IssueCategory = '10_SO' then min(DueDays) 
     else 1
   end  
   as due_days) as DueDaysInOrder,
    
   sum( NmbrOfIssuesInDelivery) as NmbrOfIssuesInDelivery,
   
   cast(
   case 
     when IssueCategory = '20_DE' then min(DueDays) 
     else 1
   end  
   as due_days) as DueDaysInDelivery,   
   
   sum( NmbrOfIssuesInInvoice) as NmbrOfIssuesInInvoice,
   
   cast(
   case 
     when IssueCategory = '30_IN' then min(DueDays) 
     else 1
   end  
   as due_days) as DueDaysInInvoice,    
   
   sum( NmbrOfIssuesInSupply) as NmbrOfIssuesInSupply,
   
   cast(
   case 
     when IssueCategory = '15_SU' then min(DueDays) 
     else 1
   end  
   as due_days) as DueDaysInSupply,      
   
   sum(NmbrOfAllIssues) as NmbrOfAllIssues 
 }
 
 where IsPotentialFutureIssue = '0'
 group by SalesOrder,
          IssueCategory,
          SalesOrderType,
          SalesOrganization,
          DistributionChannel,          
          OrganizationDivision,
          RequestedDeliveryDate,
          --OverallSDProcessStatus, --AT14.2.2020 no longer needed after vbap enhancement
          SalesDocumentDate,
          SalesGroup,
          SalesOffice,
          SoldToParty --,
          --PurchaseOrderByCustomer     --AT11.08.2020 VBKD-BSTKD no longer provided by issues (no true hdr attribute & too expensive)

Learn More