P_ACMContractHeaderOvw

DDL: P_ACMCONTRACTHEADEROVW SQL: PACMCTRHDROVW Type: view BASIC

Contract Header Approve Trading Contract

P_ACMContractHeaderOvw is a Basic CDS View that provides data about "Contract Header Approve Trading Contract" in SAP S/4HANA. It reads from 1 data source (wbhk) and exposes 17 fields with key field TradingContractNumber.

Data Sources (1)

SourceAliasJoin Type
wbhk Header from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PACMCTRHDROVW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 #L view
EndUserText.label Contract Header Approve Trading Contract view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber wbhk tkonn
TradingContractType wbhk tctyp
Counterparty wbhk kunnr
ContractStatus wbhk btbsta
TradingContractCreatedBy wbhk ernam
TradingContrCreatedOnDate wbhk erdat
TradingContractChangedBy wbhk aenam
TradingContractChangedOnDate wbhk aedat
SalesOrganization wbhk vkorg
DistributionChannel wbhk vtweg
Division wbhk spart
PersonResponsible wbhk tksachb
ACMTransactingCustomerRef wbhk bstnk
DocumentDate wbhk budat
TradingContractExternalID wbhk tkonn_ex
CompanyCode wbhk company_code
ACMTradingContractCurrency wbhk sdwrs
@AbapCatalog.sqlViewName: 'PACMCTRHDROVW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Contract Header Approve Trading Contract'
define view P_ACMContractHeaderOvw
  as select from wbhk as Header
{
  key Header.tkonn        as TradingContractNumber,
      Header.tctyp        as TradingContractType,
      Header.kunnr        as Counterparty,
      Header.btbsta       as ContractStatus,
      Header.ernam        as TradingContractCreatedBy,
      Header.erdat        as TradingContrCreatedOnDate,
      Header.aenam        as TradingContractChangedBy,
      Header.aedat        as TradingContractChangedOnDate,
      Header.vkorg        as SalesOrganization,
      Header.vtweg        as DistributionChannel,
      Header.spart        as Division,
      Header.tksachb      as PersonResponsible,
      Header.bstnk        as ACMTransactingCustomerRef,
      Header.budat        as DocumentDate,
      Header.tkonn_ex     as TradingContractExternalID,
      Header.company_code as CompanyCode,
      Header.sdwrs        as ACMTradingContractCurrency

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBHK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/