P_SOFAPROCFLOW00

CDS View

P_SOFAPROCFLOW00 is a CDS View in S/4HANA. It contains 14 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 14 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SOFAProcFlow10 view from COMPOSITE
P_SOFAProcFlow11 view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY SalesDocument SalesDocument 1
KEY SDDocumentCategory SDDocumentCategory 2
DistributionChannel DistributionChannel 1
OrganizationDivision OrganizationDivision 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 1
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDocumentDate SalesDocumentDate 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 1
SoldToParty SoldToParty 1 
@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: #COMPOSITE
@AbapCatalog.sqlViewName: 'PSOFAPROCF0'

define view P_SOFAProcFlow00 
as select from
I_SalesDocument as SalesDocument          --PurchaseOrderByCustomer needs VBKD
{ 
   key SalesDocument,
   key SDDocumentCategory,
   
   SalesDocumentType,
   //Organization

   SalesDocument.SalesOrganization,
   SalesDocument.DistributionChannel,
   SalesDocument.OrganizationDivision,   

   OverallSDProcessStatus,
   OverallTotalDeliveryStatus,
   OverallOrdReltdBillgStatus, 
   
   //Misc

   RequestedDeliveryDate,
   --OverallSDProcessStatus,
   SalesDocumentDate,
   SalesGroup,
   SalesOffice,
   SoldToParty,
   PurchaseOrderByCustomer
   
         
 }
 where SalesDocument.SDDocumentCategory = 'C'   --> Order
 or    SalesDocument.SDDocumentCategory = 'I'   --> Order w/o charge
 or    SalesDocument.SDDocumentCategory = 'L'   --> Debit Memo Request
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More