I_SchdAgrSchdLnEnhcdAPI01

DDL: I_SCHDAGRSCHDLNENHCDAPI01 SQL: ISAENHDAPI01 Type: view COMPOSITE

Sched Agreement with Schedule Line Details

I_SchdAgrSchdLnEnhcdAPI01 is a Composite CDS View that provides data about "Sched Agreement with Schedule Line Details" in SAP S/4HANA. It reads from 1 data source (I_SchedgAgrmtSchedLineEnhcd) and exposes 97 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ScheduleLine, ProcurementHubSourceSystem.

Data Sources (1)

SourceAliasJoin Type
I_SchedgAgrmtSchedLineEnhcd I_SchedgAgrmtSchedLineEnhcd from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISAENHDAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Sched Agreement with Schedule Line Details view

Fields (97)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement SchedulingAgreement
KEY SchedulingAgreementItem SchedulingAgreementItem
KEY ScheduleLine ScheduleLine
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem
ScheduleLineUniqueID ScheduleLineUniqueID
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
CompanyCode CompanyCode
Supplier Supplier
Plant Plant
Material Material
MaterialGroup MaterialGroup
ServicePerformer ServicePerformer
DocumentCurrency DocumentCurrency
AnalyticalReportingCurrency AnalyticalReportingCurrency
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2
CompanyCodeCurrency CompanyCodeCurrency
AnlytlCrcyExchangeRateStatus AnlytlCrcyExchangeRateStatus
NetPriceInReportingCurrency NetPriceInReportingCurrency
NetPriceInReportingCurrency2 NetPriceInReportingCurrency2
NetPriceAmount NetPriceAmount
NetPriceInCompanyCodeCrcy NetPriceInCompanyCodeCrcy
NetAmountInReportingCurrency NetAmountInReportingCurrency
NetAmountInReportingCurrency2 NetAmountInReportingCurrency2
NetAmount NetAmount
NetAmountInCoCodeCurrency NetAmountInCoCodeCurrency
OpenAmountInReportingCurrency OpenAmountInReportingCurrency
OpenAmountInReportingCurrency2 OpenAmountInReportingCurrency2
OpenAmountInDocumentCurrency OpenAmountInDocumentCurrency
OpenAmountInCompanyCodeCrcy OpenAmountInCompanyCodeCrcy
ScheduleLineOpenQuantity ScheduleLineOpenQuantity
OrderQuantityUnit OrderQuantityUnit
IsCompletelyDelivered IsCompletelyDelivered
GoodsReceiptIsExpected GoodsReceiptIsExpected
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
PurchasingCompletenessStatus PurchasingCompletenessStatus
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
AccountAssignmentCategory AccountAssignmentCategory
CreationDate CreationDate
PurchasingDocumentOrigin PurchasingDocumentOrigin
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
PurchasingProcessingStatus PurchasingProcessingStatus
PurchasingDocumentOrderDate PurchasingDocumentOrderDate
PurchasingDocumentIsAged PurchasingDocumentIsAged
OrderQuantity OrderQuantity
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit
ProductTypeCode ProductTypeCode
ReleaseIsNotCompleted ReleaseIsNotCompleted
IsReturnsItem IsReturnsItem
PurgDocSchdLnHasNextDelivery PurgDocSchdLnHasNextDelivery
StorageLocation StorageLocation
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate
OriglPurgDocSchedLineDelivDte OriglPurgDocSchedLineDelivDte
OriglPurgDocItemStstclDelivDte OriglPurgDocItemStstclDelivDte
DelivDateCategory DelivDateCategory
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
PrevDelivQtyOfScheduleLine PrevDelivQtyOfScheduleLine
GoodsReceiptQuantity GoodsReceiptQuantity
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
SourceOfCreation SourceOfCreation
PurchasingSchdLnNrOfReminders PurchasingSchdLnNrOfReminders
SchedulingAgreementReleaseType SchedulingAgreementReleaseType
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity
ProductAvailabilityDate ProductAvailabilityDate
ProductAvailabilityTime ProductAvailabilityTime
LoadingDate LoadingDate
LoadingTime LoadingTime
TransportationPlanningDate TransportationPlanningDate
TransportationPlanningTime TransportationPlanningTime
GoodsIssueDate GoodsIssueDate
GoodsIssueTime GoodsIssueTime
STOLatestPossibleGRDate STOLatestPossibleGRDate
STOLatestPossibleGRTime STOLatestPossibleGRTime
RoughGoodsReceiptQty RoughGoodsReceiptQty
PurchaseContractItem PurchaseContractItem
PurchaseContract PurchaseContract
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
PurchaseOrderDate PurchaseOrderDate
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr
NetPriceQuantity NetPriceQuantity
OrderPriceUnit OrderPriceUnit
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodEndDate PerformancePeriodEndDate
SupplyingPlant SupplyingPlant
PurgDocItmAnlytsIndIsActv PurgDocItmAnlytsIndIsActv
PurDocItmFirstGRPostingDate PurDocItmFirstGRPostingDate
PurDocItmFinalGRPostingDate PurDocItmFinalGRPostingDate
OriglPurgDocItm1stGRPostgDte OriglPurgDocItm1stGRPostgDte
OriglPurgDocItmFnlGRPostgDte OriglPurgDocItmFnlGRPostgDte
@AbapCatalog.sqlViewName: 'ISAENHDAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Sched Agreement with Schedule Line Details'
define view I_SchdAgrSchdLnEnhcdAPI01
  as select from I_SchedgAgrmtSchedLineEnhcd
{
  key SchedulingAgreement,
  key SchedulingAgreementItem,
  key ScheduleLine,
  key ProcurementHubSourceSystem,
      ScheduleLineUniqueID,
      PurchasingOrganization,
      PurchasingGroup,
      CompanyCode,
      Supplier,
      Plant,
      Material,
      MaterialGroup,
      ServicePerformer,

      @Semantics.currencyCode: true
      DocumentCurrency,
      @Semantics.currencyCode: true
      AnalyticalReportingCurrency,
      @Semantics.currencyCode: true
      AnalyticalReportingCurrency2,
      @Semantics.currencyCode: true
      CompanyCodeCurrency,

      AnlytlCrcyExchangeRateStatus,


      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetPriceInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetPriceInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetPriceAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      NetPriceInCompanyCodeCrcy,



      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      NetAmountInCoCodeCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      OpenAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      OpenAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      OpenAmountInDocumentCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      OpenAmountInCompanyCodeCrcy,

      //MMPUR_S_ANA_OTHER_ATTRIBUTES


      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOpenQuantity,
      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,

      IsCompletelyDelivered,
      GoodsReceiptIsExpected,
      PurchasingDocumentDeletionCode,
      PurchasingCompletenessStatus,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      PurchasingDocumentItemCategory,
      AccountAssignmentCategory,
      CreationDate,

      PurchasingDocumentOrigin,
      CreatedByUser,
      LastChangeDateTime as LastChangeDateTime,
      PurchasingProcessingStatus,
      PurchasingDocumentOrderDate,
      PurchasingDocumentIsAged,

      @Semantics.quantity.unitOfMeasure: 'PurgDocOrderQuantityUnit'
      OrderQuantity,
      @Semantics.unitOfMeasure: true
      PurgDocOrderQuantityUnit,
      ProductTypeCode,
      ReleaseIsNotCompleted,
      IsReturnsItem,
      PurgDocSchdLnHasNextDelivery,
      StorageLocation,

      // MMPUR_ANA_EKETDATA


      ScheduleLineDeliveryDate,
      SchedLineStscDeliveryDate,
      OriglPurgDocSchedLineDelivDte,
      OriglPurgDocItemStstclDelivDte,

      DelivDateCategory,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOrderQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PrevDelivQtyOfScheduleLine,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      GoodsReceiptQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineIssuedQuantity,
      ScheduleLineDeliveryTime,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      SourceOfCreation,
      PurchasingSchdLnNrOfReminders,
      SchedulingAgreementReleaseType,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineCommittedQuantity,
      ProductAvailabilityDate,
      ProductAvailabilityTime,
      LoadingDate,
      LoadingTime,
      TransportationPlanningDate,
      TransportationPlanningTime,
      GoodsIssueDate,
      GoodsIssueTime,
      STOLatestPossibleGRDate,
      STOLatestPossibleGRTime,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      RoughGoodsReceiptQty,
      PurchaseContractItem,
      PurchaseContract,
      MultipleAcctAssgmtDistribution,
      PurchaseOrderDate,
      OrderPriceUnitToOrderUnitNmrtr,
      OrdPriceUnitToOrderUnitDnmntr,
      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      NetPriceQuantity,
      @Semantics.unitOfMeasure: true
      OrderPriceUnit,
      PerformancePeriodStartDate,
      PerformancePeriodEndDate,
      SupplyingPlant,
      PurgDocItmAnlytsIndIsActv,
      PurDocItmFirstGRPostingDate,
      PurDocItmFinalGRPostingDate,
      OriglPurgDocItm1stGRPostgDte,
      OriglPurgDocItmFnlGRPostgDte
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SCHEDGAGRMTSCHEDLINEENHCD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/