P_ACMLoadDataCaptureEvent

DDL: P_ACMLOADDATACAPTUREEVENT Type: view_entity BASIC
16 Fields 2 Data Sources

P_ACMLoadDataCaptureEvent is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_ACMLoadDataCapture, P_ACMLDCEventStatus) and exposes 16 fields with key field LDCKey.

Data Sources (2)

SourceAliasJoin Type
P_ACMLoadDataCapture Item from
P_ACMLDCEventStatus LDCEventStatus inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LDCKey P_ACMLoadDataCapture LDCKey UUID
ChangeDocumentStatusIsInactive P_ACMLDCEventStatus ChangeDocumentStatusIsInactive TRUE
VehicleId P_ACMLoadDataCapture VehicleId Vehicle No.
TruckRailBargeId P_ACMLoadDataCapture TruckRailBargeId Veh. ID
CmmdtyTransptVesselID P_ACMLoadDataCapture CmmdtyTransptVesselID Vessel Name
LoadDataCaptureApplInstruction P_ACMLoadDataCapture LoadDataCaptureApplInstruction Application Instr.
ACMScaleTicketNumber P_ACMLoadDataCapture ACMScaleTicketNumber Scale Ticket Number
BillOfLading P_ACMLoadDataCapture BillOfLading Bill of Lading
ToPostingDate P_ACMLoadDataCapture ToPostingDate Posting Date
BillOfLadingDate P_ACMLoadDataCapture BillOfLadingDate Document Date
ACMLoadDataCaptureLeadCarNo P_ACMLoadDataCapture ACMLoadDataCaptureLeadCarNo Lead Car No.
ACMLoadDataCaptureItmStatusObj P_ACMLoadDataCapture ACMLoadDataCaptureItmStatusObj Object number
LoadDataCaptureEventType P_ACMLoadDataCapture LoadDataCaptureEventType Type of Event
LoadDataCaptureItem P_ACMLoadDataCapture LoadDataCaptureItem Task ID
EventDate P_ACMLoadDataCapture EventDate Date
Material P_ACMLoadDataCapture Material Vehicle Model

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 P_ACMLoadDataCaptureEvent.
-- 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.

CREATE VIEW P_ACMLoadDataCaptureEvent AS
SELECT
  Item.LDCKey AS LDCKey,
  LDCEventStatus.ChangeDocumentStatusIsInactive AS ChangeDocumentStatusIsInactive,
  Item.VehicleId AS VehicleId,
  Item.TruckRailBargeId AS TruckRailBargeId,
  Item.CmmdtyTransptVesselID AS CmmdtyTransptVesselID,
  Item.LoadDataCaptureApplInstruction AS LoadDataCaptureApplInstruction,
  Item.ACMScaleTicketNumber AS ACMScaleTicketNumber,
  Item.BillOfLading AS BillOfLading,
  Item.ToPostingDate AS ToPostingDate,
  Item.BillOfLadingDate AS BillOfLadingDate,
  Item.ACMLoadDataCaptureLeadCarNo AS ACMLoadDataCaptureLeadCarNo,
  Item.ACMLoadDataCaptureItmStatusObj AS ACMLoadDataCaptureItmStatusObj,
  Item.LoadDataCaptureEventType AS LoadDataCaptureEventType,
  Item.LoadDataCaptureItem AS LoadDataCaptureItem,
  Item.EventDate AS EventDate,
  Item.Material AS Material
FROM P_ACMLoadDataCapture AS Item
INNER JOIN P_ACMLDCEventStatus AS LDCEventStatus ON /* join condition not captured in parsed metadata */
;

Learn More