@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: 'PSLSQTANPROCF0'
define view P_SlsQtanProcFlow0
as select from I_SalesDocumentBasic as SalesDocument
{
//Key
key cast('' as vbeln_von) as Level1Document,
key cast('' as posnr_von) as Level1DocumentItem,
//SalesQuotation
key cast(SalesDocument as sales_quotation) as SalesQuotation,
SalesDocumentType as SalesQuotationType,
SDDocumentCategory as SalesQuotationCategory,
//Organization
SalesOrganization,
DistributionChannel,
OrganizationDivision,
//Status
case when
( OverallTotalDeliveryStatus = 'A' or
OverallTotalDeliveryStatus = 'B' )
then
'X'
else
''
end as DeliveryDocumentIsRequired,
case when
( OverallOrdReltdBillgStatus = 'A' or
OverallOrdReltdBillgStatus = 'B' )
then
'X'
else
''
end as BillingDocumentIsRequired,
//Order relevant for Project e.g Professional Service
'' as SalesOrderIsProjectBased
}
where
SDDocumentCategory = 'B';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/