C_SalesPlanWithDraft

DDL: C_SALESPLANWITHDRAFT SQL: CSDSPWDRAFT Type: view CONSUMPTION Package: VDM_SD_SP
50 Fields 1 Data Sources 1 Associations

Sales Plan With Draft

C_SalesPlanWithDraft is a Consumption CDS View that provides data about "Sales Plan With Draft" in SAP S/4HANA. It reads from 1 data source (I_SalesPlanItemWithDraft) and exposes 50 fields with key field SalesPlanItemUUID. It has 1 association to related views. Part of development package VDM_SD_SP.

Data Sources (1)

SourceAliasJoin Type
I_SalesPlanItemWithDraft _SalesPlanItemWithDraft from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_SalesPlanItem _Extension $projection.SalesPlanItemUUID = _Extension.SalesPlanItemUUID

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName CSDSPWDRAFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Plan With Draft view
VDM.viewType #CONSUMPTION view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SalesPlanItemUUID SalesPlanItemUUID SP Item UUID
SalesPlanUUID SalesPlanUUID Sales Plan UUID
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesDistrict SalesDistrict Sales District
CustomerGroup CustomerGroup Customer Group
Customer Customer Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
Division Division Internal Division ID
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
AdditionalMaterialGroup1 AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 AdditionalMaterialGroup5 MaterialGroup 5
SalesEmployee SalesEmployee Sales Employee
Plant Plant Valuation Area
ShippingType ShippingType Shipping Type
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
BusinessArea BusinessArea Business Area
Country Country Venue: Ctry/Reg
BillToPartyCountry BillToPartyCountry Dst.CtryRg.Ord.
Region Region Venue Region
BillToPartyRegion BillToPartyRegion Region Order
SalesPlanPeriodText SalesPlanPeriodText
SalesPlanAmount Sales Plan amount
SalesPlanCurrency SalesPlanCurrency Currency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CustomerGroup _CustomerGroup
_Customer _Customer
_MaterialGroup _MaterialGroup
_Material _Material
_SalesEmployee_2 _SalesEmployee_2
_SalesPlanCurrency _SalesPlanCurrency

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 C_SalesPlanWithDraft.
-- 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.
-- SQL view name: CSDSPWDRAFT

CREATE VIEW C_SalesPlanWithDraft AS
SELECT
  SalesPlanItemUUID,
  SalesPlanUUID,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  CustomerGroup,
  Customer,
  ShipToParty,
  BillToParty,
  PayerParty,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  Division,
  MaterialGroup,
  Material,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  SalesEmployee,
  Plant,
  ShippingType,
  ProfitCenter,
  CostCenter,
  CompanyCode,
  ControllingArea,
  BusinessArea,
  Country,
  BillToPartyCountry,
  Region,
  BillToPartyRegion,
  SalesPlanPeriodText,
  cast(SalesPlanAmount as sp_amount_in_dc) AS SalesPlanAmount,
  SalesPlanCurrency
FROM I_SalesPlanItemWithDraft AS _SalesPlanItemWithDraft
LEFT OUTER JOIN E_SalesPlanItem AS _Extension ON SalesPlanItemUUID = _Extension.SalesPlanItemUUID  -- association [1..1]
;

Learn More