I_SALESDOCUMENTITEMBASIC

CDS View
50 Fields 47 CDS Views

Sales Document Item Basic

I_SALESDOCUMENTITEMBASIC is a CDS View in S/4HANA. Sales Document Item Basic. It contains 50 fields. 47 CDS views read from this table.

CDS Views using this table (47)

ViewTypeJoinVDMDescription
A_SalesOrderItemPartnerAddress view_entity inner COMPOSITE Item Partner Address
C_ExchSalesContrItemSchedgKPI view from CONSUMPTION Exchange Sales Contract Item Scheduling for KPI
C_RetsReferenceSalesOrderItem view_entity from CONSUMPTION Returns Reference Sales Order Item
C_SlsDocItemSupplyIssue view from CONSUMPTION Sales Doc Item Supply Issue
I_AlignSlsOrdHdrItm view from COMPOSITE Sales Order Header Item
I_ComplaintProcessFlowStatus view_entity from COMPOSITE Complaint Process Flow Status
I_SalesDocItmPrecdgProcFlow view_entity inner COMPOSITE Preceding Process Flow of Sales Doc Item
I_SalesDocItmReturnableQty view from COMPOSITE Returnable Quantity of Sales
I_SalesDocItmSubsqntProcFlow view_entity inner COMPOSITE Subsequent Process Flow of Sls Doc Item
I_SalesDocumentItemPartner view inner COMPOSITE Sales Document Item Partner
I_SDDocItmReturnedQuantity view from COMPOSITE Return Quantity Union
I_SDDocItmReturnedQuantity view inner COMPOSITE Return Quantity Union
I_SDDocItmReturnedQuantity view union_all COMPOSITE Return Quantity Union
I_SlsDocumentItemRelatedObject view_entity inner BASIC Sales Document Item Related Object
P_ConfignOvwPgSalesDocItem view from CONSUMPTION
P_EngmntProjReviewData view left_outer COMPOSITE
P_EvtBsdRevnRecgnProjWipJrnAmt view inner COMPOSITE
P_RefundedQuantity view inner CONSUMPTION
P_RefundedQuantity view from CONSUMPTION
P_RefundedQuantity_F1708 view from CONSUMPTION
P_RefundedQuantity_F1708 view union_all CONSUMPTION
P_RefundedQuantity_F1708 view inner CONSUMPTION
P_RefundingQuantity view from CONSUMPTION
P_RefundingQuantity_F1708 view from CONSUMPTION
P_SalesDocumentItemCount view from CONSUMPTION Number of Sales Document Items
P_SalesDocumentItemFulfillmnt4 view from COMPOSITE
P_SalesOrderInSupplyPurgIssue1 view inner COMPOSITE
P_SalesOrderInSupplyPurgIssue4 view inner COMPOSITE
P_SDDocumentTotalItems view from CONSUMPTION
P_SlsDocFlfmtTotalAmount1 view from CONSUMPTION Total Amount on Item Level
P_SlsOrdBillingPlanDueDate2 view inner COMPOSITE
P_SlsOrderInSupplyPurgIssue3 view inner COMPOSITE
P_SlsOrdItmBillgPlanDueDte2 view from COMPOSITE
P_SlsOrdItmDelivdDueDte view from COMPOSITE
P_SlsOrdItmDelivdDueDte2 view from COMPOSITE
P_SlsOrdItmNotDelivdDueDte view from COMPOSITE
P_SlsOrdItmNotDelivdDueDte2 view from COMPOSITE
P_SlsOrdItmOrdReltdBillgDue2 view from COMPOSITE
P_SlsOrdOrdReltdBillgDueDte2 view inner COMPOSITE
P_SlsOrdProcFlow24 view inner CONSUMPTION Sales Order Process Flow: Level +2 Intercompany Sales Order
R_CreditMemoRequestItemTextTP view_entity inner TRANSACTIONAL Credit Memo Request Item - Text TP
R_CustomerReturnItemTextTP view_entity inner TRANSACTIONAL Returns Order Item - Text TP
R_DebitMemoRequestItemTextTP view_entity inner TRANSACTIONAL Debit Memo Request Item - Text TP
R_SalesContractItemTextTP view_entity inner TRANSACTIONAL Sales Contract Item - Text TP
R_SalesOrderItemTextTP view_entity inner TRANSACTIONAL Sales Order Item - Text TP
R_SalesQuotationItemTextTP view_entity inner TRANSACTIONAL Sales Quotation Item - Text TP
R_SlsSchedgAgrmtItemTextTP view_entity inner TRANSACTIONAL Sls Schedg Agrmt Item - Text TP

Fields (50)

