RFM_SalesDocumentItemBasic

DDL: RFM_SALESDOCUMENTITEMBASIC Type: view

RFM_SalesDocumentItemBasic is a CDS View in SAP S/4HANA. It reads from 2 data sources (vbak, vbap) and exposes 12 fields.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
vbak _SalesDocument from
vbap _SalesDocumentItem inner

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName RFMSDDOCITEMBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (12)

KeyFieldSource TableSource FieldDescription
SalesDocumentType vbak auart
SalesDocument vbap vbeln
SalesDocumentItem vbap posnr
OverallTotalSDDocRefStatus vbak rfgsk
OverallSDDocReferenceStatus vbak rfstk
TotalSDDocReferenceStatus vbap rfgsa
SDDocReferenceStatus vbap rfsta
SalesOrganization vbak vkorg
DistributionChannel vbak vtweg
Division vbak spart
Material vbap matnr
Plant vbap werks 
@ClientHandling.algorithm: #AUTOMATED
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'RFMSDDOCITEMBSC',
  compiler.compareFilter: true,
  preserveKey:true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
define view RFM_SalesDocumentItemBasic
  as select from vbak as _SalesDocument
    inner join   vbap as _SalesDocumentItem on _SalesDocument.vbeln = _SalesDocumentItem.vbeln
{
  _SalesDocument.auart     as SalesDocumentType,
  _SalesDocumentItem.vbeln as SalesDocument,
  _SalesDocumentItem.posnr as SalesDocumentItem,
  _SalesDocument.rfgsk     as OverallTotalSDDocRefStatus,
  _SalesDocument.rfstk     as OverallSDDocReferenceStatus,
  _SalesDocumentItem.rfgsa as TotalSDDocReferenceStatus,
  _SalesDocumentItem.rfsta as SDDocReferenceStatus,
  _SalesDocument.vkorg     as SalesOrganization,
  _SalesDocument.vtweg     as DistributionChannel,
  _SalesDocument.spart     as Division,
  _SalesDocumentItem.matnr as Material,
  _SalesDocumentItem.werks as Plant

}
where
  _SalesDocument.vbtyp = 'G'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBAK",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More