I_PrepaymentContractHeader

DDL: I_PREPAYMENTCONTRACTHEADER SQL: IPPMGCTRHDR Type: view BASIC

Prepayment Contract Header Information

I_PrepaymentContractHeader is a Basic CDS View that provides data about "Prepayment Contract Header Information" in SAP S/4HANA. It reads from 2 data sources (I_PrepaymentAssignedDocument, I_PreAgrmtTradingContract) and exposes 6 fields with key field PrepaymentAgrmtRefDocument.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_PrepaymentAssignedDocument I_PrepaymentAssignedDocument from
I_PreAgrmtTradingContract TradingContract inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGCTRHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Prepayment Contract Header Information view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtRefDocument PrepaymentAssdoc PrepaymentAgrmtRefDocument
PrepaymentAssignedDocumentUUID PrepaymentAssdoc PrepaymentAssignedDocumentUUID
PrepaymentAgrmtRefDocumentType I_PreAgrmtTradingContract TradingContractType
Counterparty I_PreAgrmtTradingContract Counterparty
CompanyCode I_PreAgrmtTradingContract CompanyCode
TrdgContrApplicationStatus I_PreAgrmtTradingContract TrdgContrApplicationStatus 
@AbapCatalog.sqlViewName: 'IPPMGCTRHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm             : #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory   : #L
@ObjectModel.usageType.dataClass      : #TRANSACTIONAL
@EndUserText.label: 'Prepayment Contract Header Information'
define view I_PrepaymentContractHeader
  as select from I_PrepaymentAssignedDocument PrepaymentAssdoc
     inner join I_PreAgrmtTradingContract as TradingContract on TradingContract.TradingContract = lpad(ltrim(PrepaymentAssdoc.PrepaymentAgrmtRefDocument,'0'),10,'0')
{
  key PrepaymentAssdoc.PrepaymentAgrmtRefDocument as PrepaymentAgrmtRefDocument,
      PrepaymentAssdoc.PrepaymentAssignedDocumentUUID as PrepaymentAssignedDocumentUUID,
      TradingContract.TradingContractType                                      as PrepaymentAgrmtRefDocumentType,
      TradingContract.Counterparty,
      TradingContract.CompanyCode,
      TradingContract.TrdgContrApplicationStatus
}

Learn More