Advertising:

CDS Views: Difference between revisions

From SAP Knowledge Base
No edit summary
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Template:MetaDesc|A list of CDS views for master and transaction data for various areas, e.g.:Materials Management, Sales, Finance or Master Data, Businesspartner and more.}}
[[category: Core_data_services]]
[[category: Core_data_services]]
In case for your aim there exist no CDS view, have a look at
In case no CDS views fits for your purpose, you could search with SAP CDS view browser
* OnPremise / Private Cloud: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/5418de55938d1d22e10000000a44147b.html
* OnPremise / Private Cloud: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/5418de55938d1d22e10000000a44147b.html
* https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/5418de55938d1d22e10000000a44147b.html
* Public Cloud: https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/5418de55938d1d22e10000000a44147b.html
* [[tables|Database tables]].
If a CDS view does exist, first select the CDS view taht is released for cloud development, if available.


= Materials Management =
Otherwise maybe you can find a database table
* [[tables|Database tables]]


== Procurement ==
If a CDS view exists and fits in your requirements, take the CDS view and not the database table.


=== Purchase Orders ===
== Overall ==
 
=== Basic ===
 
* I_APIsForSAPCloudPlatform
 
== Materials Management ==
 
=== Procurement / Purchasing ===
 
==== Purchase Order ====


{| class="wikitable"
{| class="wikitable"
Line 16: Line 26:
! Name !! Purpose !! OnPremise / Private Cloud !! Released for Cloud Development !! Notes !! !! Corresponding Database Table
! Name !! Purpose !! OnPremise / Private Cloud !! Released for Cloud Development !! Notes !! !! Corresponding Database Table
|-
|-
| Purchase Order || Get purchase order head data || I_PurchaseOrderAPI01 || I_PurchaseOrderAPI01 || || EKKO  
| Purchase Order || Get purchase order head data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/ae766bee9c7b4e938098c935f5962814.html?locale=en-US I_PurchaseOrderAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/ae766bee9c7b4e938098c935f5962814.html?locale=en-US I_PurchaseOrderAPI01] || || || EKKO  
|-
| Pricing Element || Get pricing element header data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/48e1ef6b2bde46a99a373981adf4e7d9.html?locale=en-US I_PurOrdPricingElementAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/48e1ef6b2bde46a99a373981adf4e7d9.html?locale=en-US I_PurOrdPricingElementAPI01] || || ||
|-
| Purchase Order Item || Get purchase order items data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/33192c1211354eed9e40fac66e55fcc1.html?locale=en-US I_PurchaseOrderItemAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/33192c1211354eed9e40fac66e55fcc1.html?locale=en-US I_PurchaseOrderItemAPI01] || || || EKPO
|-
| Pricing Element Item || Get pricing element item data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/a8c390b7e0b14ebcb82753ca78ad7d69.html?locale=en-US I_PurOrdItmPricingElementAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/a8c390b7e0b14ebcb82753ca78ad7d69.html?locale=en-US I_PurOrdPricingElementAPI01] || || ||
|-
| Purchase Order Schedule Line || Get purchase order schedule line || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/6e52f71dfb5a481b810ce0697708baf2.html?locale=en-US I_PurOrdItmPricingElementAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/6e52f71dfb5a481b810ce0697708baf2.html?locale=en-US I_PurOrdScheduleLineAPI01] || || || EKET
|-
| History || Get history data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/1c5ef1f414f74b1bba6967346c59c1d6.html?locale=en-US I_PurchaseOrderHistoryAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/1c5ef1f414f74b1bba6967346c59c1d6.html?locale=en-US I_PurchaseOrderHistoryAPI01] || || || EKBE
|-
|-
| Purchase Order Item || Get purchase order items data || I_PurchaseOrderItemAPI01 || I_PurchaseOrderItemAPI01 || EKPO ||
| History Delivery Cost || Get history data + delivery costs || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/b1153898e79d4cbf89f0f2c9f6672b7b.html?locale=en-US I_PurOrdHistDeliveryCostAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/366f95f47fc44bc8b75efd1bd8cc2064.html?locale=en-US I_PurOrdHistDeliveryCostAPI01] || || || EKBZ
|-
|-
| History || Get history data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/1c5ef1f414f74b1bba6967346c59c1d6.html?locale=en-US I_PurchaseOrderHistoryAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/1c5ef1f414f74b1bba6967346c59c1d6.html?locale=en-US I_PurchaseOrderHistoryAPI01]
| Account Assignment || Get account assignment data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/d3c5fdf24efa43ce8686a8a8e3ed6ce8.html?locale=en-US I_PurOrdAccountAssignmentAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/d3c5fdf24efa43ce8686a8a8e3ed6ce8.html?locale=en-US I_PurOrdAccountAssignmentAPI01] || || || EKKN
|-
|-
| History Delivery Cost || Get history data + delivery costs || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/b1153898e79d4cbf89f0f2c9f6672b7b.html?locale=en-US I_PurOrdHistDeliveryCostAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/366f95f47fc44bc8b75efd1bd8cc2064.html?locale=en-US I_PurOrdHistDeliveryCostAPI01]
| Supplier Confirmation Data  || Get supplier confirmation Data  data || [https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ee6ff9b281d8448f96b4fe6c89f2bdc8/db456325d85a442392bcfcf3129e58f3.html?locale=en-US I_POSupplierConfirmationAPI01] || [https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/46125872c9a345d7b2b32f26c1c164d7.html?locale=en-US I_POSupplierConfirmationAPI01] || || || EKES
|}
|}

