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.

3 data source(s) 9 fields

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
KEY contract_itm wbhd tposn
purch_org wbhd ekorg
purch_grp wbhd ekgrp
sales_org wbhk vkorg
dist_chnl wbhk vtweg
division wbhk spart
company_code wbhk company_code
wbgt_side wbgt side 
@AbapCatalog.sqlViewName: 'P_CONT_DATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC

define view P_ACCGO_CONTRACT_DTLS
  as select from wbhd as contract_org_data
    inner join   wbhk as contract_hdr on contract_hdr.tkonn = contract_org_data.tkonn
    inner join   wbgt as wbgt         on(
              wbgt.tkonn     = contract_hdr.tkonn
              and wbgt.tposn is not initial
            )

{

  key contract_org_data.tkonn                as contract,
  key contract_org_data.tposn                as contract_itm,
      contract_org_data.tposn_sub            as contract_subitem,
      contract_org_data.ekorg                as purch_org,
      contract_org_data.ekgrp                as purch_grp,
      case when contract_hdr.sdwrs is not initial
      then contract_hdr.sdwrs
      else contract_org_data.waers_purch end as contract_curr,
      contract_hdr.tctyp                     as contract_type,
      contract_hdr.vkorg                     as sales_org,
      contract_hdr.vtweg                     as dist_chnl,
      contract_hdr.spart                     as division,
      contract_hdr.company_code,
      contract_hdr.btbsta                    as contract_status,
      wbgt.doc_type                          as contract_doc_type,
      wbgt.side                              as wbgt_side
}
/* where
  (
       contract_hdr.tctyp = 'AC3P'
    or contract_hdr.tctyp = 'AC3S'
    or contract_hdr.tctyp = 'ACIP'
    or contract_hdr.tctyp = 'ACIS'
    or contract_hdr.tctyp = 'ACRP'
    or contract_hdr.tctyp = 'ACRS'
    or contract_hdr.tctyp = 'ASTO'
  ) */

Learn More