A_SlsOrdPaymentPlanItemDetails

DDL: A_SLSORDPAYMENTPLANITEMDETAILS Type: view COMPOSITE

Header Payment Plan

A_SlsOrdPaymentPlanItemDetails is a Composite CDS View that provides data about "Header Payment Plan" in SAP S/4HANA. It reads from 2 data sources (I_SlsDocPaymentPlanItemDetails, I_SalesDocumentBasic) and exposes 35 fields with key fields SalesOrder, PaymentPlanItem. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SlsDocPaymentPlanItemDetails PaymentPlanItemDetails from
I_SalesDocumentBasic SalesOrder inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_SalesOrder _SalesOrder _SalesOrder.SalesOrder = $projection.SalesOrder

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASOPAYTPLANITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Header Payment Plan view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY PaymentPlanItem PaymentPlanItem
PaymentPlan I_SlsDocPaymentPlanItemDetails PaymentPlan
ElectronicPaymentType ElectronicPaymentType
ElectronicPayment ElectronicPayment
EPaytValidityStartDate EPaytValidityStartDate
EPaytValidityEndDate EPaytValidityEndDate
ElectronicPaymentHolderName ElectronicPaymentHolderName
AuthorizedAmountInAuthznCrcy AuthorizedAmountInAuthznCrcy
AuthorizationCurrency AuthorizationCurrency
AuthorizationByDigitalPaytSrvc AuthorizationByDigitalPaytSrvc
AuthorizationByAcquirer AuthorizationByAcquirer
AuthorizationDate AuthorizationDate
AuthorizationTime AuthorizationTime
AuthorizationStatusName AuthorizationStatusName
EPaytByDigitalPaymentSrvc EPaytByDigitalPaymentSrvc
ElectronicPaymentCallStatus ElectronicPaymentCallStatus
EPaytAuthorizationResult EPaytAuthorizationResult
EPaytToBeAuthorizedAmount EPaytToBeAuthorizedAmount
EPaytAuthorizationIsExpired EPaytAuthorizationIsExpired
EPaytAmountIsChanged EPaytAmountIsChanged
PreauthorizationIsRequested PreauthorizationIsRequested
PaymentServiceProvider PaymentServiceProvider
PaymentByPaymentServicePrvdr PaymentByPaymentServicePrvdr
TransactionByPaytSrvcPrvdr TransactionByPaytSrvcPrvdr
MerchantByClearingHouse MerchantByClearingHouse
PaymentCardAuthznRelationID PaymentCardAuthznRelationID
MaximumToBeAuthorizedAmount MaximumToBeAuthorizedAmount
PaytPlnForAuthorizationItem PaytPlnForAuthorizationItem
PaytPlnItmForAuthorizationItem PaytPlnItmForAuthorizationItem
SalesOrderType I_SalesDocumentBasic SalesDocumentType
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
OrganizationDivision I_SalesDocumentBasic OrganizationDivision
_SalesOrder _SalesOrder
@ClientHandling.algorithm:#SESSION_VARIABLE

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASOPAYTPLANITEM',
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #M
   }
}
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Header Payment Plan'
define view A_SlsOrdPaymentPlanItemDetails
  as select from I_SlsDocPaymentPlanItemDetails as PaymentPlanItemDetails
    inner join   I_SalesDocumentBasic as SalesOrder on  SalesOrder.PaymentPlan      = PaymentPlanItemDetails.PaymentPlan
                                                    and SalesOrder.SDDocumentCategory = 'C'
                                                    
  association [1..1] to A_SalesOrder as _SalesOrder on _SalesOrder.SalesOrder = $projection.SalesOrder

{
      @ObjectModel.readOnly: true
  key cast(PaymentPlanItemDetails.SalesDocument as vdm_sales_order preserving type)    as SalesOrder,

  key PaymentPlanItem,
      @ObjectModel.readOnly: true
      PaymentPlanItemDetails.PaymentPlan,
      
      ElectronicPaymentType,
      ElectronicPayment,
      EPaytValidityStartDate,
      EPaytValidityEndDate,
      ElectronicPaymentHolderName,
      @Semantics.amount.currencyCode: 'AuthorizationCurrency'
      AuthorizedAmountInAuthznCrcy,
      @ObjectModel.readOnly: true
      @Semantics.currencyCode: true 
      AuthorizationCurrency,
      
      AuthorizationByDigitalPaytSrvc,
      @ObjectModel.readOnly: true
      AuthorizationByAcquirer,
      @ObjectModel.readOnly: true
      AuthorizationDate,
      @ObjectModel.readOnly: true
      AuthorizationTime,
      @ObjectModel.readOnly: true
      AuthorizationStatusName,
      
      EPaytByDigitalPaymentSrvc,
      
      @ObjectModel.readOnly: true
      ElectronicPaymentCallStatus,
      @ObjectModel.readOnly: true
      EPaytAuthorizationResult,
      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'AuthorizationCurrency'
      EPaytToBeAuthorizedAmount,
      @ObjectModel.readOnly: true
      EPaytAuthorizationIsExpired,
      @ObjectModel.readOnly: true
      EPaytAmountIsChanged,
      @ObjectModel.readOnly: true
      PreauthorizationIsRequested,
            
      PaymentServiceProvider,
      PaymentByPaymentServicePrvdr,
      TransactionByPaytSrvcPrvdr,
      MerchantByClearingHouse,
      PaymentCardAuthznRelationID,
            
      @Semantics.amount.currencyCode: 'AuthorizationCurrency'
      MaximumToBeAuthorizedAmount,
      @ObjectModel.readOnly: true
      PaytPlnForAuthorizationItem, 
      @ObjectModel.readOnly: true         
      PaytPlnItmForAuthorizationItem,
      
      // For Access control

      @Consumption.hidden: true
      SalesOrder.SalesDocumentType                                                  as SalesOrderType,
      @Consumption.hidden: true
      SalesOrder.SalesOrganization,
      @Consumption.hidden: true
      SalesOrder.DistributionChannel,
      @Consumption.hidden: true
      SalesOrder.OrganizationDivision,
      
      //Expose associations

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