A_SchedgAgrmtItem_2

DDL: A_SCHEDGAGRMTITEM_2 Type: view_entity CONSUMPTION
100 Fields 1 Data Sources

Scheduling Agreement Item

A_SchedgAgrmtItem_2 is a Consumption CDS View that provides data about "Scheduling Agreement Item" in SAP S/4HANA. It reads from 1 data source (R_SchedgAgrmtItmTP) and exposes 100 fields with key fields SchedulingAgreement, SchedulingAgreementItem.

Data Sources (1)

SourceAliasJoin Type
R_SchedgAgrmtItmTP R_SchedgAgrmtItmTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Scheduling Agreement Item view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SchedulingAgreementItem_Type view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem SchedulingAgreementItem Schedule Item Number
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Material Material Vehicle Model
ManufacturerMaterial ManufacturerMaterial MPN: Material
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ReferenceDeliveryAddressID ReferenceDeliveryAddressID Reference Address
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
ItemNetWeight ItemNetWeight Net Weight
WeightUnit WeightUnit Weight unit
WeightUnitISOCode WeightUnitISOCode
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SchedAgrmtAgreedCumQty SchedAgrmtAgreedCumQty
SchedAgrmtCumQtyReconcileDate SchedAgrmtCumQtyReconcileDate
ItemLastTransmissionDate ItemLastTransmissionDate
NoDaysReminder1 NoDaysReminder1 1st Rem./Exped.
NoDaysReminder2 NoDaysReminder2 2nd Rem./Exped.
NoDaysReminder3 NoDaysReminder3 3rd Rem./Exped.
PurgDocOrderAcknNumber PurgDocOrderAcknNumber Order Acknowl.
RequirementTracking RequirementTracking Tracking Number
IsOrderAcknRqd IsOrderAcknRqd Acknowl. Reqd.
PriceIsToBePrinted PriceIsToBePrinted Print Price
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
OrderPriceUnit OrderPriceUnit Order Price Un.
OrderPriceUnitISOCode OrderPriceUnitISOCode
TargetQuantity TargetQuantity Target Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode OrderQuantityUnitISOCode
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrdPrcUnitToOrderUnitDnmntrUoM OrdPrcUnitToOrderUnitDnmntrUoM Order Unit
OrdPrcUntToOrdUntDnmntrISOUnit OrdPrcUntToOrdUntDnmntrISOUnit
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPrcUnitToOrderUnitNmrtrUoM OrdPrcUnitToOrderUnitNmrtrUoM Order Price Un.
OrdPrcUntToOrdUntNmrtrISOUnit OrdPrcUntToOrdUntNmrtrISOUnit
ProductTypeCode ProductTypeCode Product Type Group
MaterialType MaterialType Material Type
StorageLocation StorageLocation StorageLocation
DocumentCurrency DocumentCurrency Document Currency
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
StockType StockType Stock Type
TaxCode TaxCode Tax Code
TaxCountry TaxCountry Tax Ctry/Reg.
TaxCodeValidFromDate TaxCodeValidFromDate Tax Rate Valid-From
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
ShippingInstruction ShippingInstruction Shipping Instr.
IsInfoAtRegistration IsInfoAtRegistration InfoAtReg.
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin Origin Accept.
MinRemainingShelfLife MinRemainingShelfLife Rem. Shelf Life
QualityMgmtCtrlKey QualityMgmtCtrlKey QM Control Key
QualityCertificateType QualityCertificateType
SchedAgrmtCumulativeQtyControl SchedAgrmtCumulativeQtyControl
CumulativeQuantityIsNotSent CumulativeQuantityIsNotSent
SchedgAgrmtRelCreationProfile SchedgAgrmtRelCreationProfile
IsRelevantForJITDelivSchedule IsRelevantForJITDelivSchedule
NextFcstDelivSchedSendingDate NextFcstDelivSchedSendingDate
NextJITDelivSchedSendingDate NextJITDelivSchedSendingDate
LoadingPointForDelivery LoadingPointForDelivery
ScheduleLineFirmOrderInDays ScheduleLineFirmOrderInDays
SchedLineSemiFirmOrderInDays SchedLineSemiFirmOrderInDays
FirmTradeOffZoneBindMRP FirmTradeOffZoneBindMRP
Subcontractor Subcontractor Supplier
Customer Customer Sold-to Party
MRPArea MRPArea MRP Area
SupplierIsSubcontractor SupplierIsSubcontractor SC Supplier
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
SchedgAgrmtItmReplnmtElmntType SchedgAgrmtItmReplnmtElmntType
InternationalArticleNumber InternationalArticleNumber EAN/UPC
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingParentItem PurchasingParentItem Parent Item No
GrossAmount GrossAmount Gross value
TargetAmount TargetAmount Target Value
Manufacturer Manufacturer Manufacturer
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
ServicePackage ServicePackage Package number
PurgProdCmplncSupplierStatus PurgProdCmplncSupplierStatus Supplier Check Sts
LastChangeDateTime LastChangeDateTime Timestamp

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_SchedgAgrmtItem_2.
-- 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_SchedgAgrmtItem_2 AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchasingDocumentItemText,
  Material,
  ManufacturerMaterial,
  SupplierMaterialNumber,
  MaterialGroup,
  Plant,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  ItemNetWeight,
  WeightUnit,
  WeightUnitISOCode,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SchedAgrmtAgreedCumQty,
  SchedAgrmtCumQtyReconcileDate,
  ItemLastTransmissionDate,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PurgDocOrderAcknNumber,
  RequirementTracking,
  IsOrderAcknRqd,
  PriceIsToBePrinted,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  NetPriceAmount,
  NetPriceQuantity,
  OrderPriceUnit,
  OrderPriceUnitISOCode,
  TargetQuantity,
  OrderQuantityUnit,
  OrderQuantityUnitISOCode,
  OrdPriceUnitToOrderUnitDnmntr,
  OrdPrcUnitToOrderUnitDnmntrUoM,
  OrdPrcUntToOrdUntDnmntrISOUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPrcUnitToOrderUnitNmrtrUoM,
  OrdPrcUntToOrdUntNmrtrISOUnit,
  ProductTypeCode,
  MaterialType,
  StorageLocation,
  DocumentCurrency,
  PurchasingInfoRecord,
  PurchasingDocumentDeletionCode,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  StockType,
  TaxCode,
  TaxCountry,
  TaxCodeValidFromDate,
  TaxDeterminationDate,
  ShippingInstruction,
  IsInfoAtRegistration,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  EvaldRcptSettlmtIsAllowed,
  IsToBeAcceptedAtOrigin,
  MinRemainingShelfLife,
  QualityMgmtCtrlKey,
  QualityCertificateType,
  SchedAgrmtCumulativeQtyControl,
  CumulativeQuantityIsNotSent,
  SchedgAgrmtRelCreationProfile,
  IsRelevantForJITDelivSchedule,
  NextFcstDelivSchedSendingDate,
  NextJITDelivSchedSendingDate,
  LoadingPointForDelivery,
  ScheduleLineFirmOrderInDays,
  SchedLineSemiFirmOrderInDays,
  FirmTradeOffZoneBindMRP,
  Subcontractor,
  Customer,
  MRPArea,
  SupplierIsSubcontractor,
  PurchasingDocumentItemCategory,
  IsEndOfPurposeBlocked,
  SchedgAgrmtItmReplnmtElmntType,
  InternationalArticleNumber,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingParentItem,
  GrossAmount,
  TargetAmount,
  Manufacturer,
  ManufacturerPartNmbr,
  ServicePackage,
  PurgProdCmplncSupplierStatus,
  LastChangeDateTime
FROM R_SchedgAgrmtItmTP
;

Learn More