Which tables does C_SubcontrgPurchasingDocVH use?

C_SubcontrgPurchasingDocVH reads from 1 data source(s): I_ReservationItem.

C_SubcontrgPurchasingDocVH

Q: How many fields does C_SubcontrgPurchasingDocVH have?

C_SubcontrgPurchasingDocVH has 33 fields. Key fields: char15endasPurchasingDocument, char5endasPurchasingDocumentItem, Reservation, ReservationItem, RecordType.

DDL: C_SUBCONTRGPURCHASINGDOCVH SQL: CSCPURDOC Type: view CONSUMPTION

Purchasing Document Value Help

C_SubcontrgPurchasingDocVH is a Consumption CDS View that provides data about "Purchasing Document Value Help" in SAP S/4HANA. It reads from 1 data source (I_ReservationItem) and exposes 33 fields with key fields char15endasPurchasingDocument, char5endasPurchasingDocumentItem, Reservation, ReservationItem, RecordType.

Data Sources (1)

Source	Alias	Join Type
I_ReservationItem	_ReservationItem	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CSCPURDOC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Purchasing Document Value Help	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#NONE	view
Search.searchable	true	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#S	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (33)

Key	Field	Source Table	Source Field	Description
KEY	char15endasPurchasingDocument			Document
KEY	char5endasPurchasingDocumentItem			Document Item
KEY	Reservation		Reservation
KEY	ReservationItem		ReservationItem
KEY	RecordType		RecordType
	PurchaseOrder		PurchasingDocument
	Supplier		Supplier
	PurchasingGroup	_PurchasingDocument	PurchasingGroup
	CompanyCode	_PurchasingDocument	CompanyCode
	PurchasingDocumentDeletionCode	_PurchasingDocument	PurchasingDocumentDeletionCode
	ReleaseIsNotCompleted	_PurchasingDocument	ReleaseIsNotCompleted
	PurchasingCompletenessStatus	_PurchasingDocument	PurchasingCompletenessStatus
	ProductType	_PurchasingDocumentItem	ProductType
	Material	_PurchasingDocumentItem	Material
	ServicePerformer	_PurchasingDocumentItem	ServicePerformer
	IsCompletelyDelivered	_PurchasingDocumentItem	IsCompletelyDelivered
	IsFinallyInvoiced	_PurchasingDocumentItem	IsFinallyInvoiced
	PurchasingOrganization	_PurchasingDocument	PurchasingOrganization
	Plant		Plant
	GoodsMovementType		GoodsMovementType
	AuthorizationGroup	_Supplier	AuthorizationGroup
	_SupplierCompanyByPlant		_SupplierCompanyByPlant
	DataController1	_Supplier	DataController1
	DataController2	_Supplier	DataController2
	DataController3	_Supplier	DataController3
	DataController4	_Supplier	DataController4
	DataController5	_Supplier	DataController5
	DataController6	_Supplier	DataController6
	DataController7	_Supplier	DataController7
	DataController8	_Supplier	DataController8
	DataController9	_Supplier	DataController9
	DataController10	_Supplier	DataController10
	DataControllerSet	_Supplier	DataControllerSet

@AbapCatalog.sqlViewName: 'CSCPURDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchasing Document Value Help'

@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #NONE 
@Search.searchable: true
@ObjectModel.semanticKey: ['PurchasingDocument', 'PurchasingDocumentItem']
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
//@OData.publish: true


define view C_SubcontrgPurchasingDocVH

  as select from I_ReservationItem as _ReservationItem

  // association [0..*] to I_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument



{

      @EndUserText.label: 'Document'
  key case when RequirementType = 'MR'
         then cast (Reservation as abap.char(15))
         else  cast (PurchasingDocument as abap.char(15))
         end                                                                                                                   as        PurchasingDocument,


      @EndUserText.label: 'Document Item'
  key case when RequirementType = 'MR'
         then cast (ReservationItem as abap.char(5))
         else  cast (PurchasingDocumentItem as abap.char(5))
         end                                                                                                                   as        PurchasingDocumentItem,
      //key _PurchasingDocumentItem.PurchasingDocumentItem         as PurchasingDocumentItem,


      //Exposing this for fuzziness filter

      @UI.hidden: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7}
      key Reservation,
      
      //Exposing this for fuzziness filter

      @UI.hidden: true
      key ReservationItem,
      
      //Exposing this for fuzziness filter

      @UI.hidden: true
      key RecordType,
      
      //Exposing this for fuzziness filter

      @UI.hidden: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7}
      PurchasingDocument                                                                                                       as        PurchaseOrder,

      case when RequirementType = 'MR'
        then cast('R' as abap.char(1))
        else  _PurchasingDocument.PurchasingDocumentCategory
        end                                                                                                                    as        PurchasingDocumentType,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7}
      Supplier,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }
      _PurchasingDocument.PurchasingGroup                                                                                      as        PurchasingGroup,

      @Search: { defaultSearchElement: true, ranking: #LOW , fuzzinessThreshold: 0.7}
      _PurchasingDocument.CompanyCode                                                                                          as        CompanyCode,

      _PurchasingDocument.PurchasingDocumentDeletionCode                                                                       as        PurchasingDocumentDeletionCode,

      _PurchasingDocument.ReleaseIsNotCompleted                                                                                as        ReleaseIsNotCompleted,

      _PurchasingDocument.PurchasingCompletenessStatus                                                                         as        PurchasingCompletenessStatus,


      _PurchasingDocumentItem.ProductType                                                                                      as        ProductType,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7}
      _PurchasingDocumentItem.Material                                                                                         as        Material,

      _PurchasingDocumentItem.ServicePerformer                                                                                 as        ServicePerformer,

      _PurchasingDocumentItem.IsCompletelyDelivered                                                                            as        IsCompletelyDelivered,

      _PurchasingDocumentItem.IsFinallyInvoiced                                                                                as        IsFinallyInvoiced,



      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }
      _PurchasingDocument.PurchasingOrganization,

      //Adding fields for DCL

      @UI.hidden: true
      Plant,
      @UI.hidden: true
      GoodsMovementType,
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.AuthorizationGroup,
      @UI.hidden: true
      @Consumption.hidden: true
      _SupplierCompanyByPlant,
      //_SupplierCompanyByPlant.AuthorizationGroup as SupplierFinsAuthorizationGrp

      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController1,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController2,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController3,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController4,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController5,
      
       @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController6,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController7,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController8,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController9,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataController10,
      
      @UI.hidden: true
      @Consumption.hidden: true
      _Supplier.DataControllerSet

}
where
  (
        RecordType                                             =  ' '
    and RequirementType                                        =  'BB'
    and PurchasingDocument                                     <> ''

    and _PurchasingDocumentItem.PurchasingDocumentDeletionCode =  ''

    and _PurchasingDocumentItem.IsCompletelyDelivered          =  ''

    and _PurchasingDocument.PurchasingDocumentDeletionCode     =  ''
  )
  or(
        IssgOrRcvgSpclStockInd                                 =  'O'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_RESERVATIONITEM",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_SUPPLIERCOMPANYBYPLANT"
],
"BASE":
[
"I_RESERVATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_SubcontrgPurchasingDocVH view

I_ReservationItem view