I_ServiceManagementPaymentPlan

DDL: I_SERVICEMANAGEMENTPAYMENTPLAN Type: view_entity BASIC
11 Fields 1 Data Sources 3 Associations

Service Management Payment Plan

I_ServiceManagementPaymentPlan is a Basic CDS View that provides data about "Service Management Payment Plan" in SAP S/4HANA. It reads from 1 data source (crms4d_payplan_d) and exposes 11 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, SrvcDocDigitalPaymentPlanLine. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
crms4d_payplan_d crms4d_payplan_d from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocument _ServiceDocument $projection.ServiceObjectType = _ServiceDocument.ServiceObjectType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
[0..1] I_Currency _PaymentCurrency $projection.PaymentCurrency = _PaymentCurrency.Currency
[1..1] I_CustMgmtBusObjType _ServiceObjType $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Service Management Payment Plan view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType objtype_h Trans. Cat.
KEY ServiceDocument object_id Transaction ID
KEY ServiceDocumentItem number_int Item Number in Doc.
KEY SrvcDocDigitalPaymentPlanLine line VAT Return Line Item
SrvcDocDigitalPaymentCardToken card_token Token
AuthorizedAmountInAuthznCrcy auth_amount Authorized Amount
PaymentCurrency currency Valuation Crcy
AuthorizationByDigitalPaytSrvc auth_no Authorization Number
ServiceDocumentType _ServiceDocument ServiceDocumentType Transaction Type
_ServiceObjType _ServiceObjType
_PaymentCurrency _PaymentCurrency

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 I_ServiceManagementPaymentPlan.
-- 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 I_ServiceManagementPaymentPlan AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS ServiceDocument,
  number_int AS ServiceDocumentItem,
  line AS SrvcDocDigitalPaymentPlanLine,
  card_token AS SrvcDocDigitalPaymentCardToken,
  auth_amount AS AuthorizedAmountInAuthznCrcy,
  currency AS PaymentCurrency,
  auth_no AS AuthorizationByDigitalPaytSrvc,
  _ServiceDocument.ServiceDocumentType AS ServiceDocumentType
FROM crms4d_payplan_d
LEFT OUTER JOIN I_ServiceDocument AS _ServiceDocument ON ServiceObjectType = _ServiceDocument.ServiceObjectType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtBusObjType AS _ServiceObjType ON ServiceObjectType = _ServiceObjType.BusinessObjectType  -- association [1..1]
;

Learn More