R_PurchaseOrderInvoicingPlan

DDL: R_PURCHASEORDERINVOICINGPLAN Type: view_entity BASIC

Invoicing Plan for Purchase Orders

R_PurchaseOrderInvoicingPlan is a Basic CDS View that provides data about "Invoicing Plan for Purchase Orders" in SAP S/4HANA. It reads from 2 data sources (P_BillingPlan, R_PurchaseOrderItem) and exposes 14 fields with key fields PurchaseOrder, PurchaseOrderItem, InvoicingPlan.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
P_BillingPlan P_BillingPlan from
R_PurchaseOrderItem R_PurchaseOrderItem inner

Annotations (8)

NameValueLevelField
EndUserText.label Invoicing Plan for Purchase Orders view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderItem PurchaseOrder
KEY PurchaseOrderItem R_PurchaseOrderItem PurchaseOrderItem
KEY InvoicingPlan P_BillingPlan BillingPlan
InvoicingPlanType P_BillingPlan BillingPlanType
InvoicingPlanStartDate P_BillingPlan BillingPlanStartDate
InvoicingPlanEndDate P_BillingPlan BillingPlanEndDate
InvoicingPlanNextInvcDateRule P_BillingPlan BillingPlanNextBillingDateRule
PurchasingOrganization R_PurchaseOrderItem PurchasingOrganization
PurchasingGroup R_PurchaseOrderItem PurchasingGroup
PurchaseOrderType R_PurchaseOrderItem PurchaseOrderType
PurchasingDocumentDeletionCode R_PurchaseOrderItem PurchasingDocumentDeletionCode
Plant R_PurchaseOrderItem Plant
_BillingPlanType P_BillingPlan _BillingPlanType
_PurchaseOrder R_PurchaseOrderItem _PurchaseOrder 
@EndUserText.label: 'Invoicing Plan for Purchase Orders'
@VDM.viewType: #BASIC 
@AccessControl.authorizationCheck: #MANDATORY 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL 
@ObjectModel.usageType.serviceQuality: #B 
@ObjectModel.usageType.sizeCategory: #M 
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED 
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API 

define view entity R_PurchaseOrderInvoicingPlan
  as select from P_BillingPlan
    inner join R_PurchaseOrderItem on P_BillingPlan.BillingPlan = R_PurchaseOrderItem.InvoicingPlan 

{

  key R_PurchaseOrderItem.PurchaseOrder,
  key R_PurchaseOrderItem.PurchaseOrderItem,
  key P_BillingPlan.BillingPlan                              as InvoicingPlan,
      P_BillingPlan.BillingPlanType                          as InvoicingPlanType,
      P_BillingPlan.BillingPlanStartDate                     as InvoicingPlanStartDate,
      P_BillingPlan.BillingPlanEndDate                       as InvoicingPlanEndDate,
      P_BillingPlan.BillingPlanNextBillingDateRule           as InvoicingPlanNextInvcDateRule, // perio

      
      /* used for authority check */
      R_PurchaseOrderItem.PurchasingOrganization,
      R_PurchaseOrderItem.PurchasingGroup,
      R_PurchaseOrderItem.PurchaseOrderType,
      R_PurchaseOrderItem.PurchasingDocumentDeletionCode,
      R_PurchaseOrderItem.Plant, 
      P_BillingPlan._BillingPlanType,
  
      /* Associations */
      R_PurchaseOrderItem._PurchaseOrder

}
where
  P_BillingPlan.BillingPlanCategory = 'B' and R_PurchaseOrderItem.PurchasingDocumentDeletionCode <> 'L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BILLINGPLAN",
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_BILLINGPLANTYPE",
"R_PURCHASEORDER"
],
"BASE":
[
"P_BILLINGPLAN",
"R_PURCHASEORDERITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More