Which tables does P_BSQPMSolnQtanProcFlw use?

P_BSQPMSolnQtanProcFlw reads from 14 data source(s): P_BSQPMBillgDocToCAInvcgDoc, P_BSQPMBillgDocToSDInvc, I_BusSolutionQuotationType, P_BSQPMBillgDocSDToCAInvcgDoc, P_BSQPMPurOrdToGR, P_BSQPMPurOrdToSuplrInvc, P_BSQPMPurReqnToPurOrd, P_BSQPMSrvcContrToBillgDocReq, P_BSQPMSrvcDocFllwUpDoc, P_BSQPMSrvcDocFUPBizOrdDoc and more.

P_BSQPMSolnQtanProcFlw

Q: How many fields does P_BSQPMSolnQtanProcFlw have?

P_BSQPMSolnQtanProcFlw has 44 fields. Key fields: SubsequentDocument, SubsequentDocumentCategory, SubsequentDocumentCategory, SubsequentDocumentCategory, SubsequentDocumentCategory.

DDL: P_BSQPMSOLNQTANPROCFLW Type: view_entity COMPOSITE

P_BSQPMSolnQtanProcFlw is a Composite CDS View in SAP S/4HANA. It reads from 14 data sources and exposes 44 fields with key fields SubsequentDocument, SubsequentDocumentCategory, SubsequentDocumentCategory, SubsequentDocumentCategory, SubsequentDocumentCategory. It has 1 association to related views.

Data Sources (14)

