R_SalesOrderBillingPlanTP

DDL: R_SALESORDERBILLINGPLANTP Type: view_entity TRANSACTIONAL

Billing Plan for Sales Order - TP

R_SalesOrderBillingPlanTP is a Transactional CDS View that provides data about "Billing Plan for Sales Order - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderBillingPlan) and exposes 22 fields with key fields SalesOrder, BillingPlan. It has 1 association to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderBillingPlan SalesOrderBillingPlan from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_SalesOrderBillingPlanItemTP _BillingPlanItem

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Billing Plan for Sales Order - TP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderBillingPlan SalesOrder
KEY BillingPlan I_SalesOrderBillingPlan BillingPlan
BillingPlanCategory I_SalesOrderBillingPlan BillingPlanCategory
BillingPlanUsageCategory I_SalesOrderBillingPlan BillingPlanUsageCategory
BillingPlanType I_SalesOrderBillingPlan BillingPlanType
BillingPlanStartDate I_SalesOrderBillingPlan BillingPlanStartDate
BillingPlanStartDateRule I_SalesOrderBillingPlan BillingPlanStartDateRule
BillingPlanEndDate I_SalesOrderBillingPlan BillingPlanEndDate
BillingPlanEndDateRule I_SalesOrderBillingPlan BillingPlanEndDateRule
BillingPlanSearchTerm I_SalesOrderBillingPlan BillingPlanSearchTerm
ReferenceBillingPlan I_SalesOrderBillingPlan ReferenceBillingPlan
SalesOrderType I_SalesOrderBillingPlan SalesOrderType
SalesOrganization I_SalesOrderBillingPlan SalesOrganization
DistributionChannel I_SalesOrderBillingPlan DistributionChannel
OrganizationDivision I_SalesOrderBillingPlan OrganizationDivision
_BillingPlanItem _BillingPlanItem
_SalesOrder _SalesOrder
_BillingPlanCategory I_SalesOrderBillingPlan _BillingPlanCategory
_BillingPlanUsageCategory I_SalesOrderBillingPlan _BillingPlanUsageCategory
_BillingPlanType I_SalesOrderBillingPlan _BillingPlanType
_StartDateRule I_SalesOrderBillingPlan _StartDateRule
_EndDateRule I_SalesOrderBillingPlan _EndDateRule 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory: #L
    }
}

@ObjectModel.semanticKey: ['SalesOrder', 'BillingPlan']

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Billing Plan for Sales Order - TP'
define view entity R_SalesOrderBillingPlanTP 
  as select from I_SalesOrderBillingPlan as SalesOrderBillingPlan

  composition [0..*] of R_SalesOrderBillingPlanItemTP as _BillingPlanItem
  
  association to parent R_SalesOrderTP                as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
      
{

  key   SalesOrderBillingPlan.SalesOrder,

  key   SalesOrderBillingPlan.BillingPlan,

        @ObjectModel.foreignKey.association: '_BillingPlanCategory'
        SalesOrderBillingPlan.BillingPlanCategory,

        @ObjectModel.foreignKey.association: '_BillingPlanUsageCategory'
        SalesOrderBillingPlan.BillingPlanUsageCategory,

        @ObjectModel.foreignKey.association: '_BillingPlanType'
        SalesOrderBillingPlan.BillingPlanType,

        SalesOrderBillingPlan.BillingPlanStartDate,

        @ObjectModel.foreignKey.association: '_StartDateRule'
        SalesOrderBillingPlan.BillingPlanStartDateRule,

        SalesOrderBillingPlan.BillingPlanEndDate,

        @ObjectModel.foreignKey.association: '_EndDateRule'
        SalesOrderBillingPlan.BillingPlanEndDateRule,

        SalesOrderBillingPlan.BillingPlanSearchTerm,
        
        SalesOrderBillingPlan.ReferenceBillingPlan,

        /* For Access control */
        @Consumption.hidden: true
        SalesOrderBillingPlan.SalesOrderType,
        @Consumption.hidden: true
        SalesOrderBillingPlan.SalesOrganization,
        @Consumption.hidden: true
        SalesOrderBillingPlan.DistributionChannel,
        @Consumption.hidden: true
        SalesOrderBillingPlan.OrganizationDivision,
        
        /* Composition */
        _BillingPlanItem,
        
        /* Association to parent */
        _SalesOrder, 
        
        /* Further associations */     
        SalesOrderBillingPlan._BillingPlanCategory,
        SalesOrderBillingPlan._BillingPlanUsageCategory,
        SalesOrderBillingPlan._BillingPlanType,
        SalesOrderBillingPlan._StartDateRule,
        SalesOrderBillingPlan._EndDateRule  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDERBILLINGPLAN"
],
"ASSOCIATED":
[
"I_BILLGPLNUSGECAT_2",
"I_BILLINGPLANCATEGORY",
"I_BILLINGPLANTYPE",
"I_INDIRECTDATEDETERMINERULE",
"R_SALESORDERBILLINGPLANITEMTP",
"R_SALESORDERTP"
],
"BASE":
[
"I_SALESORDERBILLINGPLAN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More