P_SalesDocumentBusinessData

DDL: P_SALESDOCUMENTBUSINESSDATA SQL: PSDSLSDOCBIZDAT Type: view BASIC

P_SalesDocumentBusinessData is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (vbkd) and exposes 5 fields with key fields SlsDocBusinessData, SlsDocBusinessDataItem.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
vbkd vbkd from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDSLSDOCBIZDAT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SlsDocBusinessData vbkd vbeln
KEY SlsDocBusinessDataItem vbkd posnr
PurchaseOrderByCustomer vbkd bstkd
BillingDocumentDate vbkd fkdat
BillingPlan vbkd fplnr 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSDSLSDOCBIZDAT'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true 
@VDM.private: true

define view P_SalesDocumentBusinessData
  as select from           vbkd
  {
      //Key

      key vbkd.vbeln       as SlsDocBusinessData,
      key vbkd.posnr       as SlsDocBusinessDataItem,
   
      //Sales

      vbkd.bstkd           as  PurchaseOrderByCustomer,

      // Billing

      vbkd.fkdat           as  BillingDocumentDate,
      vbkd.fplnr           as  BillingPlan
 
  }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBKD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More