I_SALESDOCUMENTBASIC

CDS View
40 Fields 149 CDS Views

Sales Document Basic

I_SALESDOCUMENTBASIC is a CDS View in S/4HANA. Sales Document Basic. It contains 40 fields. 149 CDS views read from this table.

CDS Views using this table (149)

ViewTypeJoinVDMDescription
A_CrdtMemoReqItemPartnerSimln view_entity inner COMPOSITE Item Partner Simulation
A_CrdtMemoReqItmPrcgElmntSimln view_entity inner COMPOSITE Item Pricing Element Simulation
A_CreditMemoReqItemPartner view inner COMPOSITE Item Partner
A_CreditMemoReqItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_CreditMemoReqItemSimulation view_entity inner COMPOSITE Credit Memo Request Item Simulation
A_CreditMemoReqItemText view inner COMPOSITE Item Text
A_CreditMemoReqPartner view inner COMPOSITE Header Partner
A_CreditMemoReqPartnerSimln view_entity inner COMPOSITE Header Partner Simulation
A_CreditMemoReqPrcgElmnt view inner COMPOSITE Header Pricing Element
A_CreditMemoReqPrcgElmntSimln view_entity inner COMPOSITE Header Pricing Element Simulation
A_CreditMemoReqText view inner COMPOSITE Header Text
A_CustomerReturnItemPartner view inner COMPOSITE Item Partner
A_CustomerReturnItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_CustomerReturnItemSimulation view_entity inner COMPOSITE Returns Order Item Simulation
A_CustomerReturnItemText view inner COMPOSITE Item Text
A_CustomerReturnPartner view inner COMPOSITE Header Partner
A_CustomerReturnPrcgElmnt view inner COMPOSITE Header Pricing Element
A_CustomerReturnText view inner COMPOSITE Header Text
A_CustProjSlsOrdItmPrcgElement view inner COMPOSITE Sales Order Item Pricing Element
A_CustRetItemPartnerSimulation view_entity inner COMPOSITE Item Partner Simulation
A_CustRetItemPrcgElmntSimln view_entity inner COMPOSITE Item Pricing Element Simulation
A_CustRetPartnerSimulation view_entity inner COMPOSITE Header Partner Simulation
A_CustRetPrcgElmntSimulation view_entity inner COMPOSITE Header Pricing Element Simulation
A_DebitMemoReqItemPartner view inner COMPOSITE Item Partner
A_DebitMemoReqItemPartnerSimln view_entity inner COMPOSITE Item Partner Simulation
A_DebitMemoReqItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_DebitMemoReqItemPrgElmSimln view_entity inner COMPOSITE Item Pricing Element Simulation
A_DebitMemoReqItemText view inner COMPOSITE Item Text
A_DebitMemoReqPartner view inner COMPOSITE Header Partner
A_DebitMemoReqPartnerSimln view_entity inner COMPOSITE Header Partner Simulation
A_DebitMemoReqPrcgElmnt view inner COMPOSITE Header Pricing Element
A_DebitMemoReqPrcgElmntSimln view_entity inner COMPOSITE Header Pricing Element Simulation
A_DebitMemoReqText view inner COMPOSITE Header Text
A_SalesContractItemPartner view inner COMPOSITE Item Partner
A_SalesContractItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_SalesContractItemText view inner COMPOSITE Item Text
A_SalesContractPartner view inner COMPOSITE Header Partner
A_SalesContractPrcgElmnt view inner COMPOSITE Header Pricing Element
A_SalesContractText view inner COMPOSITE Header Text
A_SalesInquiryItemPartner view inner COMPOSITE Item Partner
A_SalesInquiryItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_SalesInquiryPartner view inner COMPOSITE Header Partner
A_SalesInquiryPrcgElmnt view inner COMPOSITE Header Pricing Element
A_SalesOrderHeaderPartner view inner COMPOSITE Header Partner
A_SalesOrderHeaderPrElement view inner COMPOSITE Header Pricing Element
A_SalesOrderItemPartner view inner COMPOSITE Item Partner
A_SalesOrderItemPartnerSimln view inner COMPOSITE Sales Order Item Partner Sim (API)
A_SalesOrderItemPrElement view inner COMPOSITE Item Pricing Element
A_SalesOrderItemText view inner COMPOSITE Item Text
A_SalesOrderItmPrcgElmntSimln view inner COMPOSITE Sales Order Item Pricing Elmnt Sim (API)
A_SalesOrderPartnerAddress view_entity inner COMPOSITE Header Partner Address
A_SalesOrderPartnerSimulation view inner COMPOSITE Sales Order Partner Simulation (API)
A_SalesOrderPrcgElmntSimln view inner COMPOSITE Sales Order Pricing Elmnt Sim (API)
A_SalesOrderText view inner COMPOSITE Header Text
A_SalesQuotationItemPartner view inner COMPOSITE Item Partner
A_SalesQuotationItemPrcgElmnt view inner COMPOSITE Item Pricing Element
A_SalesQuotationItemText view inner COMPOSITE Item Text
A_SalesQuotationPartner view inner COMPOSITE Header Partner
A_SalesQuotationPrcgElmnt view inner COMPOSITE Header Pricing Element
A_SalesQuotationText view inner COMPOSITE Header Text
A_SlsOrdPaymentPlanItemDetails view inner COMPOSITE Header Payment Plan
A_SlsOrdWthoutChrgItmPartner view inner COMPOSITE Item Partner
A_SlsOrdWthoutChrgItmText view inner COMPOSITE Item Text
A_SlsOrdWthoutChrgPartner view inner COMPOSITE Header Partner
A_SlsOrdWthoutChrgText view inner COMPOSITE Header Text
C_IncompleteSalesDocByCat view inner CONSUMPTION Incomplete Sales Document by Category
C_RetsRefSlsOrdWthoutChrg view_entity from CONSUMPTION Returns Refer Sales Order Without Charge
C_ReturnsReferenceDocumentItem view inner CONSUMPTION Return Reference Document Item
C_ReturnsReferenceSalesOrder view_entity from CONSUMPTION Returns Reference Sales Order
C_RFM_MngSlsDocHdrIncompltn view inner CONSUMPTION Header Details for Mass Incompletion
C_RFM_MngSlsDocItmIncompltn view inner CONSUMPTION Item Details for Mass Incompletion
C_SalesDocItmPrcgElmntDEX view inner CONSUMPTION Data Extraction for Sales Document Item Pricing Element
C_SalesDocItmPrcgElmntDEX_1 view inner CONSUMPTION Data Extraction for Sales Doc Item Pricing Elements
C_SalesDocumentContactPerson view inner CONSUMPTION Sales Doc w. Cust-Expd Price Cntct Persn
C_SalesManagerSelection view from CONSUMPTION Sales Manager Selection
EWA_ALY_P_SDH view from
I_ACMSalesOrder view from COMPOSITE ACM Sales Order
I_AdvncdReturnsMgmtProcess view inner COMPOSITE Advanced Returns Management Process
I_BlockedSalesOrder view left_outer COMPOSITE Blocked Sales Order
I_CreditBlockedSalesDocument view from COMPOSITE Credit Blocked Sales Document
I_CustRetItemProcessStep view_entity inner COMPOSITE Item Process Steps
I_EWA_SalesDocumentVH view_entity from BASIC Sales Document Values
I_OverdueSalesOrder view left_outer COMPOSITE Overdue Sales Order
I_PrcgCndnMnlAllocTermsSD view_entity from COMPOSITE CPE Terms with manual alloc for SD docs
I_SalesDocItemPricingElement view inner BASIC Sales Document Item Pricing Element
I_SalesDocument view from BASIC Sales Document
I_SalesDocumentItemPartner view inner COMPOSITE Sales Document Item Partner
I_SalesDocumentPartner view inner COMPOSITE Sales Document Partner
I_SalesDocumentPrecdgProcFlow view_entity inner COMPOSITE Preceding Process Flow of Sales Document
I_SalesDocumentPricingElement view inner BASIC Sales Document Pricing Element
I_SalesDocumentRelatedObject view_entity inner BASIC Sales Document Related Object
I_SalesDocumentStandardPartner view from COMPOSITE Sales Document Standard Partner
I_SalesDocumentSubsqntProcFlow view_entity inner COMPOSITE Subsequent Process Flow of Sales Doc
I_SalesOrderInInvcgNotTransfd view inner COMPOSITE SOFM Not Transferred Sales Orders In Invoice
I_SDDocItmReturnedQuantity view inner COMPOSITE Return Quantity Union
I_SlsDocPaymentPlanItemDetails view inner BASIC Sales Document Payment Plan Item Details
I_SlsDocumentItemRelatedObject view_entity inner BASIC Sales Document Item Related Object
P_CreditMemoReqProcFlow0 view from CONSUMPTION
P_CustRetLastModified view from CONSUMPTION
P_CustRetProcFlow0 view from CONSUMPTION
P_CustRetProcFlow04 view from CONSUMPTION
P_DebitMemoReqProcFlow0 view from CONSUMPTION
P_GrantSalesDocumentLink view inner COMPOSITE Private view for Grant & Sales Doc Link
P_Mpsostatus view inner COMPOSITE
P_PL_SAFTDwnPaySalesDocItemTax view inner BASIC
P_RefundedQuantity view inner CONSUMPTION
P_RefundedQuantity_F1708 view inner CONSUMPTION
P_RefundingQuantity view inner CONSUMPTION
P_RefundingQuantity_F1708 view inner CONSUMPTION
P_RevenueRecgnSalesOrderVH view from COMPOSITE
P_RevnRecgnSalesOrderItemVH view inner COMPOSITE
P_RevRecgnSalesOrderItemVH view inner CONSUMPTION
P_RevRecgnSalesOrderVH view from CONSUMPTION
P_SalesDocumentPartnerObsolete view inner BASIC Sls Doc Part - Delaware SLT Data Rplctn
P_SalesOrderInDelivDueDate view inner COMPOSITE
P_SalesOrderInDelivItmDueDate view inner COMPOSITE
P_SalesOrderInSupplyMfgIssue1 view inner COMPOSITE
P_SalesSchedgAgrmtProcFlow0 view from CONSUMPTION
P_SalesSchedgAgrmtProcFlow05 view left_outer CONSUMPTION
P_SdPricingPrcd view from COMPOSITE
P_SlsOrdBillingPlanDueDate view from COMPOSITE
P_SlsOrdBillingPlanDueDate2 view from COMPOSITE
P_SlsOrdDelivdDueDte view from COMPOSITE
P_SlsOrdDelivdDueDte2 view from COMPOSITE
P_SlsOrderInSupplyPurgIssue3 view inner COMPOSITE
P_SlsOrdFlfmt1stLvlSDProcSqnc2 view left_outer CONSUMPTION
P_SlsOrdFlfmtProcHierNode2 view union_all CONSUMPTION
P_SlsOrdFlfmtSupProcSqnc view inner CONSUMPTION
P_SlsOrdNotDelivdDueDte view from COMPOSITE
P_SlsOrdNotDelivdDueDte2 view from COMPOSITE
P_SlsOrdOrdReltdBillgDueDte view from COMPOSITE
P_SlsOrdOrdReltdBillgDueDte2 view from COMPOSITE
P_SlsQtanProcFlow0 view from CONSUMPTION
R_CreditMemoReqItemPartnerTP view_entity inner TRANSACTIONAL Credit Memo Request Item Partner - TP
R_CreditMemoRequestTextTP view_entity inner TRANSACTIONAL Credit Memo Request - Text TP
R_CustomerReturnItemPartnerTP view_entity inner TRANSACTIONAL Returns Order Item Partner - TP
R_CustomerReturnPrgElmTP view_entity inner TRANSACTIONAL Returns Order Pricing Element - TP
R_CustomerReturnTextTP view_entity inner TRANSACTIONAL Returns Order - Text TP
R_CustRetItemPricingElementTP view_entity inner TRANSACTIONAL Pricing Element for Returns Order Item - TP
R_DebitMemoReqItemPartnerTP view_entity inner TRANSACTIONAL Debit Memo Request Item Partner - TP
R_DebitMemoRequestTextTP view_entity inner TRANSACTIONAL Debit Memo Request - Text TP
R_SalesContractItemPartnerTP view_entity inner TRANSACTIONAL Sales Contract Item Partner - TP
R_SalesContractTextTP view_entity inner TRANSACTIONAL Sales Contract - Text TP
R_SalesOrderItemPartnerTP view_entity inner TRANSACTIONAL Partner for Sales Order Item - TP
R_SalesOrderTextTP view_entity inner TRANSACTIONAL Sales Order - Text TP
R_SalesQuotationItemPartnerTP view_entity inner TRANSACTIONAL Sales Quotation Item Partner - TP
R_SalesQuotationTextTP view_entity inner TRANSACTIONAL Sales Quotation - Text TP
R_SlsSchedgAgrmtItemPartnerTP view_entity inner TRANSACTIONAL Partner for Sls Sched Agr Item - TP
R_SlsSchedgAgrmtTextTP view_entity inner TRANSACTIONAL Sales Scheduling Agreement - Text TP