KeyField CDS FieldsUsed in Views
KEY SalesDocument CustomerReturn,DocumentCount,Level2Document,ReferenceDocument,SalesDocument,SalesOrder 22
KEY SalesDocumentItem CustomerReturnItem,DocumentItemNumber,Level2DocumentItem,SalesDocumentItem,SalesOrderItem 20
KEY SalesDocumentItemCategory SalesDocumentItemCategory 5
BaseUnit BaseUnit,ReturnBaseUnit 1
Batch Batch 1
BillingBlockStatus BillingBlockStatus 5
ConfdDelivQtyInOrderQtyUnit ConfdDelivQtyInOrderQtyUnit 1
DeliveryBlockStatus DeliveryBlockStatus 1
DeliveryStatus DeliveryStatus 1
DistributionChannel DistributionChannel 14
HigherLevelItem HigherLevelItem 1
ItemBillingBlockReason ItemBillingBlockReason 5
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus 1
ItemIsBillingRelevant ItemIsBillingRelevant 3
Material Material 1
MaterialByCustomer MaterialByCustomer 1
NetAmount NetAmount,TotalNetAmount 3
OrderQuantity OrderQuantity,ReturnQuantity 3
OrderQuantityUnit OrderQuantityUnit,ReturnQuantityUnit 5
OrderRelatedBillingStatus OrderRelatedBillingStatus 3
OrderToBaseQuantityDnmntr OrderToBaseQuantityDnmntr 1
OrderToBaseQuantityNmrtr OrderToBaseQuantityNmrtr 1
OrganizationDivision OrganizationDivision 14
Plant Plant 1
Product Product 2
ProductConfiguration ProductConfiguration 1
ProductGroup ProductGroup 1
PurchaseConfirmationStatus PurchaseConfirmationStatus 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
RequestedDeliveryDate RequestedDeliveryDate 4
RequestedQuantity RequestedQuantity 1
RequestedQuantityInBaseUnit RefundedQuantityInBaseUnit 2
RequestedQuantityUnit RequestedQuantityUnit 1
SalesDocumentDate SalesDocumentDate 1
SalesDocumentItemText SalesDocumentItemText 3
SalesDocumentRjcnReason SalesDocumentRjcnReason 1
SalesDocumentType CreditMemoRequestType,CustomerReturnType,DebitMemoRequestType,SalesContractType,SalesDocumentType,SalesOrderType,SalesQuotationType,SalesSchedgAgrmtType 13
SalesGroup SalesGroup 4
SalesOffice SalesOffice 4
SalesOrganization SalesOrganization 14
SDDocumentCategory SDDocumentCategory 1
SDDocumentRejectionStatus SDDocumentRejectionStatus 3
SDProcessStatus SDProcessStatus 1
SoldToParty SoldToParty 4
TargetQuantity CustReturnItmRefundedQty 1
TargetQuantityUnit RefundedQuantityUnit 2
TotalDeliveryStatus TotalDeliveryStatus 2
TransactionCurrency TransactionCurrency 3
TrdCmplncEmbargoSts TrdCmplncEmbargoSts 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 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.

-- Sales Document Item Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTITEMBASIC (
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    BASEUNIT,
    BATCH,
    BILLINGBLOCKSTATUS,
    CONFDDELIVQTYINORDERQTYUNIT,
    DELIVERYBLOCKSTATUS,
    DELIVERYSTATUS,
    DISTRIBUTIONCHANNEL,
    HIGHERLEVELITEM,
    ITEMBILLINGBLOCKREASON,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMISBILLINGRELEVANT,
    MATERIAL,
    MATERIALBYCUSTOMER,
    NETAMOUNT,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORDERTOBASEQUANTITYDNMNTR,
    ORDERTOBASEQUANTITYNMRTR,
    ORGANIZATIONDIVISION,
    PLANT,
    PRODUCT,
    PRODUCTCONFIGURATION,
    PRODUCTGROUP,
    PURCHASECONFIRMATIONSTATUS,
    REFERENCESDDOCUMENTCATEGORY,
    REQUESTEDDELIVERYDATE,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYINBASEUNIT,
    REQUESTEDQUANTITYUNIT,
    SALESDOCUMENTDATE,
    SALESDOCUMENTITEMTEXT,
    SALESDOCUMENTRJCNREASON,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREJECTIONSTATUS,
    SDPROCESSSTATUS,
    SOLDTOPARTY,
    TARGETQUANTITY,
    TARGETQUANTITYUNIT,
    TOTALDELIVERYSTATUS,
    TRANSACTIONCURRENCY,
    TRDCMPLNCEMBARGOSTS,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    PRIMARY KEY (SALESDOCUMENT, SALESDOCUMENTITEM, SALESDOCUMENTITEMCATEGORY)
);

Learn More