C_SalesPlanItemTP

DDL: C_SALESPLANITEMTP SQL: CSDSLSPLANITMTP Type: view CONSUMPTION Package: VDM_SD_SP
46 Fields 1 Data Sources 1 Associations

Sales Plan Item

C_SalesPlanItemTP is a Consumption CDS View that provides data about "Sales Plan Item" in SAP S/4HANA. It reads from 1 data source (I_SalesPlanItemTP) and exposes 46 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_SalesPlanItemTP I_SalesPlanItemTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_SalesPlanTP _SalesPlan $projection.SalesPlanUUID = _SalesPlan.SalesPlanUUID

Annotations (15)

NameValueLevelField
EndUserText.label Sales Plan Item view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName CSDSLSPLANITMTP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
UI.headerInfo.typeName Plan Data view
UI.headerInfo.typeNamePlural Plan Data view

Fields (46)

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
Customer Customer Sold-to Party
CustomerGroup CustomerGroup Customer Group
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
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
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
SalesPlanPeriod SalesPlanPeriod Sales Plan period
SalesPlanAmount SalesPlanAmount Sales Plan amount
SalesPlanCurrency SalesPlanCurrency Currency
SalesPlanQuantity SalesPlanQuantity Planned Qty
SalesPlanUnit SalesPlanUnit Unit of Measure
_SalesPlan _SalesPlan
_SalesPlanCurrency _SalesPlanCurrency
_SalesPlanUnit _SalesPlanUnit

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_SalesPlanItemTP.
-- 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: CSDSLSPLANITMTP

CREATE VIEW C_SalesPlanItemTP AS
SELECT
  SalesPlanItemUUID,
  SalesPlanUUID,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  Customer,
  CustomerGroup,
  ShipToParty,
  BillToParty,
  PayerParty,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  Division,
  Material,
  MaterialGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  SalesEmployee,
  Plant,
  ShippingType,
  ProfitCenter,
  CostCenter,
  CompanyCode,
  ControllingArea,
  BusinessArea,
  Country,
  BillToPartyCountry,
  Region,
  BillToPartyRegion,
  SalesPlanPeriod,
  SalesPlanAmount,
  SalesPlanCurrency,
  SalesPlanQuantity,
  SalesPlanUnit
FROM I_SalesPlanItemTP
LEFT OUTER JOIN C_SalesPlanTP AS _SalesPlan ON SalesPlanUUID = _SalesPlan.SalesPlanUUID  -- association [1..1]
;

Learn More