I_CAPAYMENTORDER

CDS View

Zahlungsauftrag

I_CAPAYMENTORDER is a CDS View in S/4HANA. Zahlungsauftrag. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CAPaymentOrderDocumentVH view from COMPOSITE Payment Document of Payment Order
I_CAPaymentOrderVH view from COMPOSITE Zahlungsauftrag
P_CADocumentPaytInfoPaytOrder view_entity from COMPOSITE Payment Info for Payment Orders 
@AbapCatalog.sqlViewName: 'ICAPAYTORDER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Zahlungsauftrag'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
define view I_CAPaymentOrder
  as select from dfkkpoh
  association [1..1] to I_BusinessPartner      as _BusinessPartner      on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_CADocumentHeader     as _DocHeader            on $projection.CAPaymentDocument = _DocHeader.CADocumentNumber
  association [0..1] to I_CAPaymentOrderStatus as _CAPaymentOrderStatus on $projection.CAPaymentOrderStatus = _CAPaymentOrderStatus.CAPaymentOrderStatus
{
  key pyord                                                    as CAPaymentOrder,
      ausfd                                                    as PaidItemDueDate,
      verfd                                                    as CAPaymentOrderExpirationDate,
      staza                                                    as CAPaymentOrderStatus,
      waers                                                    as TransactionCurrency,
      pybel                                                    as CAPaymentDocument,
      rford                                                    as CAPaymentOrderExternalRef,
      nwbtr                                                    as CANetAmountInTransCurrency,
      valut                                                    as ValueDate,
      
      hbkid                                                    as HouseBank,
      hktid                                                    as HouseBankAccount,
      rzawe                                                    as CAPaymentMethod,
      
      laufd                                                    as CAMassRunDate,
      cast(laufi as char006 )                                  as CAMassRunID,
      

      cast(substring(org1r,1,4) as fis_bukrs preserving type ) as CompanyCode,
      gsber                                                    as BusinessArea,

      case gpa1t
       when '01' then cast(substring(gpa1r,1,10) as bu_partner preserving type )
      //when '01' then cast(cast(substring(gpa1r,1,10) as abap.char(10)) as bu_partner)

       else ''
      end                                                      as BusinessPartner,

      _BusinessPartner,
      _DocHeader,
      _CAPaymentOrderStatus

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

Learn More