R_PURCHASEORDERINVOICINGPLAN

CDS View

Invoicing Plan for Purchase Orders

R_PURCHASEORDERINVOICINGPLAN is a CDS View in S/4HANA. Invoicing Plan for Purchase Orders. It contains 7 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 7 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_POInvoicingPlanItem view_entity inner BASIC Purchase Order Invoicing Plan Item
R_PurchaseOrderInvoicingPlanTP view_entity from TRANSACTIONAL Purchase Order Invoicing Plan

Fields (7)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
_PurchaseOrder _PurchaseOrder 1
Plant Plant 1
PurchaseOrderType PurchaseOrderType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1 
@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