@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Order Item'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA'),
privilegedAssociations: [ '_CreatedByUser', '_BusinessAreaText','_MaterialText','_ProductText','_OrigMaterialText','_ShippingPointText' ]
}
@AbapCatalog: {
sqlViewName: 'ISDSLSORDERITEM',
preserveKey: true,
compiler.compareFilter: true
}
@ObjectModel: {
representativeKey: 'SalesOrderItem',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XL
},
supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ],
modelingPattern: [ #ANALYTICAL_DIMENSION ]
}
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions: true
@ObjectModel.sapObjectNodeType.name: 'SalesOrderItem'
@Analytics: {
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[
{
table: 'vbap', role: #MAIN,
viewElement: ['SalesOrder', 'SalesOrderItem'],
tableElement: ['vbeln', 'posnr']
},
{
table: 'vbak', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['SalesOrder'],
tableElement: ['vbeln']},
{
table: 'vbkd', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['SalesOrder', 'SalesOrderItem'],
tableElement: ['vbeln', 'posnr']
},
{
table: 'veda', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['SalesOrder', 'SalesOrderItem'],
tableElement: ['vbeln', 'vposn']
}
]
}
}
}
define view I_SalesOrderItem
as select from I_SalesDocumentItem as SalesDocumentItem
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
association [0..*] to I_BusinessAreaText as _BusinessAreaText on $projection.BusinessArea = _BusinessAreaText.BusinessArea
association [0..*] to I_MaterialText as _MaterialText on $projection.Material = _MaterialText.Material
association [0..*] to I_ProductText as _ProductText on $projection.Product = _ProductText.Product
association [0..*] to I_MaterialText as _OrigMaterialText on $projection.OriginallyRequestedMaterial = _OrigMaterialText.Material
association [0..*] to I_ShippingPointText as _ShippingPointText on $projection.ShippingPoint = _ShippingPointText.ShippingPoint
// ]--GENERATED
association [1..1] to I_SalesOrder as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
association [0..*] to I_SalesOrderScheduleLine as _ScheduleLine on $projection.SalesOrder = _ScheduleLine.SalesOrder
and $projection.SalesOrderItem = _ScheduleLine.SalesOrderItem
association [0..*] to I_SalesOrderItemPartner as _Partner on $projection.SalesOrder = _Partner.SalesOrder
and $projection.SalesOrderItem = _Partner.SalesOrderItem
association [0..*] to I_SalesOrderItemPricingElement as _PricingElement on $projection.SalesOrder = _PricingElement.SalesOrder
and $projection.SalesOrderItem = _PricingElement.SalesOrderItem
association [0..1] to I_SalesOrderItem as _HigherLevelItem on $projection.SalesOrder = _HigherLevelItem.SalesOrder
and $projection.HigherLevelItem = _HigherLevelItem.SalesOrderItem
association [0..1] to I_SalesOrderItemBillingPlan as _ItemBillingPlan on $projection.SalesOrder = _ItemBillingPlan.SalesOrder
and $projection.SalesOrderItem = _ItemBillingPlan.SalesOrderItem
and $projection.BillingPlan = _ItemBillingPlan.BillingPlan
association [0..*] to I_SalesOrderItmPrecdgProcFlow as _PrecedingProcFlowDocItem on _PrecedingProcFlowDocItem.SalesOrder = $projection.SalesOrder
and _PrecedingProcFlowDocItem.SalesOrderItem = $projection.SalesOrderItem
association [0..*] to I_SalesOrderItmSubsqntProcFlow as _SubsequentProcFlowDocItem on _SubsequentProcFlowDocItem.SalesOrder = $projection.SalesOrder
and _SubsequentProcFlowDocItem.SalesOrderItem = $projection.SalesOrderItem
//Extensibility
association [0..1] to E_SalesDocumentItemBasic as _Extension on SalesDocumentItem.SalesDocument = _Extension.SalesDocument
and SalesDocumentItem.SalesDocumentItem = _Extension.SalesDocumentItem
{
//Key
@ObjectModel.foreignKey.association: '_SalesOrder'
key cast(SalesDocument as vdm_sales_order preserving type) as SalesOrder,
@ObjectModel.text.element: 'SalesOrderItemText'
key cast(SalesDocumentItem as sales_order_item preserving type) as SalesOrderItem,
SalesDocumentItemUUID as SalesOrderItemUUID,
// Category
@ObjectModel.foreignKey.association: '_ItemCategory'
SalesDocumentItemCategory as SalesOrderItemCategory,
SalesDocumentItemType as SalesOrderItemType,
IsReturnsItem,
//Admin
CreatedByUser,
@Semantics.systemDate.createdAt: true
CreationDate,
CreationTime,
@Semantics.systemDate.lastChangedAt: true
LastChangeDate,
//Org
@ObjectModel.foreignKey.association: '_Division'
Division,
//Product
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
@ObjectModel.text.association: '_MaterialText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Material'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'Product'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'Product'
Material,
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProductStdVH',
element: 'Product' }
}]
@ObjectModel.text.association: '_ProductText'
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_Product'
Product,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProductStdVH',
element: 'Product' }
}]
@ObjectModel.text.association: '_OrigMaterialText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
OriginallyRequestedMaterial,
MaterialByCustomer,
InternationalArticleNumber,
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BatchStdVH',
element: 'Batch' },
additionalBinding: [{ localElement: 'Plant',
element: 'Plant' },
{ localElement: 'Material',
element: 'Material' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Batch'
Batch,
@ObjectModel.foreignKey.association: '_ProductHierarchyNode'
ProductHierarchyNode,
ProductCatalog,
@ObjectModel.foreignKey.association: '_MaterialSubstitutionReason'
MaterialSubstitutionReason,
@ObjectModel.foreignKey.association: '_MaterialGroup'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProductGroup'
MaterialGroup,
@ObjectModel.foreignKey.association: '_ProductGroup'
@Analytics.internalName: #LOCAL
ProductGroup,
@ObjectModel.foreignKey.association: '_MaterialPricingGroup'
MaterialPricingGroup,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
AdditionalMaterialGroup1,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
AdditionalMaterialGroup2,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
AdditionalMaterialGroup3,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
AdditionalMaterialGroup4,
@ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
AdditionalMaterialGroup5,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_OriginalPlant'
OriginalPlant,
@ObjectModel.foreignKey.association: '_StorageLocation'
StorageLocation,
DeliveryGroup,
ProductConfiguration,
BOMExplosionDate,
//Sales
@Semantics.text: true
SalesDocumentItemText as SalesOrderItemText,
PurchaseOrderByCustomer,
PurchaseOrderByShipToParty,
@Analytics.internalName: #LOCAL
CustomerPurchaseOrderDate,
UnderlyingPurchaseOrderItem,
ExternalItemID,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
OrderQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_OrderQuantityUnit'
OrderQuantityUnit,
OrderToBaseQuantityDnmntr,
OrderToBaseQuantityNmrtr,
@Semantics.quantity.unitOfMeasure: 'TargetQuantityUnit'
TargetQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_TargetQuantityUnit'
TargetQuantityUnit,
TargetToBaseQuantityDnmntr,
TargetToBaseQuantityNmrtr,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
ConfdDelivQtyInOrderQtyUnit,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
TargetDelivQtyInOrderQtyUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
ConfdDeliveryQtyInBaseUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_BaseUnit'
BaseUnit,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
CommittedDelivQtyInOrdQtyUnit,
CommittedDelivCreationDate,
CommittedDeliveryDate,
@Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
RequestedQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_RequestedQuantityUnit'
RequestedQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
RequestedQuantityInBaseUnit,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemGrossWeight,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemNetWeight,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemWeightUnit'
ItemWeightUnit,
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
ItemVolume,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ItemVolumeUnit'
ItemVolumeUnit,
ServicesRenderedDate,
@ObjectModel.foreignKey.association: '_SalesDistrict'
SalesDistrict,
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_SalesDealStdVH',
element: 'SalesDeal' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_SalesDeal'
SalesDeal,
SalesPromotion,
RetailPromotion,
@ObjectModel.foreignKey.association: '_CustomerGroup'
CustomerGroup,
@ObjectModel.foreignKey.association: '_SalesDocumentRjcnReason'
SalesDocumentRjcnReason,
RequirementSegment,
SlsDocIsRlvtForProofOfDeliv,
// Pricing
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'TransactionCurrency'
NetAmount,
@Semantics.currencyCode: true
@ObjectModel.foreignKey.association: '_TransactionCurrency'
TransactionCurrency,
PricingDate,
PricingReferenceMaterial,
ExchangeRateDate,
PriceDetnExchangeRate,
@Semantics.amount.currencyCode: 'TransactionCurrency'
NetPriceAmount,
@Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
NetPriceQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_NetPriceQuantityUnit'
NetPriceQuantityUnit,
@ObjectModel.foreignKey.association: '_StatisticalValueControl'
StatisticalValueControl,
SalesDocumentItemProcgCode,
@Semantics.amount.currencyCode: 'TransactionCurrency'
TaxAmount,
ProductTaxClassification1,
ProductTaxClassification2,
ProductTaxClassification3,
ProductTaxClassification4,
ProductTaxClassification5,
ProductTaxClassification6,
ProductTaxClassification7,
ProductTaxClassification8,
ProductTaxClassification9,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_MatlAccountAssignmentGroup'
MatlAccountAssignmentGroup,
@Semantics.amount.currencyCode: 'TransactionCurrency'
CostAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal1Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal2Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal3Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal4Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal5Amount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
Subtotal6Amount,
SalesDocumentCondition as SalesOrderCondition,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_CustomerPriceGroup'
CustomerPriceGroup,
//Shipping
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ShippingPointStdVH',
element: 'ShippingPoint' }
}]
@ObjectModel.text.association: '_ShippingPointText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ShippingPoint'
ShippingPoint,
@ObjectModel.foreignKey.association: '_ShippingType'
ShippingType,
InventorySpecialStockType,
@ObjectModel.foreignKey.association: '_DeliveryPriority'
DeliveryPriority,
@ObjectModel.foreignKey.association: '_Route'
Route,
DeliveryDateQuantityIsFixed,
DeliveryDateTypeRule,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_PartialDeliveryItem'
PartialDeliveryIsAllowed,
MaxNmbrOfPartialDelivery,
UnlimitedOverdeliveryIsAllowed,
OverdelivTolrtdLmtRatioInPct,
UnderdelivTolrtdLmtRatioInPct,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
MinDeliveryQtyInBaseUnit,
OpenDeliveryLeadingUnitCode,
ItemIsDeliveryRelevant,
ReceivingPoint,
//Incoterms
@ObjectModel.foreignKey.association: '_IncotermsVersion'
IncotermsVersion,
@ObjectModel.foreignKey.association: '_IncotermsClassification'
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
SalesDocumentItem.OrderCombinationIsAllowed,
//Payment
@ObjectModel.foreignKey.association: '_CustomerPaymentTerms'
CustomerPaymentTerms,
PaymentMethod,
FixedValueDate,
AdditionalValueDays,
//Fashion
ProductSeasonYear,
ProductSeason,
ProductCollection,
ProductTheme,
FashionCancelDate,
ProductCharacteristic1,
ProductCharacteristic2,
ProductCharacteristic3,
ShippingGroupNumber,
ShippingGroupRule,
//Billing
BillingDocumentDate,
@ObjectModel.foreignKey.association: '_ItemIsBillingRelevant'
ItemIsBillingRelevant,
@ObjectModel.foreignKey.association: '_ItemBillingBlockReason'
ItemBillingBlockReason,
BillingPlan,
//Accounting
FiscalYear,
FiscalPeriod,
@ObjectModel.foreignKey.association: '_CustomerAccountAssgmtGroup'
CustomerAccountAssignmentGroup,
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BusinessAreaStdVH',
element: 'BusinessArea' }
}]
@ObjectModel.text.association: '_BusinessAreaText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
@Analytics.internalName: #LOCAL
ControllingArea,
@Analytics.internalName: #LOCAL
ProfitCenter,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID'
WBSElement,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_WBSElementBasicData_2'
WBSElementInternalID,
OrderID,
ControllingObject,
@API.element.releaseState: #DECOMMISSIONED
@API.element.successor: 'ProfitabilitySegment_2'
ProfitabilitySegment,
ProfitabilitySegment_2,
OriginSDDocument,
OriginSDDocumentItem,
AccountingExchangeRate,
ContractAccount,
//Reference
@ObjectModel.foreignKey.association: '_ReferenceSDDocument'
ReferenceSDDocument,
@ObjectModel.foreignKey.association: '_ReferenceSDDocumentItem'
ReferenceSDDocumentItem,
@ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
ReferenceSDDocumentCategory,
@ObjectModel.foreignKey.association: '_HigherLevelItem'
@Analytics.internalName: #LOCAL
HigherLevelItem,
HigherLevelItemUsage,
//Status
@ObjectModel.foreignKey.association: '_SDProcessStatus'
SDProcessStatus,
@ObjectModel.foreignKey.association: '_DeliveryConfirmationStatus'
DeliveryConfirmationStatus,
@ObjectModel.foreignKey.association: '_PurchaseConfirmationStatus'
PurchaseConfirmationStatus,
@ObjectModel.foreignKey.association: '_TotalDeliveryStatus'
TotalDeliveryStatus,
@ObjectModel.foreignKey.association: '_DeliveryStatus'
DeliveryStatus,
@ObjectModel.foreignKey.association: '_DeliveryBlockStatus'
DeliveryBlockStatus,
@ObjectModel.foreignKey.association: '_OrderRelatedBillingStatus'
OrderRelatedBillingStatus,
@ObjectModel.foreignKey.association: '_BillingBlockStatus'
BillingBlockStatus,
@ObjectModel.foreignKey.association: '_ItemGeneralIncompletionStatus'
ItemGeneralIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemBillingIncompletionStatus'
ItemBillingIncompletionStatus,
@ObjectModel.foreignKey.association: '_PricingIncompletionStatus'
PricingIncompletionStatus,
@ObjectModel.foreignKey.association: '_ItemDelivIncompletionSts'
ItemDeliveryIncompletionStatus,
@ObjectModel.foreignKey.association: '_SDDocReferenceStatus'
SDDocReferenceStatus,
@ObjectModel.foreignKey.association: '_SDDocumentRejectionStatus'
SDDocumentRejectionStatus,
@ObjectModel.foreignKey.association: '_TotalSDDocReferenceStatus'
TotalSDDocReferenceStatus,
@ObjectModel.foreignKey.association: '_ChmlCmplncStatus'
ChmlCmplncStatus,
@ObjectModel.foreignKey.association: '_DangerousGoodsStatus'
DangerousGoodsStatus,
@ObjectModel.foreignKey.association: '_SafetyDataSheetStatus'
SafetyDataSheetStatus,
@ObjectModel.foreignKey.association: '_ItemDownPaymentStatus'
ContractItemDownPaymentStatus as SlsOrderItemDownPaymentStatus,
@ObjectModel.foreignKey.association: '_TrdCmplncEmbargoSts'
TrdCmplncEmbargoSts,
@ObjectModel.foreignKey.association: '_TrdCmplncSnctndListChkSts'
TrdCmplncSnctndListChkSts,
@ObjectModel.foreignKey.association: '_OvrlTrdCmplncLegalCtrlChkSts'
OvrlTrdCmplncLegalCtrlChkSts,
@ObjectModel.foreignKey.association: '_AltvBsdConfSubstitutionSts'
AltvBsdConfSubstitutionStatus,
OmniChannelSalesPromotion,
OmniChannelSalesPromotionRule,
@ObjectModel.foreignKey.association: '_ConsumptionPosting'
ConsumptionPosting,
//PBS
@Semantics.amount.currencyCode: 'TransactionCurrency'
CappedNetAmount,
CappedNetAmtAlertThldInPct,
//this field is relevant only for PBS scenario
@Semantics.amount.currencyCode: 'TransactionCurrency'
SalesDocumentItem.TotalStandAloneSellingPrice,
//Association
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
#TO_COMPOSITION_ROOT]
_SalesOrder,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_ScheduleLine,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_Partner,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_PricingElement,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_ItemBillingPlan,
_ItemCategory,
_CreatedByUser,
_Division,
_Material,
_Product,
_OriginallyRequestedMaterial,
_MaterialPlant,
_Batch,
_ProductHierarchyNode,
_MaterialSubstitutionReason,
_MaterialGroup,
_ProductGroup,
_MaterialPricingGroup,
_AdditionalMaterialGroup1,
_AdditionalMaterialGroup2,
_AdditionalMaterialGroup3,
_AdditionalMaterialGroup4,
_AdditionalMaterialGroup5,
_MatlAccountAssignmentGroup,
_Plant,
_OriginalPlant,
_StorageLocation,
_OrderQuantityUnit,
_BaseUnit,
_TargetQuantityUnit,
_RequestedQuantityUnit,
_ItemWeightUnit,
_ItemVolumeUnit,
_SalesDistrict,
_SalesDeal,
_CustomerGroup,
_CustomerPriceGroup,
_SalesDocumentRjcnReason,
_TransactionCurrency,
_NetPriceQuantityUnit,
_StatisticalValueControl,
_ShippingPoint,
_ShippingType,
_DeliveryPriority,
_DeliveryDateTypeRule,
_PartialDeliveryItem,
_Route,
_IncotermsClassification,
_IncotermsVersion,
_ItemIsBillingRelevant,
_ItemBillingBlockReason,
_CustomerPaymentTerms,
//PaymentMethod,
_CustomerAccountAssgmtGroup,
_BusinessArea,
@Consumption.filter.businessDate.at: true
_ProfitCenter,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_WBSElementBasicData_2'
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_WBSElementBasicData_2'
_WBSElementBasicData,
_WBSElementBasicData_2,
_ReferenceSDDocument,
_ReferenceSDDocumentItem,
_ReferenceSDDocumentCategory,
_HigherLevelItem,
_SDProcessStatus,
_DeliveryConfirmationStatus,
_PurchaseConfirmationStatus,
_TotalDeliveryStatus,
_DeliveryStatus,
_DeliveryBlockStatus,
_ContractItemDownPaymentStatus as _ItemDownPaymentStatus,
_OrderRelatedBillingStatus,
_BillingBlockStatus,
_ItemGeneralIncompletionStatus,
_ItemBillingIncompletionStatus,
_PricingIncompletionStatus,
_ItemDelivIncompletionSts,
_SDDocReferenceStatus,
_SDDocumentRejectionStatus,
_TotalSDDocReferenceStatus,
_ChmlCmplncStatus,
_DangerousGoodsStatus,
_SafetyDataSheetStatus,
_OvrlTrdCmplncLegalCtrlChkSts,
_AltvBsdConfSubstitutionSts,
_TrdCmplncSnctndListChkSts,
_TrdCmplncEmbargoSts,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ItemBillingPlan'
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ItemBillingPlan'
_BillingPlan,
_PrecedingProcFlowDocItem,
_SubsequentProcFlowDocItem,
_ConsumptionPosting,
//--[ GENERATED:012:GFBfhxvv7jY4otz}RhcFP0
@Consumption.hidden: true
_BusinessAreaText,
@Consumption.hidden: true
_MaterialText,
@Consumption.hidden: true
_ProductText,
@Consumption.hidden: true
_OrigMaterialText,
@Consumption.hidden: true
_ShippingPointText
// ]--GENERATED
}
where
SalesDocumentItem.SDDocumentCategory = 'C';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTITEM"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTITEMBASIC",
"I_ADDITIONALMATERIALGROUP1",
"I_ADDITIONALMATERIALGROUP2",
"I_ADDITIONALMATERIALGROUP3",
"I_ADDITIONALMATERIALGROUP4",
"I_ADDITIONALMATERIALGROUP5",
"I_ALTVBSDCONFSUBSTITUTIONSTS",
"I_BATCH",
"I_BILLINGBLOCKREASON",
"I_BILLINGBLOCKSTATUS",
"I_BILLINGRELEVANCECODE",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_CHMLCMPLNCSTATUS",
"I_CONSUMPTIONPOSTING",
"I_CONTRACTDOWNPAYMENTSTATUS",
"I_CURRENCY",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_DANGEROUSGOODSSTATUS",
"I_DELIVERYBLOCKSTATUS",
"I_DELIVERYCONFIRMATIONSTATUS",
"I_DELIVERYDATETYPERULE",
"I_DELIVERYPRIORITY",
"I_DELIVERYSTATUS",
"I_DIVISION",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_ITEMBILLINGINCOMPLETIONSTS",
"I_ITEMDELIVINCOMPLETIONSTS",
"I_ITEMGENINCOMPLETIONSTATUS",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_MATERIALPLANT",
"I_MATERIALPRICINGGROUP",
"I_MATERIALSUBSTITUTIONREASON",
"I_MATERIALTEXT",
"I_MATLACCOUNTASSIGNMENTGROUP",
"I_ORDERRELATEDBILLINGSTATUS",
"I_OVRLTRDCMPLNCLEGALCTRLCHKSTS",
"I_PARTIALDELIVERYITEM",
"I_PLANT",
"I_PRICINGINCOMPLETIONSTATUS",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PRODUCTHIERARCHYNODE",
"I_PRODUCTTEXT",
"I_PROFITCENTER",
"I_PURCHASECONFIRMATIONSTATUS",
"I_ROUTE",
"I_SAFETYDATASHEETSTATUS",
"I_SALESDEAL",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTRJCNREASON",
"I_SALESORDER",
"I_SALESORDERITEMBILLINGPLAN",
"I_SALESORDERITEMPARTNER",
"I_SALESORDERITEMPRICINGELEMENT",
"I_SALESORDERITMPRECDGPROCFLOW",
"I_SALESORDERITMSUBSQNTPROCFLOW",
"I_SALESORDERSCHEDULELINE",
"I_SDDOCREFERENCESTATUS",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREJECTIONSTATUS",
"I_SDPROCESSSTATUS",
"I_SHIPPINGPOINT",
"I_SHIPPINGPOINTTEXT",
"I_SHIPPINGTYPE",
"I_SLSDOCITEMBILLINGPLAN",
"I_STATISTICALVALUECONTROL",
"I_STORAGELOCATION",
"I_TOTALDELIVERYSTATUS",
"I_TOTALSDDOCREFERENCESTATUS",
"I_TRDCMPLNCCHECKSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_SALESDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/