Start SAP ABAP Archiv nach Kategorie "CDS-Views"

Kategorie: CDS-Views

[ABAP] Lesen des Inhalts von CDS-Entitäten 

TRY.
* Beispiel: View-Entität 'C_PURCHASEORDERITEMACCTMNTR' lesen
    DATA(o_v) = xco_cds=>view_entity( 'C_PURCHASEORDERITEMACCTMNTR' ).
    IF o_v->exists( ).
      DATA(o_cont) = o_v->content( )->get( ).
      DATA(o_fields) = o_v->fields->all->get( ).

* Daten im Inline-Browser im SAP-Fenster anzeigen
      cl_abap_browser=>show_html( EXPORTING
                                    title        = 'CDS-Info'
                                    html_string  = cl_demo_output=>new( )->write_data( o_cont )->write_data( o_fields )->get( )
                                    container    = cl_gui_container=>default_screen ).

* cl_gui_container=>default_screen erzwingen
      WRITE: space.
    ENDIF.
  CATCH cx_root INTO DATA(e_text).
    MESSAGE e_text->get_text( ) TYPE 'S' DISPLAY LIKE 'E'.
ENDTRY.

Links

[CDS-Views] Übersicht zu nützlichen CDS-Views

ObjekteCDS-ViewKurzbezeichnungBemerkung
AdresseI_AddressAddressADCP, ADRC
AdresseI_Address_2Address of an Organization or a PersonADRP, ADCP, ADRC
ÄnderungsbelegeI_InvgCsMChangeLogICM Change LogCDHDR, CDPOS
AuftragI_OrderOrder HeaderAUFK, AFKO
AuftragI_OrderItemOrder ItemAFPO
AuftragI_SalesOrderSales OrderVBKD, VEDA, VBAK
AuftragI_SalesOrderItemSales Order ItemVBAP, VBAK, VBKD, VEDA
AuftragI_SalesDocumentSales DocumentVBKD, VEDA, VBAK
AuftragI_SalesDocumentItemSales Document ItemVBAP, VBAK, VBKD, VEDA
AuftragI_SalesOrderCubeSales Order – CubeVBAP, VBKD, VEDA, VBAK, FPLT, VBEP
BenutzerI_UserUserUSR21
BestellanforderungA_PurchaseRequisitionItemItemEBAN
BestellanforderungI_PurchaserequisitionitemPurchase Requisition ItemEBAN
BestellanforderungA_PurReqnAcctAssgmtAccount AssignmentEBAN, EBKN
BestellanforderungI_PurchaseReqnItemPurchase Requisition ItemsEBAN
BestellanforderungI_PurchaserequisitionPurchase Requisition HeaderEBAN
BestellungA_PurchaseOrderPurchase OrderEKKO
BestellungI_PurchaseOrderEnhancedPurchase Order enhancedEKKO, EKPO, EKET, EKBE
BestellungA_PurchaseOrderItemItemEKKO, EKPO
BestellungI_PurchaseorderItemEnhancedPurchase Order Item enhancedEKKO, EKPO, EKET, EKBE
BestellungI_PurchaseOrderItemAPI01Purchase Order ItemEKKO, EKPO
BestellungC_PurchaseOrderItemMoniMonitor Purchase Order ItemsEKKO, EKPO, EKET, EKES, EKBE
BestellungA_PurOrdAccountAssignmentAccount AssignmentEKKO, EKPO, EKKN
BestellungI_PurOrdAccountAssignmentPurchase Order Account AssignmentEKKO, EKPO, EKKN
BestellungC_PurchaseorderitemacctmntrPurchase Order Items by Account AssignmentEKKO, EKPO, EKKN, EKET, EKBE, AFKO
BestellungI_PurchasingDocumentItemPurchasing Document ItemEKKO, EKPO
BestellungC_PoItemMoniCalcFieldCalculation field for Monitor POEKKO, EKPO, EKBE
BestellungR_POItemNextDeliveryCalcPO Item Next Delivery CalculationEKKO, EKPO, EKET
BestellungA_PurchaseOrderScheduleLineSchedule LinesEKKO, EKPO, EKET
BestellungI_PurchaseOrderScheduleLinePurchase Order Schedule LineEKKO, EKPO, EKET
BestellungI_PurgDocScheduleLinePurchasing Document Schedule LineEKET
BestellungI_PurchaseOrderHistoryBasicPurchase Order HistoryEKKO, EKPO, EKBE
BestellungI_PurchaseOrderHistoryPurchase Order HistoryEKKO, EKPO, EKBE
BestellungI_POSubcontractingCompAPI01Subcontracting Component in PurOrdEKKO, RESB
BestellungI_PurOrdPricingElementPurchase Order Pricing ElementEKKO, PRCD_ELEMENTS
BestellungI_SupplierPurchasingOrgSupplier Purchasing OrganizationLFA1, LFM1
BewertungskreisI_ValuationAreaValuation AreaT001K
BuchhaltungsbelegI_JournalEntryJournal EntryBKPF
BuchhaltungsbelegI_JournalEntryItemJournal Entry ItemACDOCA, FINSC_LEDGER_REP
BuchungskreisI_CompanyCodeCompany CodeT001
ControllingI_ControllingCommitmentCommitment for ControllingCOOI
ControllingI_ControllingCommitmentLineItmCommitment Line Item ControllingCOOI, CSKS
DictionaryRsodp_Abap_Cds_View2stobABAP CDS: Name of SQL View and Structure ObjectDDLDEPENDENCY
DictionaryVfs_Object_SearchSearchTTREE, BADI_SPOT, TDEVC, TADIR, DD021, SEDT_PROGRAM, SEDT_FUNC, SEDT_WDYN, V_DDLDEP, WDY_COMPONENT
Dictionaryris_quick_search_viewQuick Search: Ctrl.+Shift.+ATTREE, BADI_SPOT, TDEVC, TADIR, DD021, SEDT_PROGRAM, SEDT_FUNC, SEDT_WDYN, V_DDLDEP, WDY_COMPONENT
Dokumenteninfosatzshsm_drad_drawValue help for search help CV01ODRAD, DRAW
DokumenteninfosatzP_DocumentInfoRecordAttachmentDocument Info Record AttachmentDMS_DOC2LOIO, DMS_PHIO2FILE, DMS_PH_CHKO_CD1, DMS_DOC_FILES, DMS_PHF_CD1, DMS_PH_CD1
DokumenteninfosatzA_DocumentInfoRecordAttchAttachments for Document Info RecordDRAT, TDWS, TDWST, DOST, DRAW
DokumenteninfosatzP_DocInfoRecdOriginalOriginals Of Document Info RecordsDMS_DOC2LOIO, DMS_PHIO2FILE, DMS_PH_CHKO_CD1, DMS_DOC_FILES, DMS_PHF_CD1, DMS_PH_CD1
EinkäufergruppeI_PurchasingGroupPurchasing GroupT024
EinkaufsinfosatzM_V_inforecordInforecordEINA, EINE
EinkaufsinfosatzI_PurchasingInfoRecordApi01Purchasing Info RecordEINA
EinkaufsinfosatzI_PurgInfoRecdOrgPlntDataApi01Org Plant Data for Purch Info RecordEINE
FioriCDS_SUI_TM_MM_CATCDS View for Catalogs
FioriCDS_SUI_TM_MM_APPCDS View for App Descriptor Items
GeschäftspartnerI_BusinessPartnerBusiness PartnerBUT000
GeschäftspartnerI_CustomerCustomerKNA1
GeschäftspartnerI_SupplierSupplierLFA1
Kalender, DatumI_CalendarDateDateSCAL_TT_DATE
Klassen, MerkmaleI_ClfnCharcBasicClassification Characteristic BasicCABN
Klassen, MerkmaleI_CharacteristicCharacteristicCABN
Klassen, MerkmaleI_RelstartcharCharacteristic Basic ViewCABN, CABNT
Klassen, MerkmaleI_ClassHeaderClass HeaderKLAH
Klassen, MerkmaleI_ClfnClassClassification ClassKLAH
Klassen, MerkmaleI_RelstratclassManage Class Basic ViewKLAH, SWOR
KontraktI_PurchaseContractPurchase ContractEKKO
KontraktA_PurchaseContractItemItemEKKO, EKPO
KontraktI_PurchaseContractItemPurchase Contract ItemEKKO, EKPO
KontraktI_PurContrAccountAssgmtPurchase Contract Account AssignmentEKKO, EKPO, EKKN
KontraktI_PurContrValidityStatusPurchase Contract Validity StatusEKKO, EKPO, EKAB
KontraktI_PurCtrAddressAddress For Contract ItemEKKO, EKPO, ADCP, ADRC
KostenrechnungskreisI_ControllingAreaControlling AreaTKA01, T000
LagerortI_StorageLocationStorage LocationT001L
LeistungserfassungI_ServiceEntrySheetService Entry SheetEKKO, EKPO, EKET
LeistungserfassungI_ServiceEntrySheetItemService Entry Sheet ItemEKKO, EKPO, EKET, MARA
LieferbelegI_DeliveryDocumentDelivery DocumentLIKP
LieferbelegI_DeliveryDocumentItemDelivery Document ItemLIKP, LIPS
MaterialI_SlowOrNonMovingMatlCubeSlow or Non-Moving MaterialsMATDOC, MARA, MAKT, CKMLCR, VBKD, VEDA, VBAK
MaterialA_ProductPlantPlant DataMARA, MARC
MaterialI_ProductPlantProduct PlantMARA, MARC
MaterialI_MaterialMaterialMARA
MaterialI_ProductProductMARA
MaterialI_MaterialInclStorLocationMaterial including Storage LocationMARA, MARC, MARD
MaterialI_MaterialStockMaterial Stock CalculationMATDOC
MaterialI_MaterialValuationPricesMaterial Valuation PricesCKMLCR, CKMLHD, PRPS, CKMLPR
MaterialI_ProductValuationTP_2Product Valuation - TP
MaterialI_ProdValnLedgerAccountTP_2Product Valuation Ledger Account - TP
MaterialI_ProdValuationAccountingTP_2Product Valuation Accounting - TP
MaterialI_ProductPlantTP_2Product Plant - TP
MaterialI_MaterialGroupTextMaterial Group TextT023, T023T
MaterialI_ProductUnitsOfMeasureUnits of Measure of ProductMARA, MARM
MaterialbelegeI_MaterialDocumentHeader_2Material Document HeaderMATDOC
MaterialbelegeI_MaterialDocumentItem_2Material Document ItemMATDOC
MengeneinheitenI_UnitOfMeasureUnit of MeasureT006, T006A
Profit CenterSHSM_PROFITCENTER_VHProfit Center Value HelpCEPC, CEPCT
ProjektI_ProjectProject Definition DetailsPROJ
PSP-ElementI_MM_WBSElementValueHelpPurchasing WBS Element Value HelpPROJ, PRPS
PSP-ElementI_WBSElementWBS Element DetailsPRTE, PROJ, PRPS
ReservierungI_ReservationDocumentHeaderReservation Document HeaderRKPF
ReservierungI_ReservationDocumentItemReservation Document ItemRKPF, RESB
SAPscriptI_TextObjectText ObjectSTHX, STXL
VertriebI_SalesDocumentSales DocumentVBKD, VEDA, VBAK
WährungI_CurrencyCurrencyTCURC, TCURX
WerkI_PlantPlantT001W
Werk, Buchungskreis, KostenrechnungskreisP_Kkag_Werk_Bukrs_KokrsPlant - Company Code - Co AereaT001K, T001W, TKA02
Werk, EinkaufsorganisationC_MM_PlantValueHelpPlant Value HelpT001W, T024E
WorkflowC_WorkflowtaskDEPRECATED: Work item with text infoSWWWIHEAD, SWPSTEPLOG, SWWWITEXT
WorkflowI_WorkflowTaskWorkflow work itemsSWWWIHEAD, SWPSTEPLOG, SWWWICOMMENT

