CIC_SalesDocument

DDL: CIC_SALESDOCUMENT Type: view_entity
21 Fields 2 Data Sources

Sales Document (Industry Cloud Solutions)

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

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 #X view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Sales Document (Industry Cloud Solutions) view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocument SalesDocument SD Document
CreationDate I_SalesDocument CreationDate Time Stamp
CreationTime I_SalesDocument CreationTime Time of Change
TransactionCurrency I_SalesDocument TransactionCurrency Transaction Currency
DistributionChannel I_SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocument OrganizationDivision Org. Division
TotalNetAmount I_SalesDocument TotalNetAmount Total Net Amount
SalesDocumentDate I_SalesDocument SalesDocumentDate Document Date
SDDocumentReason I_SalesDocument SDDocumentReason Order Reason
OverallOrdReltdBillgStatus I_SalesDocument OverallOrdReltdBillgStatus
PaymentMethod I_SalesDocument PaymentMethod Pymt Meth.
CompanyCodeCountry
PricingDate I_SalesDocument PricingDate Pricing Date
OverallSDProcessStatus I_SalesDocument OverallSDProcessStatus
RequestedDeliveryDate I_SalesDocument RequestedDeliveryDate Requested Delivery Date
SalesOrganization I_SalesDocument SalesOrganization Sales Organization
SalesDocumentType I_SalesDocument SalesDocumentType Sales Doc. Type
AlternativePricingDate I_SalesDocument AlternativePricingDate
OverallTotalDeliveryStatus I_SalesDocument OverallTotalDeliveryStatus
ExchangeRate I_SalesDocument PriceDetnExchangeRate Exchange Rate
CompanyCodeCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CIC_SalesDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CIC_SalesDocument AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  SalesDocument.CreationDate AS CreationDate,
  SalesDocument.CreationTime AS CreationTime,
  SalesDocument.TransactionCurrency AS TransactionCurrency,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.TotalNetAmount AS TotalNetAmount,
  SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SalesDocument.SDDocumentReason AS SDDocumentReason,
  SalesDocument.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  SalesDocument.PaymentMethod AS PaymentMethod,
  SalesDocument._BillingCompanyCode.Country AS CompanyCodeCountry,
  SalesDocument.PricingDate AS PricingDate,
  SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.AlternativePricingDate AS AlternativePricingDate,
  SalesDocument.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  SalesDocument.PriceDetnExchangeRate AS ExchangeRate,
  SalesDocument._BillingCompanyCode.Currency AS CompanyCodeCurrency
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN CIC_SALESDOCUMENTSBLOCKEDBP AS BlockedSalesDocument ON /* join condition not captured in parsed metadata */
;

Learn More