I_SlsDocItemBillingPlan

DDL: I_SLSDOCITEMBILLINGPLAN Type: view BASIC Package: VDM_SD_BIL_IV_BP
15 Fields 1 Data Sources 1 Associations

SD New Billing Plan Header

I_SlsDocItemBillingPlan is a Basic CDS View that provides data about "SD New Billing Plan Header" in SAP S/4HANA. It reads from 1 data source (I_SDBillingPlan) and exposes 15 fields with key field BillingPlan. It has 1 association to related views. Part of development package VDM_SD_BIL_IV_BP.

Data Sources (1)

SourceAliasJoin Type
I_SDBillingPlan I_SDBillingPlan from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SalesDocItemBillingPlanItem _SlsDocItemBillingPlanDueDate $projection.BillingPlan = _SlsDocItemBillingPlanDueDate.BillingPlan

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SD New Billing Plan Header view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.sqlViewName ISDBILLINGPLAN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey BillingPlan view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillingPlan BillingPlan Bill. Plan No.
BillingPlanCategory BillingPlanCategory
BillingPlanUsageCategory BillingPlanUsageCategory
BillingPlanType BillingPlanType
BillingPlanStartDate BillingPlanStartDate
BillingPlanEndDate BillingPlanEndDate
BillingPlanStartDateRule BillingPlanStartDateRule
BillingPlanEndDateRule BillingPlanEndDateRule
ReferenceBillingPlan ReferenceBillingPlan
_BillingPlanCategory _BillingPlanCategory
_BillingPlanUsageCategory _BillingPlanUsageCategory
_BillingPlanType _BillingPlanType
_SlsDocItemBillingPlanDueDate _SlsDocItemBillingPlanDueDate
_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_SlsDocItemBillingPlan.
-- 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_SlsDocItemBillingPlan AS
SELECT
  BillingPlan,
  BillingPlanCategory,
  BillingPlanUsageCategory,
  BillingPlanType,
  BillingPlanStartDate,
  BillingPlanEndDate,
  BillingPlanStartDateRule,
  BillingPlanEndDateRule,
  ReferenceBillingPlan
FROM I_SDBillingPlan
LEFT OUTER JOIN I_SalesDocItemBillingPlanItem AS _SlsDocItemBillingPlanDueDate ON BillingPlan = _SlsDocItemBillingPlanDueDate.BillingPlan  -- association [1..*]
;

Learn More