V_Mmim_Ddl_Obd_Pohist

DDL: V_MMIM_DDL_OBD_POHIST SQL: V_OBD_POHIST Type: view
4 Fields 1 Data Sources

Show Outbound Deliveries from PO history

V_Mmim_Ddl_Obd_Pohist is a CDS View that provides data about "Show Outbound Deliveries from PO history" in SAP S/4HANA. It reads from 1 data source (ekbe) and exposes 4 fields with key fields ebeln, ebelp, vbeln, posnr.

Data Sources (1)

SourceAliasJoin Type
ekbe ekbe from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName V_OBD_POHIST view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Show Outbound Deliveries from PO history view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ebeln ebeln Source PurchDoc
KEY ebelp ebelp Item pur. doc.
KEY vbeln belnr SD Document
KEY posnr

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 V_Mmim_Ddl_Obd_Pohist.
-- 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: V_OBD_POHIST

CREATE VIEW V_Mmim_Ddl_Obd_Pohist AS
SELECT
  ebeln,
  ebelp,
  belnr AS vbeln,
  cast(concat( substring( ekbe.gjahr, 3, 2 ), ekbe.buzei ) as abap.numc( 6 )) AS posnr
FROM ekbe
;

Learn More