_SALESDOCUMENTITEM

79 Fields

_SALESDOCUMENTITEM is an SAP database table in S/4HANA. It contains 79 fields.

Fields (79)

KeyField CDS FieldsUsed in Views
KEY Division Division 4
KEY ShipToParty ShipToParty 1
_AdditionalMaterialGroup1 _AdditionalMaterialGroup1 1
_AdditionalMaterialGroup2 _AdditionalMaterialGroup2 1
_AdditionalMaterialGroup3 _AdditionalMaterialGroup3 1
_AdditionalMaterialGroup4 _AdditionalMaterialGroup4 1
_AdditionalMaterialGroup5 _AdditionalMaterialGroup5 1
_CustomerGroup _CustomerGroup 2
_DeliveryPriority _DeliveryPriority 1
_ItemCategory _ItemCategory 2
_Material _Material 2
_MaterialGroup _MaterialGroup 2
_MaterialText _MaterialText 1
_OrderQuantityUnit _OrderQuantityUnit 1
_OriginallyRequestedMaterial _OriginallyRequestedMaterial 1
_Plant _ProductionPlant 1
_Product _Product 2
_ProductGroup _ProductGroup 1
_ProductText _ProductText 1
_ShippingPoint _ShippingPoint 2
_StorageLocation _StorageLocation 1
AdditionalMaterialGroup1 AdditionalMaterialGroup1 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 1
AdditionalMaterialGroup3 AdditionalMaterialGroup3 1
AdditionalMaterialGroup4 AdditionalMaterialGroup4 1
AdditionalMaterialGroup5 AdditionalMaterialGroup5 1
Batch Batch 2
BillOfMaterial BillOfMaterial 1
BOMExplosionDate BOMExplosionDate 1
CreationDate CreationDate 1
CustomerGroup CustomerGroup 3
CustRetItmFollowUpActivity CustRetItmFollowUpActivity 1
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 1
DeliveryGroup DeliveryGroup 1
DeliveryPriority DeliveryPriority 4
DistributionChannel DistributionChannel 2
ExpdDelivQuantityChangeReason ExpdDelivQuantityChangeReason 1
FashionCancelDate FashionCancelDate 5
HigherLevelItem HigherLevelItem 1
InternationalArticleNumber InternationalArticleNumber 1
InventorySpecialStockType InventorySpecialStockType 1
ItemBillingBlockReason ItemBillingBlockReason 1
Material Material,Product 5
MaterialByCustomer MaterialByCustomer 1
MaterialGroup MaterialGroup 4
MRPArea MRPArea 1
NetAmount NetAmount 3
OrderQuantity SalesOrderItemQuantity 1
OrderQuantityUnit ContrItemConsumedQuantityUnit,ContrItemOpenQtyUnit,OrderQuantityUnit 3
OrderRelatedBillingStatus OrderRelatedBillingStatus 1
OriginallyRequestedMaterial OriginallyRequestedMaterial 1
Plant Plant,SupplyingPlant 4
PricingType PricingType 1
ProdAvailabilityCheckGroup ProdAvailabilityCheckGroup 1
Product Product 2
ProductCharacteristic1 ProductCharacteristic1 2
ProductCharacteristic2 ProductCharacteristic2 2
ProductCharacteristic3 ProductCharacteristic3 2
ProductCollection ProductCollection 2
ProductGroup ProductGroup 1
ProductHierarchyNode ProductHierarchyNode 2
ProductSeason ProductSeason 2
ProductSeasonYear ProductSeasonYear 2
ProductTheme ProductTheme 2
ProfitCenter ProfitCenter 2
ReturnReason ReturnReason 1
Route Route 2
SalesDistrict SalesDistrict 1
SalesDocument SlsDoc 2
SalesDocumentItem SlsDocItm 2
SalesDocumentItemCategory SalesDocumentItemCategory 3
SalesDocumentItemText SalesDocumentItemText 7
SalesOrganization SalesOrganization 2
SDDocumentCategory ReferenceSDDocumentCategory,SDDocumentCategory,SlsDocCat 12
ShippingPoint ShippingPoint 4
StorageLocation StorageLocation 4
TaxAmount OpenTotalTaxAmount 1
UnloadingPointName UnloadingPointName 1
WBSElementExternalID WBSElementExternalID 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 _SALESDOCUMENTITEM (
    DIVISION,
    SHIPTOPARTY,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _CUSTOMERGROUP,
    _DELIVERYPRIORITY,
    _ITEMCATEGORY,
    _MATERIAL,
    _MATERIALGROUP,
    _MATERIALTEXT,
    _ORDERQUANTITYUNIT,
    _ORIGINALLYREQUESTEDMATERIAL,
    _PLANT,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTTEXT,
    _SHIPPINGPOINT,
    _STORAGELOCATION,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BATCH,
    BILLOFMATERIAL,
    BOMEXPLOSIONDATE,
    CREATIONDATE,
    CUSTOMERGROUP,
    CUSTRETITMFOLLOWUPACTIVITY,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYGROUP,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNEL,
    EXPDDELIVQUANTITYCHANGEREASON,
    FASHIONCANCELDATE,
    HIGHERLEVELITEM,
    INTERNATIONALARTICLENUMBER,
    INVENTORYSPECIALSTOCKTYPE,
    ITEMBILLINGBLOCKREASON,
    MATERIAL,
    MATERIALBYCUSTOMER,
    MATERIALGROUP,
    MRPAREA,
    NETAMOUNT,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORIGINALLYREQUESTEDMATERIAL,
    PLANT,
    PRICINGTYPE,
    PRODAVAILABILITYCHECKGROUP,
    PRODUCT,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PROFITCENTER,
    RETURNREASON,
    ROUTE,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTEXT,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SHIPPINGPOINT,
    STORAGELOCATION,
    TAXAMOUNT,
    UNLOADINGPOINTNAME,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (DIVISION, SHIPTOPARTY)
);

Learn More