Fields (40)

KeyField CDS FieldsUsed in Views
KEY SalesDocument CreditMemoRequest,CustomerReturn,DebitMemoRequest,Level1Document,SalesDocument,SalesInquiry,SalesOrder,SalesQuotation 44
KEY SalesDocumentCondition SalesDocumentCondition 1
KEY SDDocumentCategory Level1DocumentCategory,SalesDocumentCategory,SalesOrderCategory,SDDocumentCategory 16
_DistributionChannel _DistributionChannel 2
_OrganizationDivision _OrganizationDivision 2
_SalesGroup _SalesGroup 2
_SalesOffice _SalesOffice 2
_SalesOrganization _SalesOrganization 2
_SDDocumentCategory _SDDocumentCategory 4
_SoldToParty _SoldToParty 2
AdditionalCustomerGroup1 AdditionalCustomerGroup1 2
AdditionalCustomerGroup2 AdditionalCustomerGroup2 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 2
AdditionalCustomerGroup4 AdditionalCustomerGroup4 2
AdditionalCustomerGroup5 AdditionalCustomerGroup5 2
BillingCompanyCode BillingCompanyCode 2
ControllingArea ControllingArea 2
CostCenter CostCenter 2
DeliveryBlockReason DeliveryBlockReason 1
DistributionChannel DistributionChannel 103
ExchangeRateType ExchangeRateType 2
HeaderBillingBlockReason HeaderBillingBlockReason 8
OrganizationDivision OrganizationDivision 103
OverallBillingBlockStatus OverallBillingBlockStatus 6
OverallDeliveryBlockStatus OverallDeliveryBlockStatus 1
OverallSDProcessStatus OverallSDProcessStatus 11
RequestedDeliveryDate DeliveryDate,RequestedDeliveryDate 10
RetsMgmtProcess RetsMgmtProcess 2
SalesDocumentDate SalesDocumentDate 11
SalesDocumentProcessingType SalesDocumentProcessingType 1
SalesDocumentType CreditMemoRequestType,CustomerReturnType,DebitMemoRequestType,SalesContractType,SalesDocumentType,SalesInquiryType,SalesOrderType,SalesOrderWithoutChargeType,SalesQuotationType 96
SalesGroup SalesGroup 15
SalesOffice SalesOffice 15
SalesOrganization SalesOrganization 103
SDDocumentReason SDDocumentReason 2
SDPricingProcedure SDPricingProcedure 1
SoldToParty SoldToParty 17
StatisticsCurrency StatisticsCurrency 2
TotalNetAmount TotalNetAmount 1
TransactionCurrency TransactionCurrency 2

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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTBASIC (
    SALESDOCUMENT,
    SALESDOCUMENTCONDITION,
    SDDOCUMENTCATEGORY,
    _DISTRIBUTIONCHANNEL,
    _ORGANIZATIONDIVISION,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SOLDTOPARTY,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    BILLINGCOMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    DELIVERYBLOCKREASON,
    DISTRIBUTIONCHANNEL,
    EXCHANGERATETYPE,
    HEADERBILLINGBLOCKREASON,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLDELIVERYBLOCKSTATUS,
    OVERALLSDPROCESSSTATUS,
    REQUESTEDDELIVERYDATE,
    RETSMGMTPROCESS,
    SALESDOCUMENTDATE,
    SALESDOCUMENTPROCESSINGTYPE,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SOLDTOPARTY,
    STATISTICSCURRENCY,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESDOCUMENT, SALESDOCUMENTCONDITION, SDDOCUMENTCATEGORY)
);

Learn More