P_DebitMemoReqProcFlow0

DDL: P_DEBITMEMOREQPROCFLOW0 SQL: PDMRPROCF0 Type: view CONSUMPTION

P_DebitMemoReqProcFlow0 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 8 fields with key fields Level1Document, Level1DocumentItem, DebitMemoRequest.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SalesDocument from

Annotations (9)

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 PDMRPROCF0 view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Level1Document
KEY Level1DocumentItem
KEY DebitMemoRequest
DebitMemoRequestType I_SalesDocumentBasic SalesDocumentType
SalesOrderCategory I_SalesDocumentBasic SDDocumentCategory
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
OrganizationDivision I_SalesDocumentBasic OrganizationDivision 
@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: 'PDMRPROCF0'
@AbapCatalog.preserveKey:true

define view P_DebitMemoReqProcFlow0
as select from
I_SalesDocumentBasic as SalesDocument
       
{
   //Key

   key cast( ' ' as vbeln_von) as Level1Document,
   key cast( ' ' as posnr_von) as Level1DocumentItem,
   
   //SalesOrder

   key cast(SalesDocument as vdm_sales_order) as DebitMemoRequest,
   SalesDocument.SalesDocumentType as DebitMemoRequestType,
   
   //Category

   SalesDocument.SDDocumentCategory as SalesOrderCategory,
   
    
   //Organization

   SalesDocument.SalesOrganization,
   SalesDocument.DistributionChannel,
   SalesDocument.OrganizationDivision,  
     
    case when
    (
      SalesDocument.OverallOrdReltdBillgStatus = 'A' or
      SalesDocument.OverallOrdReltdBillgStatus = 'B' )
    then
    'X'
    else
    ''
    end as BillingDocumentIsRequired 
 }
 where SalesDocument.SDDocumentCategory  = 'L'    --> Debit Memo Request

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

Learn More