Source	Alias	Join Type
P_BSQPMBillgDocToCAInvcgDoc	BillgDocToCAInvcgDoc	union
P_BSQPMBillgDocToSDInvc	BillgDocToSDInvc	union
I_BusSolutionQuotationType	BusinessSolutionQuotationType	inner
P_BSQPMBillgDocSDToCAInvcgDoc	P_BSQPMBillgDocSDToCAInvcgDoc	union
P_BSQPMPurOrdToGR	P_BSQPMPurOrdToGR	union
P_BSQPMPurOrdToSuplrInvc	P_BSQPMPurOrdToSuplrInvc	union
P_BSQPMPurReqnToPurOrd	P_BSQPMPurReqnToPurOrd	union
P_BSQPMSrvcContrToBillgDocReq	P_BSQPMSrvcContrToBillgDocReq	union
P_BSQPMSrvcDocFllwUpDoc	P_BSQPMSrvcDocFllwUpDoc	union
P_BSQPMSrvcDocFUPBizOrdDoc	P_BSQPMSrvcDocFUPBizOrdDoc	union
P_BSQPMSrvcOrdToPurOrd	P_BSQPMSrvcOrdToPurOrd	union
P_BSQPMPrvdrContrToBillgDoc	PrvdrContrToBillgDoc	union
P_BSQPMSbscrContrToPrvdrContr	SbscrContrToPrvdrContr	union
I_ServiceDocument	SolutionQuotation	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	P_BSQPMSolnQtanProcFlw	_ParentNode	`$projection.PrecedingDocument = _ParentNode.SubsequentDocument and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (44)

Key	Field	Source Field
KEY	SubsequentDocument
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
KEY	SubsequentDocumentCategory
	PrecedingDocument
	PrecedingDocumentCategory
	_ParentNode	_ParentNode

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory:   #XXL,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_BSQPMSolnQtanProcFlw
  as select from I_ServiceDocument          as SolutionQuotation
    inner join   I_BusSolutionQuotationType as BusinessSolutionQuotationType on BusinessSolutionQuotationType.BusSolutionQuotationType = SolutionQuotation.ServiceDocumentType
  association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                              and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SolutionQuotation.ServiceDocument as subsequ_doc  ) as SubsequentDocument,
  key cast( 'SQ' as subsequ_doc_cat )                           as SubsequentDocumentCategory,
      cast( '' as preced_doc )                                  as PrecedingDocument,
      cast( '' as preced_doc_cat )                              as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMSrvcDocFllwUpDoc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMSrvcDocFUPBizOrdDoc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMSbscrContrToPrvdrContr as SbscrContrToPrvdrContr
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMPrvdrContrToBillgDoc as PrvdrContrToBillgDoc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMBillgDocToSDInvc as BillgDocToSDInvc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMBillgDocToCAInvcgDoc as BillgDocToCAInvcgDoc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select distinct from I_SDDocumentProcessFlow as SalesDocumentFlow
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc )             as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}
where
  SubsequentDocumentCategory <> 'Q'

////union select from P_BSQPMOutbDelivToCAInvc

////association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument

////                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory

////{

////  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,

////  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,

////      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,

////      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,

////      _ParentNode

////}

////

////union select from P_BSQPMSlsOrdToCAInvc

////association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument

////                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory

////{

////  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,

////  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,

////      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,

////      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,

////      _ParentNode

////}


// Need to be added in abap units

////union select from P_BSQPMBillgDocReqToCAInvc

////association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument

////                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory

////{

////  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,

////  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,

////      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,

////      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,

////      _ParentNode

////}


union select from P_BSQPMBillgDocSDToCAInvcgDoc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMSrvcOrdToPurOrd
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMSrvcContrToBillgDocReq
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}
//union select from P_BSQPMSolnQtanToBillgDoc

//association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument

//                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory

//{

//  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,

//  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,

//      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,

//      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,

//      _ParentNode

//}

// Till here


union select from P_BSQPMPurOrdToSuplrInvc
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMPurReqnToPurOrd
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}

union select from P_BSQPMPurOrdToGR
association [0..1] to P_BSQPMSolnQtanProcFlw as _ParentNode on  $projection.PrecedingDocument         = _ParentNode.SubsequentDocument
                                                            and $projection.PrecedingDocumentCategory = _ParentNode.SubsequentDocumentCategory
{
  key cast( SubsequentDocument as subsequ_doc  )            as SubsequentDocument,
  key cast( SubsequentDocumentCategory as subsequ_doc_cat ) as SubsequentDocumentCategory,
      cast( PrecedingDocument as preced_doc )               as PrecedingDocument,
      cast( PrecedingDocumentCategory as preced_doc_cat )   as PrecedingDocumentCategory,
      _ParentNode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLUTIONQUOTATIONTYPE",
"I_SDDOCUMENTPROCESSFLOW",
"I_SERVICEDOCUMENT",
"P_BSQPMBILLGDOCSDTOCAINVCGDOC",
"P_BSQPMBILLGDOCTOCAINVCGDOC",
"P_BSQPMBILLGDOCTOSDINVC",
"P_BSQPMPRVDRCONTRTOBILLGDOC",
"P_BSQPMPURORDTOGR",
"P_BSQPMPURORDTOSUPLRINVC",
"P_BSQPMPURREQNTOPURORD",
"P_BSQPMSBSCRCONTRTOPRVDRCONTR",
"P_BSQPMSRVCCONTRTOBILLGDOCREQ",
"P_BSQPMSRVCDOCFLLWUPDOC",
"P_BSQPMSRVCDOCFUPBIZORDDOC",
"P_BSQPMSRVCORDTOPURORD"
],
"ASSOCIATED":
[
"P_BSQPMSOLNQTANPROCFLW"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_BSQPMSolnQtanProcFlw view_entity

I_ServiceDocument view
I_BusSolutionQuotationType view_entity
P_BSQPMBillgDocSDToCAInvcgDoc view_entity
P_BSQPMBillgDocToCAInvcgDoc view_entity
P_BSQPMBillgDocToSDInvc view_entity
P_BSQPMPrvdrContrToBillgDoc view_entity
P_BSQPMPurOrdToGR view_entity
P_BSQPMPurOrdToSuplrInvc view_entity
P_BSQPMPurReqnToPurOrd view_entity
P_BSQPMSbscrContrToPrvdrContr view_entity
P_BSQPMSrvcContrToBillgDocReq view_entity
P_BSQPMSrvcDocFllwUpDoc view_entity
P_BSQPMSrvcDocFUPBizOrdDoc view_entity
P_BSQPMSrvcOrdToPurOrd view_entity