Pakete

ODATA_MM_COMMONS_VH (Eingabehilfe-Consumption-Views für MM)

Links

erp-up.de

  • ABAP Cloud: Die wichtigsten CDS Views

SAP API für CDS-Views

  • SAP-Standard CDS Views suchen

SAP Virtuelles Datenmodell und CDS-Views

  • Dokumentation von CDS-Views über verschiedene Geschäftsbereiche

paspas.io

[ABAP] CDS-Views: Alle Spaltenbezeichner eines CDS-Views ausgeben 

* Beispiel: alle Annotationen des CDS-Views 'C_PURCHASEORDERITEMMONI' lesen
cl_dd_ddl_annotation_service=>get_annos( EXPORTING entityname    = 'C_PURCHASEORDERITEMMONI'
                                         IMPORTING element_annos = DATA(it_element_annos) ).

* alle Annotationen in der Liste löschen, außer 'EnduserText.Label'
DELETE it_element_annos WHERE annoname NE 'ENDUSERTEXT.LABEL'.

LOOP AT it_element_annos ASSIGNING FIELD-SYMBOL(<a>).
  WRITE: / <a>-elementname, <a>-value.
ENDLOOP.

[ABAP] CDS-View zur Anzeige von Änderungsbelegen 

TRY.
* CDS-View I_INVGCSMCHANGELOG (ICM Change Log),
* JOIN aus CDHDR + CDPOS
    SELECT FROM i_invgcsmchangelog
      FIELDS *
      WHERE invgcsmchangelogcreatedbyid EQ @sy-uname
      INTO TABLE @DATA(it_cd).

    IF sy-subrc = 0.
