I_CFINRPLDPURGDOCSCHEDULELINE
CFin Rpld Purchasing Doc: Schedule Line
I_CFINRPLDPURGDOCSCHEDULELINE is a CDS View in S/4HANA. CFin Rpld Purchasing Doc: Schedule Line. It contains 17 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CFinRpldPurOrdScheduleLine | view | from | CONSUMPTION | CFin Rpld Purchase Order Schedule Line |
| I_CFinPurgDocScheduleLine | view | from | COMPOSITE | CFin Purchasing Document: Schedule Line |
| R_CFinRpldPurgDocSchedLineTP | view_entity | from | TRANSACTIONAL | CFin Rpld Purchasing Doc Schedule Line |
Fields (17)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SenderLogicalSystem | SenderLogicalSystem | 1 |
| Batch | Batch | 1 | |
| CommittedDeliveryDate | CommittedDeliveryDate | 1 | |
| DelivDateCategory | DelivDateCategory | 1 | |
| GoodsReceiptQuantity | GoodsReceiptQuantity | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| PerformancePeriodEndDate | PerformancePeriodEndDate | 1 | |
| PerformancePeriodStartDate | PerformancePeriodStartDate | 1 | |
| PurchasingSchdLnNrOfReminders | PurchasingSchdLnNrOfReminders | 1 | |
| SchedLineStscDeliveryDate | SchedLineStscDeliveryDate | 1 | |
| ScheduleLineCommittedQuantity | ScheduleLineCommittedQuantity | 1 | |
| ScheduleLineDeliveryDate | ScheduleLineDeliveryDate | 1 | |
| ScheduleLineDeliveryTime | ScheduleLineDeliveryTime | 1 | |
| ScheduleLineIssuedQuantity | ScheduleLineIssuedQuantity | 1 | |
| ScheduleLineOrderDate | ScheduleLineOrderDate | 1 | |
| ScheduleLineOrderQuantity | ScheduleLineOrderQuantity | 1 | |
| StockTransferDeliveredQuantity | StockTransferDeliveredQuantity | 1 |
@EndUserText.label: 'CFin Rpld Purchasing Doc: Schedule Line'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'ICFINRPOSLN',
preserveKey: true,
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
}
}
define view I_CFinRpldPurgDocScheduleLine
as select from cfin_av_po_sch
inner join cfin_av_po_item on cfin_av_po_sch.parent_key = cfin_av_po_item.db_key
association [1..1] to I_CFinRpldPurchasingDocument as _CFinRpldPurchasingDocument on $projection.SenderLogicalSystem = _CFinRpldPurchasingDocument.SenderLogicalSystem
and $projection.CFinRpldPurchasingDocument = _CFinRpldPurchasingDocument.CFinRpldPurchasingDocument
association [1..1] to I_CFinRpldPurchasingDocItem as _CFinRpldPurchasingDocItem on $projection.SenderLogicalSystem = _CFinRpldPurchasingDocItem.SenderLogicalSystem
and $projection.CFinRpldPurchasingDocument = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocument
and $projection.CFinRpldPurchasingDocumentItem = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocumentItem
association [1..1] to I_Deliverydatecategory as _DeliveryDateCategory on $projection.DelivDateCategory = _DeliveryDateCategory.DelivDateCategory
association [0..1] to I_UnitOfMeasure as _OrderQuantityUnit on $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
association [0..1] to I_LogicalSystem as _LogicalSystem on $projection.SenderLogicalSystem = _LogicalSystem.LogicalSystem
{
key cfin_av_po_sch.fins_logsys as SenderLogicalSystem,
key cast( cfin_av_po_sch.ebeln as fins_cfin_av_purchasing_doc preserving type ) as CFinRpldPurchasingDocument,
key cast( cfin_av_po_sch.ebelp as fins_cfin_av_purg_document_itm preserving type ) as CFinRpldPurchasingDocumentItem,
key cast( cfin_av_po_sch.etenr as fins_cfin_av_purg_doc_sln preserving type ) as CFinRpldPurgDocScheduleLine,
cfin_av_po_sch.eindt as ScheduleLineDeliveryDate,
cfin_av_po_sch.slfdt as SchedLineStscDeliveryDate,
@ObjectModel.foreignKey.association: '_DeliveryDateCategory'
cfin_av_po_sch.lpein as DelivDateCategory,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
cfin_av_po_sch.menge as ScheduleLineOrderQuantity,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
cfin_av_po_sch.wemng as GoodsReceiptQuantity,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
cfin_av_po_sch.wamng as ScheduleLineIssuedQuantity,
cfin_av_po_sch.uzeit as ScheduleLineDeliveryTime,
cfin_av_po_sch.mahnz as PurchasingSchdLnNrOfReminders,
cfin_av_po_sch.bedat as ScheduleLineOrderDate,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
cfin_av_po_sch.glmng as StockTransferDeliveredQuantity,
cfin_av_po_sch.charg as Batch,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
cfin_av_po_sch.mng02 as ScheduleLineCommittedQuantity,
cfin_av_po_sch.dat01 as CommittedDeliveryDate,
cfin_av_po_sch.startdate as PerformancePeriodStartDate,
cfin_av_po_sch.enddate as PerformancePeriodEndDate,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_OrderQuantityUnit'
cfin_av_po_item.meins as OrderQuantityUnit,
_CFinRpldPurchasingDocument,
_CFinRpldPurchasingDocItem,
_DeliveryDateCategory,
_OrderQuantityUnit,
_LogicalSystem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CFIN_AV_PO_ITEM",
"CFIN_AV_PO_SCH"
],
"ASSOCIATED":
[
"I_CFINRPLDPURCHASINGDOCITEM",
"I_CFINRPLDPURCHASINGDOCUMENT",
"I_DELIVERYDATECATEGORY",
"I_LOGICALSYSTEM",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/