C_SubcontrgPurchasingDocVH

DDL: C_SUBCONTRGPURCHASINGDOCVH SQL: CSCPURDOC Type: view CONSUMPTION
33 Fields 1 Data Sources

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)

SourceAliasJoin Type
I_ReservationItem _ReservationItem from

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY char15endasPurchasingDocument Document
KEY char5endasPurchasingDocumentItem Document Item
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
KEY RecordType RecordType Reservation Record Type
PurchaseOrder PurchasingDocument Purchasing Document
Supplier Supplier Supplier
PurchasingGroup _PurchasingDocument PurchasingGroup Purchasing Group
CompanyCode _PurchasingDocument CompanyCode Receiver Company Code
PurchasingDocumentDeletionCode _PurchasingDocument PurchasingDocumentDeletionCode Del. Indicator
ReleaseIsNotCompleted _PurchasingDocument ReleaseIsNotCompleted Subj.to Release
PurchasingCompletenessStatus _PurchasingDocument PurchasingCompletenessStatus Incomplete
ProductType _PurchasingDocumentItem ProductType Product Type Group
Material _PurchasingDocumentItem Material Vehicle Model
ServicePerformer _PurchasingDocumentItem ServicePerformer Service Performer
IsCompletelyDelivered _PurchasingDocumentItem IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced _PurchasingDocumentItem IsFinallyInvoiced Final Invoice
PurchasingOrganization _PurchasingDocument PurchasingOrganization Purchasing Organization
Plant Plant Valuation Area
GoodsMovementType GoodsMovementType Movement Type
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup
_SupplierCompanyByPlant _SupplierCompanyByPlant
DataController1 _Supplier DataController1 Data Controller
DataController2 _Supplier DataController2 Data Controller
DataController3 _Supplier DataController3 Data Controller
DataController4 _Supplier DataController4 Data Controller
DataController5 _Supplier DataController5 Data Controller
DataController6 _Supplier DataController6 Data Controller
DataController7 _Supplier DataController7 Data Controller
DataController8 _Supplier DataController8 Data Controller
DataController9 _Supplier DataController9 Data Controller
DataController10 _Supplier DataController10 Data Controller
DataControllerSet _Supplier DataControllerSet Data Ctrlr. Set

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SubcontrgPurchasingDocVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSCPURDOC

CREATE VIEW C_SubcontrgPurchasingDocVH AS
SELECT
  case when RequirementType = 'MR' then cast (Reservation as abap.char(15)) else cast (PurchasingDocument as abap.char(15)) end as PurchasingDocument AS char15endasPurchasingDocument,
  case when RequirementType = 'MR' then cast (ReservationItem as abap.char(5)) else cast (PurchasingDocumentItem as abap.char(5)) end as PurchasingDocumentItem AS char5endasPurchasingDocumentItem,
  Reservation,
  ReservationItem,
  RecordType,
  PurchasingDocument AS PurchaseOrder,
  Supplier,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument.CompanyCode AS CompanyCode,
  _PurchasingDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchasingDocument.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PurchasingDocument.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  _PurchasingDocumentItem.ProductType AS ProductType,
  _PurchasingDocumentItem.Material AS Material,
  _PurchasingDocumentItem.ServicePerformer AS ServicePerformer,
  _PurchasingDocumentItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchasingDocumentItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  Plant,
  GoodsMovementType,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM I_ReservationItem AS _ReservationItem
;

Learn More