_SALESORDERITEM

_SALESORDERITEM is an SAP database table in S/4HANA. It contains 74 fields.

Fields (74)

KeyField CDS FieldsUsed in Views
_Material _Material 2
_Plant _Plant 2
Batch Batch 1
BillingBlockStatus BillingBlockStatus 3
BillingDocumentDate BillingDocumentDate 1
BillingPlan BillingPlan 1
BillToParty BillToParty 3
BusinessArea BusinessArea 1
BusinessSolutionOrder BusinessSolutionOrder 1
CappedNetAmount CappedNetAmount 2
ChmlCmplncStatus ChmlCmplncStatus 1
ContractItemDownPaymentStatus ContractItemDownPaymentStatus 1
ControllingArea ControllingArea 1
CustomerPaymentTerms PaymentTerms 1
DangerousGoodsStatus DangerousGoodsStatus 1
DeliveryBlockStatus DeliveryBlockStatus 1
DeliveryConfirmationStatus DeliveryConfirmationStatus 1
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 1
DeliveryPriority DeliveryPriority 3
DeliveryStatus DeliveryStatus 1
Division Division 2
IncotermsClassification IncotermsClassification 1
IncotermsVersion IncotermsVersion 1
ItemBillingBlockReason BillingBlockReason,ItemBillingBlockReason 3
ItemBillingIncompletionStatus ItemBillingIncompletionStatus 1
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus 1
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus 1
ItemIsDeliveryRelevant ItemIsDeliveryRelevant 1
Material Material,ProductOfHigherLevelItem 9
MaterialByCustomer MaterialByCustomer 1
NetAmount NetAmount 7
OrderRelatedBillingStatus OrderRelatedBillingStatus 1
OvrlTrdCmplncLegalCtrlChkSts TradeCmplncLegalCtrlChkSts 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 1
PayerParty PayerParty 3
PaymentMethod PaymentMethod 1
Plant MRPPlant,Plant,ProductionPlant 9
PricingDate PricingDate 1
PricingIncompletionStatus PricingIncompletionStatus 1
Product Product 3
ProductHierarchyNode ProductHierarchyNode 2
ProfitCenter ProfitCenter 1
RequestedDeliveryDate RequestedDeliveryDate 1
ResponsibleEmployee ResponsibleEmployee 1
Route Route 1
SafetyDataSheetStatus SafetyDataSheetStatus 1
SalesDistrict SalesDistrict 1
SalesDocumentDate SalesOrderDate 1
SalesDocumentItemCategory SalesDocumentItemCategory,SalesOrderItemCategory 1
SalesDocumentItemText WBSElementDescription 3
SalesDocumentRjcnReason SalesDocumentRjcnReason 3
SalesEmployee SalesEmployee 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrderID SalesOrderID 2
SalesOrderItemCategory SalesOrderItemCategory 13
SalesOrderItemPosition SalesOrderItemPosition 2
SalesOrderItemText SalesOrderItemText 17
SalesOrderItemType SalesOrderItemType 7
SDDocReferenceStatus SDDocReferenceStatus 1
SDDocumentRejectionStatus SDDocumentRejectionStatus 2
SDProcessStatus SDProcessStatus 1
ShippingCondition ShippingCondition 1
ShippingPoint ShippingPoint 1
ShippingType ShippingType 1
ShipToParty ShipToParty 3
SoldToParty Customer,SoldToParty 2
StorageLocation StorageLocation 1
TotalDeliveryStatus TotalDeliveryStatus 1
TotalSDDocReferenceStatus TotalSDDocReferenceStatus 1
TransactionCurrency TransactionCurrency 9
TrdCmplncEmbargoSts TrdCmplncEmbargoSts 1
TrdCmplncSnctndListChkSts TrdCmplncSnctndListChkSts 1
WBSElementInternalID WBSElementInternalID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SALESORDERITEM (
    _MATERIAL,
    _PLANT,
    BATCH,
    BILLINGBLOCKSTATUS,
    BILLINGDOCUMENTDATE,
    BILLINGPLAN,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    CAPPEDNETAMOUNT,
    CHMLCMPLNCSTATUS,
    CONTRACTITEMDOWNPAYMENTSTATUS,
    CONTROLLINGAREA,
    CUSTOMERPAYMENTTERMS,
    DANGEROUSGOODSSTATUS,
    DELIVERYBLOCKSTATUS,
    DELIVERYCONFIRMATIONSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYPRIORITY,
    DELIVERYSTATUS,
    DIVISION,
    INCOTERMSCLASSIFICATION,
    INCOTERMSVERSION,
    ITEMBILLINGBLOCKREASON,
    ITEMBILLINGINCOMPLETIONSTATUS,
    ITEMDELIVERYINCOMPLETIONSTATUS,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMISDELIVERYRELEVANT,
    MATERIAL,
    MATERIALBYCUSTOMER,
    NETAMOUNT,
    ORDERRELATEDBILLINGSTATUS,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PARTIALDELIVERYISALLOWED,
    PAYERPARTY,
    PAYMENTMETHOD,
    PLANT,
    PRICINGDATE,
    PRICINGINCOMPLETIONSTATUS,
    PRODUCT,
    PRODUCTHIERARCHYNODE,
    PROFITCENTER,
    REQUESTEDDELIVERYDATE,
    RESPONSIBLEEMPLOYEE,
    ROUTE,
    SAFETYDATASHEETSTATUS,
    SALESDISTRICT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTEXT,
    SALESDOCUMENTRJCNREASON,
    SALESEMPLOYEE,
    SALESGROUP,
    SALESOFFICE,
    SALESORDERID,
    SALESORDERITEMCATEGORY,
    SALESORDERITEMPOSITION,
    SALESORDERITEMTEXT,
    SALESORDERITEMTYPE,
    SDDOCREFERENCESTATUS,
    SDDOCUMENTREJECTIONSTATUS,
    SDPROCESSSTATUS,
    SHIPPINGCONDITION,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    SOLDTOPARTY,
    STORAGELOCATION,
    TOTALDELIVERYSTATUS,
    TOTALSDDOCREFERENCESTATUS,
    TRANSACTIONCURRENCY,
    TRDCMPLNCEMBARGOSTS,
    TRDCMPLNCSNCTNDLISTCHKSTS,
    WBSELEMENTINTERNALID
);