* SALV-Table
      DATA: o_salv TYPE REF TO cl_salv_table.

      cl_salv_table=>factory( IMPORTING r_salv_table = o_salv
                              CHANGING  t_table      = it_cd ).

* Grundeinstellungen
      o_salv->get_functions( )->set_all( abap_true ).
      o_salv->get_columns( )->set_optimize( abap_true ).
      o_salv->get_display_settings( )->set_list_header( 'Änderungsbelege' ).
      o_salv->get_display_settings( )->set_striped_pattern( abap_true ).
      o_salv->get_selections( )->set_selection_mode( if_salv_c_selection_mode=>row_column ).

      o_salv->display( ).
    ENDIF.

  CATCH cx_root INTO DATA(e_txt).
    WRITE: / e_txt->get_text( ).
ENDTRY.

Links

[CDS-Views] Fehler „Referenzinformationen fehlen oder falscher Datentyp“ beheben

Ursache

Für Elemente des Datentyps CURR oder QUAN sind in einem CDS-View Referenzinformationen erforderlich. Diese Informationen fehlen.

Lösung 1

Die Referenzinformationen müssen wie folgt in der Datendefinition gepflegt werden:

// Referenzfeld für Preiseinheit
@Semantics.currencyCode: true  
Preiseinheit,
@Semantics.amount.currencyCode: 'Preiseinheit'
Preis

