P_ACMContSubItem

DDL: P_ACMCONTSUBITEM SQL: PACMCONTSUBITEM Type: view BASIC
17 Fields 1 Data Sources

CONSUMPTION VIEW for wbhd

P_ACMContSubItem is a Basic CDS View that provides data about "CONSUMPTION VIEW for wbhd" in SAP S/4HANA. It reads from 1 data source (wbhd) and exposes 17 fields with key field tkonn.

Data Sources (1)

SourceAliasJoin Type
wbhd Business from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PACMCONTSUBITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CONSUMPTION VIEW for wbhd view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY tkonn tkonn Trading Contract
elifn elifn Supplier
zterm zterm Terms of Payment
ekorg ekorg Purchasing Org.
ekgrp ekgrp Sub. purchasing grp
waers_purch waers_purch Currency
incov_sd incov_sd Inco. Version
inco2_l_sd inco2_l_sd Inco. Location1
inco3_l_sd inco3_l_sd Inco. Location2
incov_mm incov_mm Inco. Version
inco2_l_mm inco2_l_mm Inco. Location1
knumv_mm knumv_mm Doc. Condition
ihrez ihrez Your Reference
bstkd bstkd PO Number
zterm_sales zterm_sales PaytTermsSls
inco1_mm inco1_mm Incoterms Purch
inco1_sd inco1_sd Incoterms Sales

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_ACMContSubItem.
-- 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: PACMCONTSUBITEM

CREATE VIEW P_ACMContSubItem AS
SELECT
  tkonn,
  elifn,
  zterm,
  ekorg,
  ekgrp,
  waers_purch,
  incov_sd,
  inco2_l_sd,
  inco3_l_sd,
  incov_mm,
  inco2_l_mm,
  knumv_mm,
  ihrez,
  bstkd,
  zterm_sales,
  inco1_mm,
  inco1_sd
FROM wbhd AS Business
;

Learn More