Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_BPMasterProject instead. View all deprecated CDS views →

I_BillingPlanSDData

DDL: I_BILLINGPLANSDDATA SQL: IBPSD Type: view BASIC
16 Fields 1 Data Sources

Billing Plan SD Data

I_BillingPlanSDData is a Basic CDS View that provides data about "Billing Plan SD Data" in SAP S/4HANA. It reads from 1 data source (P_Bpsddata) and exposes 16 fields.

Data Sources (1)

SourceAliasJoin Type
P_Bpsddata billingplan from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBPSD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Plan SD Data view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_BPMasterProject view

Fields (16)

KeyFieldSource TableSource FieldDescription
BillingPlan P_Bpsddata fplnr Invoicing plan
BillingPlanItem P_Bpsddata fpltr Item
SalesDocument P_Bpsddata vbeln SD Sched. Agmt
SalesDocumentItem P_Bpsddata posnr WBS Element
EventType P_Bpsddata source ViolationSource
BillingDate P_Bpsddata afdat Conf.req.date
BillingBlockReason P_Bpsddata faksp Billing block
BillingPlanRule P_Bpsddata fareg Billing Rule
SDDocumentStatus P_Bpsddata fksaf Billing status
IsBillingCreatedInAdvance P_Bpsddata autte In Advance
BillingPlanType P_Bpsddata fpart Commitment Item Type
BillingPlanCategory P_Bpsddata fpttp Object type
NetAmount P_Bpsddata fakwr Billing Value
TransactionCurrency P_Bpsddata waers Transaction Currency
UsageCode P_Bpsddata mlbez Usage
BillingPlanBillingDateRule P_Bpsddata tetxt Date Descript.

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_BillingPlanSDData.
-- 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.
-- SQL view name: IBPSD

CREATE VIEW I_BillingPlanSDData AS
SELECT
  billingplan.fplnr AS BillingPlan,
  billingplan.fpltr AS BillingPlanItem,
  billingplan.vbeln AS SalesDocument,
  billingplan.posnr AS SalesDocumentItem,
  billingplan.source AS EventType,
  billingplan.afdat AS BillingDate,
  billingplan.faksp AS BillingBlockReason,
  billingplan.fareg AS BillingPlanRule,
  billingplan.fksaf AS SDDocumentStatus,
  billingplan.autte AS IsBillingCreatedInAdvance,
  billingplan.fpart AS BillingPlanType,
  billingplan.fpttp AS BillingPlanCategory,
  billingplan.fakwr AS NetAmount,
  billingplan.waers AS TransactionCurrency,
  billingplan.mlbez AS UsageCode,
  billingplan.tetxt AS BillingPlanBillingDateRule
FROM P_Bpsddata AS billingplan
;

Learn More