P_CADocumentPaytInfoPaymentLot

DDL: P_CADOCUMENTPAYTINFOPAYMENTLOT Type: view_entity COMPOSITE

Payment Info for Payment Lot

P_CADocumentPaytInfoPaymentLot is a Composite CDS View that provides data about "Payment Info for Payment Lot" in SAP S/4HANA. It reads from 1 data source (I_CAPaymentLotItem) and exposes 14 fields with key fields CADocumentNumber, CAPaymentLot, CAPaymentLotItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CAPaymentLotItem I_CAPaymentLotItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CABankClearingAccount _BkClrgAcct $projection.CompanyCode = _BkClrgAcct.CompanyCode and $projection.CABankClearingAccount = _BkClrgAcct.CABankClearingAccount

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Payment Info for Payment Lot view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CAPaymentLot CAPaymentLot
KEY CAPaymentLotItem CAPaymentLotItem
CompanyCode CompanyCode
CABankClearingAccount CABankClearingAccount
BankNumber BankNumber
BankAccount BankAccount
BankCountry BankCountry
BankDetailReference BankDetailReference
HouseBank _BkClrgAcct HouseBank
HouseBankAccount _BkClrgAcct HouseBankAccount
CABankAccountHolderName CABankAccountHolderName
CANoteToPayeeInPayment CANoteToPayeeInPayment
_BkClrgAcct _BkClrgAcct
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Payment Info for Payment Lot'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #P,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CADocumentPaytInfoPaymentLot
  as select from I_CAPaymentLotItem
  association [1..1] to I_CABankClearingAccount as _BkClrgAcct on  $projection.CompanyCode           = _BkClrgAcct.CompanyCode
                                                               and $projection.CABankClearingAccount = _BkClrgAcct.CABankClearingAccount
{
  key CADocumentNumber,
  key CAPaymentLot,
  key CAPaymentLotItem,
      CompanyCode,
      CABankClearingAccount,

      //Bank Data

      BankNumber,
      BankAccount,
      BankCountry,
      BankDetailReference,
      _BkClrgAcct.HouseBank,
      _BkClrgAcct.HouseBankAccount,

      //Sold-To Party

      CABankAccountHolderName,
      CANoteToPayeeInPayment,



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