What is I_SDBillingPlan in SAP S/4HANA?

I_SDBillingPlan is a basic CDS view in SAP S/4HANA. Billing Plan for SD Documents It contains 18 fields.

Which tables does I_SDBillingPlan read from?

I_SDBillingPlan reads data from: P_BillingPlan.

What VDM layer is I_SDBillingPlan?

I_SDBillingPlan is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SDBillingPlan

DDL: I_SDBILLINGPLAN Type: view_entity BASIC

18 Fields 1 Data Sources 1 Associations

Billing Plan for SD Documents

I_SDBillingPlan (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

SDBillingPlan · Sales

I_SDBillingPlan is a Basic CDS View (Dimension) that provides data about "Billing Plan for SD Documents" in SAP S/4HANA. It reads from 1 data source (P_BillingPlan) and exposes 18 fields with key field BillingPlan. It has 1 association to related views.

SAP Help Documentation

Category	SD Documents and Sales Documents
Data Category	Dimension

Purpose
This CDS view retrieves the information of the header of billing plan in Sales. This CDS view provides the data to answer the following business questions: When does the billing plan start? How is the start date of the billing plan defined? Is the billing plan used for professional services or legacy billing plan? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations This CDS view has the status privileged only. The data contained cannot be accessed directly and is not exposed in an Odata Service. The data can only be accessed via an association in a protected CDS view.

Structure
Further important fields Important fields in this view include the following: Field Name Description BillingPlan Bill. Plan No. BillingPlanUsageCategory Billing Plan Us. Cat BillingPlanType Billing Plan Type BillingPlanStartDate Start date BillingPlanStartDateRule Origin of Start Date ReferenceBillingPlan Bill. Plan No.

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) and delta-enabled with Change Data Capture (CDC) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sales
Application Component	SD-BIL-IV-BP
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction, Data Source in SQL Select
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view retrieves the information of the header of billing plan in Sales.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>When does the billing plan start?</p></li> <li><p>How is the start date of the billing plan defined?</p></li> <li><p>Is the billing plan used for professional services or legacy billing plan?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_BillingPlan	P_BillingPlan	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_SDBillingPlanItem	_SDBillingPlanItem	`_SDBillingPlanItem.BillingPlan = $projection.BillingPlan`

Annotations (17)

Name	Value	Level
EndUserText.label	Billing Plan for SD Documents	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.representativeKey	BillingPlan	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.sapObjectNodeType.name	SDBillingPlan	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.internalName	#LOCAL	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (18)

Key	Field	Source Field	Description
KEY	BillingPlan	BillingPlan	Billing/Invoicing Plan Number
	BillingPlanCategory	BillingPlanCategory	Billing plan category
	BillingPlanUsageCategory	BillingPlanUsageCategory	Billing Plan Usage Category
	BillingPlanType	BillingPlanType	Billing/Invoicing Plan Type
	BillingPlanStartDate	BillingPlanStartDate	Start Date of Billing/Invoicing Plan
	BillingPlanStartDateRule	BillingPlanStartDateRule	Rule for Origin of Start Date of Billing/Invoicing Plan
	BillingPlanEndDate	BillingPlanEndDate	End Date of Billing/Invoicing Plan
	BillingPlanEndDateRule	BillingPlanEndDateRule	Rule for Origin of End Date for Billing/Invoicing Plan
	BillingPlanSearchTerm	BillingPlanSearchTerm	Sort field
	SalesDocument	SalesDocument	Sales and Distribution Document Number
	PaymentLinkIsRequired	PaymentLinkIsRequired	Payment by Link - Generate Payment Link
	ReferenceBillingPlan	ReferenceBillingPlan	Reference Billing Plan Number / Invoicing Plan Number
	_SDBillingPlanItem	_SDBillingPlanItem
	_BillingPlanCategory	_BillingPlanCategory
	_BillingPlanUsageCategory	_BillingPlanUsageCategory
	_BillingPlanType	_BillingPlanType
	_StartDateRule	_StartDateRule
	_EndDateRule	_EndDateRule

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_SDBillingPlan.
-- 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_SDBillingPlan AS
SELECT
  BillingPlan,
  BillingPlanCategory,
  BillingPlanUsageCategory,
  BillingPlanType,
  BillingPlanStartDate,
  BillingPlanStartDateRule,
  BillingPlanEndDate,
  BillingPlanEndDateRule,
  BillingPlanSearchTerm,
  SalesDocument,
  PaymentLinkIsRequired,
  ReferenceBillingPlan
FROM P_BillingPlan
LEFT OUTER JOIN I_SDBillingPlanItem AS _SDBillingPlanItem ON _SDBillingPlanItem.BillingPlan = BillingPlan  -- association [0..*]
;

Depth:

I_SDBillingPlan view_entity

P_BillingPlan view_entity