What is A_SalesSchedgAgrmt in SAP S/4HANA?

A_SalesSchedgAgrmt is a composite CDS view in SAP S/4HANA. Sales Scheduling Agreement Header It contains 50 fields.

Which tables does A_SalesSchedgAgrmt read from?

A_SalesSchedgAgrmt reads data from: I_SalesSchedgAgrmt.

What VDM layer is A_SalesSchedgAgrmt?

A_SalesSchedgAgrmt is classified as a Composite view that combines data from multiple basic views.

A_SalesSchedgAgrmt

DDL: A_SALESSCHEDGAGRMT Type: view COMPOSITE

50 Fields 1 Data Sources 5 Associations

Sales Scheduling Agreement Header

A_SalesSchedgAgrmt is a Composite CDS View that provides data about "Sales Scheduling Agreement Header" in SAP S/4HANA. It reads from 1 data source (I_SalesSchedgAgrmt) and exposes 50 fields with key field SalesSchedulingAgreement. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SalesSchedgAgrmt	SalesSchedgAgrmt	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..*]	A_SalesSchedgAgrmtPartner	_Partner	`$projection.SalesSchedulingAgreement = _Partner.SalesSchedulingAgreement`
[0..*]	A_SalesSchedgAgrmtText	_Text	`$projection.SalesSchedulingAgreement = _Text.SalesSchedulingAgreement`
[0..*]	A_SalesSchedgAgrmtPrcgElement	_PricingElement	`$projection.SalesSchedulingAgreement = _PricingElement.SalesSchedulingAgreement`
[0..*]	A_SalesSchedgAgrmtItem	_Item	`$projection.SalesSchedulingAgreement = _Item.SalesSchedulingAgreement`
[0..1]	E_SalesDocumentBasic	_Extension	`$projection.SalesSchedulingAgreement = _Extension.SalesDocument`

Annotations (16)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Sales Scheduling Agreement Header	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ASDSCHEDGAGRMT	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.compositionRoot	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.representativeKey	SalesSchedulingAgreement	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (50)

Key	Field	Source Field	Description
KEY	SalesSchedulingAgreement	SalesSchedulingAgreement	Sales Document
	SalesSchedgAgrmtType	SalesSchedgAgrmtType
	CreatedByUser	CreatedByUser	User Name
	LastChangedByUser	LastChangedByUser	User Name
	CreationDate	CreationDate	Time Stamp
	CreationTime	CreationTime	Time of Change
	LastChangeDate	LastChangeDate	Time Stamp
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	OrganizationDivision	Org. Division
	SalesGroup	SalesGroup	Sales Group
	SalesOffice	SalesOffice	Sales Office
	SoldToParty	SoldToParty	Sold-to Party
	SalesSchedgAgrmtDate	SalesSchedgAgrmtDate	Document Date
	SDDocumentReason	SDDocumentReason	Order Reason
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Purchase Order Number
	CustomerPurchaseOrderType	CustomerPurchaseOrderType
	CustomerPurchaseOrderDate	CustomerPurchaseOrderDate	Purchase Order Date
	SalesDistrict	SalesDistrict	Sales District
	TotalNetAmount	TotalNetAmount	Total Net Amount
	TransactionCurrency	TransactionCurrency	Transaction Currency
	PricingDate	PricingDate	Pricing Date
	ShippingType	ShippingType	Shipping Type
	ShippingCondition	ShippingCondition	Shipping Conditions
	IncotermsVersion	IncotermsVersion	Inco. Version
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	IncotermsLocation2	Inco. Location2
	DeliveryBlockReason	DeliveryBlockReason	Delivery Block
	DelivSchedTypeMRPRlvnceCode	DelivSchedTypeMRPRlvnceCode
	AgrmtValdtyStartDate	AgrmtValdtyStartDate
	AgrmtValdtyEndDate	AgrmtValdtyEndDate
	MatlUsageIndicator	MatlUsageIndicator
	HeaderBillingBlockReason	HeaderBillingBlockReason	Billing Block
	CustomerPaymentTerms	CustomerPaymentTerms	Pyt Terms
	PaymentMethod	PaymentMethod	Pymt Meth.
	FiscalYear	FiscalYear	G/L Fiscal Year
	FiscalPeriod	FiscalPeriod	Tax period
	OverallSDProcessStatus	OverallSDProcessStatus
	OverallSDDocumentRejectionSts	OverallSDDocumentRejectionSts
	TotalBlockStatus	TotalBlockStatus
	OverallDeliveryStatus	OverallDeliveryStatus
	OverallDeliveryBlockStatus	OverallDeliveryBlockStatus
	OverallBillingBlockStatus	OverallBillingBlockStatus
	TotalCreditCheckStatus	TotalCreditCheckStatus
	_Item	_Item
	_Partner	_Partner
	_PricingElement	_PricingElement
	_Text	_Text

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 A_SalesSchedgAgrmt.
-- 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 A_SalesSchedgAgrmt AS
SELECT
  SalesSchedulingAgreement,
  SalesSchedgAgrmtType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  SalesSchedgAgrmtDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  SalesDistrict,
  TotalNetAmount,
  TransactionCurrency,
  PricingDate,
  ShippingType,
  ShippingCondition,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  DeliveryBlockReason,
  DelivSchedTypeMRPRlvnceCode,
  AgrmtValdtyStartDate,
  AgrmtValdtyEndDate,
  MatlUsageIndicator,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FiscalYear,
  FiscalPeriod,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallDeliveryStatus,
  OverallDeliveryBlockStatus,
  OverallBillingBlockStatus,
  TotalCreditCheckStatus
FROM I_SalesSchedgAgrmt AS SalesSchedgAgrmt
LEFT OUTER JOIN A_SalesSchedgAgrmtPartner AS _Partner ON SalesSchedulingAgreement = _Partner.SalesSchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN A_SalesSchedgAgrmtText AS _Text ON SalesSchedulingAgreement = _Text.SalesSchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN A_SalesSchedgAgrmtPrcgElement AS _PricingElement ON SalesSchedulingAgreement = _PricingElement.SalesSchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN A_SalesSchedgAgrmtItem AS _Item ON SalesSchedulingAgreement = _Item.SalesSchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesSchedulingAgreement = _Extension.SalesDocument  -- association [0..1]
;

Depth:

A_SalesSchedgAgrmt view

I_SalesSchedgAgrmt view