I_RFM_SlsContrDocFlowWthSign

DDL: I_RFM_SLSCONTRDOCFLOWWTHSIGN SQL: ISCDFWS Type: view COMPOSITE

Sale Contract signed Qty

I_RFM_SlsContrDocFlowWthSign is a Composite CDS View that provides data about "Sale Contract signed Qty" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentMultiLevelProcFlow) and exposes 10 fields with key fields DocRelationshipUUID, SalesDocument, SalesDocumentItem. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentMultiLevelProcFlow docflow from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISCDFWS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sale Contract signed Qty view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DocRelationshipUUID I_SDDocumentMultiLevelProcFlow DocRelationshipUUID
KEY SalesDocument I_SDDocumentMultiLevelProcFlow PrecedingDocument
KEY SalesDocumentItem I_SDDocumentMultiLevelProcFlow PrecedingDocumentItem
SDDocumentCategory I_SDDocumentMultiLevelProcFlow PrecedingDocumentCategory
SDFulfillmentCalculationRule I_SDDocumentMultiLevelProcFlow SDFulfillmentCalculationRule
QuantityInBaseUnit I_SDDocumentMultiLevelProcFlow QuantityInBaseUnit
quan153asQuantityInBaseUnitWithSign
BaseUnit I_SDDocumentMultiLevelProcFlow BaseUnit
_SalesDocument _SalesDocument
_BaseUnit _BaseUnit 
@AbapCatalog.sqlViewName: 'ISCDFWS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sale Contract signed Qty'
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XL
   }
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_RFM_SlsContrDocFlowWthSign
  as select from I_SDDocumentMultiLevelProcFlow as docflow
  association [1..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument                                                                 
{
  key docflow.DocRelationshipUUID             as  DocRelationshipUUID,
  key docflow.PrecedingDocument               as  SalesDocument,
  key docflow.PrecedingDocumentItem           as  SalesDocumentItem,

      docflow.PrecedingDocumentCategory       as  SDDocumentCategory,
      docflow.SDFulfillmentCalculationRule,
      docflow.QuantityInBaseUnit,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast ((
      case docflow.SDFulfillmentCalculationRule
           when '-' then  ( QuantityInBaseUnit * -1 )
              else        ( QuantityInBaseUnit  )
                                          end  
            ) as abap.quan(15,3) )    as QuantityInBaseUnitWithSign,

      docflow.BaseUnit                        as BaseUnit,
      
      _SalesDocument,
      _BaseUnit
}
where
       docflow.PrecedingDocumentItem        is not initial
  and  docflow.PrecedingDocumentCategory    = 'G'
  and(
       docflow.SDFulfillmentCalculationRule = '-'
    or docflow.SDFulfillmentCalculationRule = '+'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTMULTILEVELPROCFLOW"
],
"ASSOCIATED":
[
"I_SALESDOCUMENT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_SDDOCUMENTMULTILEVELPROCFLOW"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More