P_ACCGO_CONTRACT_DTLS

DDL: P_ACCGO_CONTRACT_DTLS SQL: P_CONT_DATA Type: view BASIC

P_ACCGO_CONTRACT_DTLS is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (wbhk, wbhd, wbgt) and exposes 9 fields with key fields contract, contract_itm.

Data Sources (3)

SourceAliasJoin Type
wbhk contract_hdr inner
wbhd contract_org_data from
wbgt wbgt inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_CONT_DATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY contract wbhd tkonn Trading Contract
KEY contract_itm wbhd tposn Item Number
purch_org wbhd ekorg Purchasing Org.
purch_grp wbhd ekgrp Sub. purchasing grp
sales_org wbhk vkorg SD Sales Org.
dist_chnl wbhk vtweg RefDistCh-Cust/Mat.
division wbhk spart Source supplier
company_code wbhk company_code Company Code
wbgt_side wbgt side Side

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_ACCGO_CONTRACT_DTLS.
-- 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: P_CONT_DATA

CREATE VIEW P_ACCGO_CONTRACT_DTLS AS
SELECT
  contract_org_data.tkonn AS contract,
  contract_org_data.tposn AS contract_itm,
  contract_org_data.ekorg AS purch_org,
  contract_org_data.ekgrp AS purch_grp,
  contract_hdr.vkorg AS sales_org,
  contract_hdr.vtweg AS dist_chnl,
  contract_hdr.spart AS division,
  contract_hdr.company_code AS company_code,
  wbgt.side AS wbgt_side
FROM wbhd AS contract_org_data
INNER JOIN wbhk AS contract_hdr ON /* join condition not captured in parsed metadata */
INNER JOIN wbgt ON /* join condition not captured in parsed metadata */
;