A_SlsOrdPaymentPlanItemDetails

DDL: A_SLSORDPAYMENTPLANITEMDETAILS Type: view COMPOSITE Package: ODATA_SD_SALESORDER_API
35 Fields 2 Data Sources 1 Associations

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. Part of development package ODATA_SD_SALESORDER_API.

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 Item
PaymentPlan I_SlsDocPaymentPlanItemDetails PaymentPlan Paym.Ca.Pl.No.
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 Payt Srvc Provider
PaymentByPaymentServicePrvdr PaymentByPaymentServicePrvdr
TransactionByPaytSrvcPrvdr TransactionByPaytSrvcPrvdr
MerchantByClearingHouse MerchantByClearingHouse
PaymentCardAuthznRelationID PaymentCardAuthznRelationID
MaximumToBeAuthorizedAmount MaximumToBeAuthorizedAmount
PaytPlnForAuthorizationItem PaytPlnForAuthorizationItem
PaytPlnItmForAuthorizationItem PaytPlnItmForAuthorizationItem
SalesOrderType I_SalesDocumentBasic SalesDocumentType Sales Doc. Type
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
_SalesOrder _SalesOrder

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_SlsOrdPaymentPlanItemDetails.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_SlsOrdPaymentPlanItemDetails AS
SELECT
  cast(PaymentPlanItemDetails.SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  PaymentPlanItem,
  PaymentPlanItemDetails.PaymentPlan AS PaymentPlan,
  ElectronicPaymentType,
  ElectronicPayment,
  EPaytValidityStartDate,
  EPaytValidityEndDate,
  ElectronicPaymentHolderName,
  AuthorizedAmountInAuthznCrcy,
  AuthorizationCurrency,
  AuthorizationByDigitalPaytSrvc,
  AuthorizationByAcquirer,
  AuthorizationDate,
  AuthorizationTime,
  AuthorizationStatusName,
  EPaytByDigitalPaymentSrvc,
  ElectronicPaymentCallStatus,
  EPaytAuthorizationResult,
  EPaytToBeAuthorizedAmount,
  EPaytAuthorizationIsExpired,
  EPaytAmountIsChanged,
  PreauthorizationIsRequested,
  PaymentServiceProvider,
  PaymentByPaymentServicePrvdr,
  TransactionByPaytSrvcPrvdr,
  MerchantByClearingHouse,
  PaymentCardAuthznRelationID,
  MaximumToBeAuthorizedAmount,
  PaytPlnForAuthorizationItem,
  PaytPlnItmForAuthorizationItem,
  SalesOrder.SalesDocumentType AS SalesOrderType,
  SalesOrder.SalesOrganization AS SalesOrganization,
  SalesOrder.DistributionChannel AS DistributionChannel,
  SalesOrder.OrganizationDivision AS OrganizationDivision
FROM I_SlsDocPaymentPlanItemDetails AS PaymentPlanItemDetails
INNER JOIN I_SalesDocumentBasic AS SalesOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_SalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [1..1]
;

Learn More