Latest revision as of 17:04, 31 December 2024

In case no CDS views fits for your purpose, you could search with SAP CDS view browser

Otherwise maybe you can find a database table

If a CDS view exists and fits in your requirements, take the CDS view and not the database table.

Overall

Basic

  • I_APIsForSAPCloudPlatform

Materials Management

Procurement / Purchasing

Purchase Order

Name Purpose OnPremise / Private Cloud Released for Cloud Development Notes Corresponding Database Table
Purchase Order Get purchase order head data I_PurchaseOrderAPI01 I_PurchaseOrderAPI01 EKKO
Pricing Element Get pricing element header data I_PurOrdPricingElementAPI01 I_PurOrdPricingElementAPI01
Purchase Order Item Get purchase order items data I_PurchaseOrderItemAPI01 I_PurchaseOrderItemAPI01 EKPO
Pricing Element Item Get pricing element item data I_PurOrdItmPricingElementAPI01 I_PurOrdPricingElementAPI01
Purchase Order Schedule Line Get purchase order schedule line I_PurOrdItmPricingElementAPI01 I_PurOrdScheduleLineAPI01 EKET
History Get history data I_PurchaseOrderHistoryAPI01 I_PurchaseOrderHistoryAPI01 EKBE
History Delivery Cost Get history data + delivery costs I_PurOrdHistDeliveryCostAPI01 I_PurOrdHistDeliveryCostAPI01 EKBZ
Account Assignment Get account assignment data I_PurOrdAccountAssignmentAPI01 I_PurOrdAccountAssignmentAPI01 EKKN
Supplier Confirmation Data Get supplier confirmation Data data I_POSupplierConfirmationAPI01 I_POSupplierConfirmationAPI01 EKES

This is a wiki created in the spare time of a private person working in the SAP ERP area. The aim is to collect knowledge for the own use. The wiki is maintained to the best of knowledge and belief.
All products shown, including in form of screenshots, belong to SAP SE. Their trademarks are, among others: SAP®,ABAP®,SAP Fiori®,SAP HANA®,SAP NetWeaver®,SAP® R/3®,SAP S/4HANA®,SAP S/4HANA® Cloud

Retrieved from "https://unirab.org/index.php?title=CDS_Views&oldid=732"