// Referenzfeld für Maßeinheit
@Semantics.unitOfMeasure: true
Uom,
@Semantics.quantity.unitOfMeasure: 'Uom'
Menge

Lösung 2

Mit folgender View-Annotation kann gesteuert werden, ob geerbte Annotationen berücksichtigt werden oder nicht.

@Metadata.ignorePropagatedAnnotations: true
...

Lösung 3

Falls im Eclipse beim Editieren der view entity folgender Fehler Auftritt: „Annotation &1&2&3&4 ist in View-Entitäten nicht zulässig.“ (SD_CDS_ENTITY105), hilft ggf., sich ein Währungsfeld zum importieren und darauf zu referenzieren (Beispiel):

define view entity Z_CDS
  as select from XYZ as a
    inner join t093b as t on a.bukrs = t.bukrs
{
    ...

    a.meins,
    a.menge,

    t.waers as waers,

    @Semantics.amount.currencyCode: 'WAERS'
    a.kansw,

    ...
}

Links

[CDS-Views] Einfachen CDS-View erstellen und Daten anzeigen

Anlegen des CDS-Views in Eclipse (ab ABAP 7.4 SP8)

* Menü -> File -> New -> Other -> Core Data Services -> Data Definition

* CDS-View als DDIC Objekt erstellen
@AbapCatalog.sqlViewName: 'ZCDS_MATNR_VIEW'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MATNR lesen'
@Metadata.allowExtensions: true

define view ZCDS_MATNR as select from mara as ma
  inner join makt as kt on ma.matnr = kt.matnr
{
  key ma.matnr as matnr,
  
  ma.ernam as ersteller,
  
  ma.vpsta as pflegestatus,
  
  case ma.lvorm
    when 'X' then 'gelöscht'
    else 'aktiv'
  end as loeschvormerkung,
  
  kt.maktx as kurztext
};

ABAP-Quellcode zum Auslesen des CDS-Views

* Variante 1 (SELECT)
DATA: it_matnr TYPE STANDARD TABLE OF zcds_matnr.

SELECT * FROM zcds_matnr INTO TABLE @it_matnr.

LOOP AT it_matnr ASSIGNING FIELD-SYMBOL(<mat>).
  WRITE: / <mat>-matnr, <mat>-ersteller, <mat>-pflegestatus, <mat>-loeschvormerkung, <mat>-kurztext.
ENDLOOP.

* Variante 2 (SALV TABLE IDA)
TRY.
    cl_salv_gui_table_ida=>create_for_cds_view( CONV #( 'ZCDS_MATNR' ) )->fullscreen( )->display( ).
  CATCH cx_root INTO DATA(e_txt).
    WRITE: / e_txt->get_text( ).
ENDTRY.

Links

[CDS-Views] CDS-View mit Parametern erstellen und anzeigen

CDS-View als DDIC Objekt erstellen

@AbapCatalog.sqlViewName: 'ZCDS_MATNR_VIEW'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MATNR lesen'
@Metadata.allowExtensions: true

define view ZCDS_MATNR
  with parameters p_min_date : dats,
                  p_max_date : dats
  as select from mara as ma
  inner join makt as kt on ma.matnr = kt.matnr
{
  key ma.matnr as matnr,
  
  ma.ernam as ersteller,
  
  ma.vpsta as pflegestatus,
  
  case ma.lvorm
    when 'X' then 'gelöscht'
    else 'aktiv'
  end as loeschvormerkung,
  
  kt.maktx as kurztext
  
} where ma.ernam like 'A%' and ma.ersda between :p_min_date and :p_max_date;

ABAP-Quellcode zum Auslesen des CDS-Views

DATA: it_matnr TYPE STANDARD TABLE OF zcds_matnr.

SELECT * FROM zcds_matnr( p_min_date = '20170101', p_max_date = '20171231' ) INTO TABLE @it_matnr.

LOOP AT it_matnr ASSIGNING FIELD-SYMBOL(<mat>).
  WRITE: / <mat>-matnr, <mat>-ersteller, <mat>-pflegestatus, <mat>-loeschvormerkung, <mat>-kurztext.
ENDLOOP.