CIC_SalesDocument

DDL: CIC_SALESDOCUMENT Type: view_entity

Projection on Sales Document (Industry Cloud Solutions)

CIC_SalesDocument is a CDS View that provides data about "Projection on Sales Document (Industry Cloud Solutions)" in SAP S/4HANA. It reads from 2 data sources (CIC_SALESDOCUMENTSBLOCKEDBP, I_SalesDocument) and exposes 21 fields.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
CIC_SALESDOCUMENTSBLOCKEDBP BlockedSalesDocument left_outer
I_SalesDocument SalesDocument from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Projection on Sales Document (Industry Cloud Solutions) view

Fields (21)

KeyFieldSource TableSource FieldDescription
SalesDocument I_SalesDocument SalesDocument
CreationDate I_SalesDocument CreationDate
CreationTime I_SalesDocument CreationTime
TransactionCurrency I_SalesDocument TransactionCurrency
DistributionChannel I_SalesDocument DistributionChannel
OrganizationDivision I_SalesDocument OrganizationDivision
TotalNetAmount I_SalesDocument TotalNetAmount
SalesDocumentDate I_SalesDocument SalesDocumentDate
SDDocumentReason I_SalesDocument SDDocumentReason
OverallOrdReltdBillgStatus I_SalesDocument OverallOrdReltdBillgStatus
PaymentMethod I_SalesDocument PaymentMethod
CompanyCodeCountry
PricingDate I_SalesDocument PricingDate
OverallSDProcessStatus I_SalesDocument OverallSDProcessStatus
RequestedDeliveryDate I_SalesDocument RequestedDeliveryDate
SalesOrganization I_SalesDocument SalesOrganization
SalesDocumentType I_SalesDocument SalesDocumentType
AlternativePricingDate I_SalesDocument AlternativePricingDate
OverallTotalDeliveryStatus I_SalesDocument OverallTotalDeliveryStatus
ExchangeRate I_SalesDocument PriceDetnExchangeRate
CompanyCodeCurrency 
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XL
   }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Projection on Sales Document (Industry Cloud Solutions)'
define view entity CIC_SalesDocument
  as select from I_SalesDocument as SalesDocument
    left outer join   CIC_SALESDOCUMENTSBLOCKEDBP  as BlockedSalesDocument on  SalesDocument.SalesDocument = BlockedSalesDocument.SalesDocument
//left outer join I_CompanyCode as CompanyCode on SalesDocument.BillingCompanyCode = CompanyCode.CompanyCode

{
  SalesDocument.SalesDocument,
  SalesDocument.CreationDate,
  SalesDocument.CreationTime,
  SalesDocument.TransactionCurrency,
  SalesDocument.DistributionChannel,
  SalesDocument.OrganizationDivision,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  SalesDocument.TotalNetAmount,
  SalesDocument.SalesDocumentDate,
  SalesDocument.SDDocumentReason,
  SalesDocument.OverallOrdReltdBillgStatus,
  SalesDocument.PaymentMethod,
  SalesDocument._BillingCompanyCode.Country as CompanyCodeCountry,
  SalesDocument.PricingDate,
  SalesDocument.OverallSDProcessStatus,
  SalesDocument.RequestedDeliveryDate,
  SalesDocument.SalesOrganization,
  SalesDocument.SalesDocumentType,
  SalesDocument.AlternativePricingDate, 
  SalesDocument.OverallTotalDeliveryStatus,
  SalesDocument.PriceDetnExchangeRate as ExchangeRate,
  SalesDocument._BillingCompanyCode.Currency as CompanyCodeCurrency
}
where
       dats_add_months(SalesDocument.CreationDate, 24,'INITIAL') >= $session.system_date
  and(
       SalesDocument.SDDocumentCategory                          = 'C'
    or SalesDocument.SDDocumentCategory                          = 'H'
  )
  and BlockedSalesDocument.SalesDocument is null

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CIC_SALESDOCUMENTSBLOCKEDBP",
"I_COMPANYCODE",
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More