A_SlsOrdPaymentPlanItemDetails
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)
| Source | Alias | Join Type |
|---|---|---|
| I_SlsDocPaymentPlanItemDetails | PaymentPlanItemDetails | from |
| I_SalesDocumentBasic | SalesOrder | inner |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_SalesOrder | _SalesOrder | _SalesOrder.SalesOrder = $projection.SalesOrder |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA