P_SLSDOCITMBSCDATA

CDS View

P_SLSDOCITMBSCDATA is a CDS View in S/4HANA. It contains 104 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SLSQTANPRDTVBSCDATA view from COMPOSITE
P_SlsQtanPrdtvTrngBscData view from COMPOSITE

Fields (104)

KeyField CDS FieldsUsed in Views
_BaseUnit _BaseUnit 2
_BillingBlockStatus _BillingBlockStatus 2
_CreatedByUser _CreatedByUser 2
_DeliveryBlockStatus _DeliveryBlockStatus 2
_DeliveryConfirmationStatus _DeliveryConfirmationStatus 2
_DeliveryStatus _DeliveryStatus 2
_DistributionChannel _DistributionChannel 2
_Division _Division 2
_ItemBillingIncompletionStatus _ItemBillingIncompletionStatus 2
_ItemCategory _ItemCategory 2
_ItemDelivIncompletionSts _ItemDelivIncompletionSts 2
_ItemGeneralIncompletionStatus _ItemGeneralIncompletionStatus 2
_ItemVolumeUnit _ItemVolumeUnit 2
_ItemWeightUnit _ItemWeightUnit 2
_Material _Material 2
_MaterialGroup _MaterialGroup 2
_NetPriceQuantityUnit _NetPriceQuantityUnit 2
_OrderRelatedBillingStatus _OrderRelatedBillingStatus 2
_OrganizationDivision _OrganizationDivision 2
_OriginallyRequestedMaterial _OriginallyRequestedMaterial 2
_OverallSDDocReferenceStatus _OverallSDDocReferenceStatus 2
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 2
_OverallSDProcessStatus _OverallSDProcessStatus 2
_PricingIncompletionStatus _PricingIncompletionStatus 2
_PurchaseConfirmationStatus _PurchaseConfirmationStatus 2
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 2
_SalesGroup _SalesGroup 2
_SalesOffice _SalesOffice 2
_SalesOrganization _SalesOrganization 2
_SDDocumentReason _SDDocumentReason 2
_SDProcessStatus _SDProcessStatus 2
_SoldToParty _SoldToParty 2
_StatisticalValueControl _StatisticalValueControl 2
_TotalDeliveryStatus _TotalDeliveryStatus 2
_TotalSDDocReferenceStatus _TotalSDDocReferenceStatus 2
_TransactionCurrency _TransactionCurrency 2
BaseUnit BaseUnit 2
BillingBlockStatus BillingBlockStatus 2
BillToParty BillToParty 2
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 2
BindingPeriodValidityStartDate BindingPeriodValidityStartDate 2
CnvrtdSalesQuotationNetAmount CnvrtdSalesQuotationNetAmount 2
CnvrtdSalesQuotationQuantity CnvrtdSalesQuotationQuantity 2
ControllingObject ControllingObject 2
CostAmount CostAmount 2
CreatedByUser ItemCreatedByUser 2
CreationDate ItemCreationDate 2
DeliveryBlockStatus DeliveryBlockStatus 2
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 2
DeliveryStatus DeliveryStatus 2
DistributionChannel DistributionChannel 2
Division Division 2
HigherLevelItem HigherLevelItem 2
InventorySpecialStockType InventorySpecialStockType 2
ItemGrossWeight ItemGrossWeight 2
ItemNetWeight ItemNetWeight 2
ItemVolume ItemVolume 2
ItemVolumeUnit ItemVolumeUnit 2
ItemWeightUnit ItemWeightUnit 2
LastChangeDate ItemLastChangeDate 2
Material Material 2
MaterialGroup MaterialGroup 2
NetAmount NetAmount 2
NetPriceAmount NetPriceAmount 2
NetPriceQuantity NetPriceQuantity 2
NetPriceQuantityUnit NetPriceQuantityUnit 2
OrderRelatedBillingStatus OrderRelatedBillingStatus 2
OriginallyRequestedMaterial OriginallyRequestedMaterial 2
OriginSDDocument OriginSDDocument 2
OriginSDDocumentItem OriginSDDocumentItem 2
OutlineAgreementTargetAmount OutlineAgreementTargetAmount 2
PayerParty PayerParty 2
ProfitabilitySegment ProfitabilitySegment 2
ProfitCenter ProfitCenter 2
ReferenceSDDocumentCategory ItemRefSDDocumentCategory 2
ReferenceSDDocumentItem SalesInquiryItem 2
ResponsibleEmployee ResponsibleEmployeePersonnelID 2
SalesDocumentItemCategory SalesQuotationItemCategory 2
SalesDocumentItemText SalesQuotationItemText 2
SalesDocumentItemType SalesQuotationItemType 2
SalesDocumentRjcnReason SalesDocumentRjcnReason 2
SalesDocumentType SalesQuotationType 2
SalesEmployee SalesEmployeePersonnelID 2
SalesGroup SalesGroup 2
SalesOffice SalesOffice 2
SalesOrganization SalesOrganization 2
SalesQuotationNetAmount SalesQuotationNetAmount 2
SalesQuotationQuantity SalesQuotationQuantity 2
SDDocumentReason SDDocumentReason 2
ShipToParty ShipToParty 2
SlsQtanToOrdProbltyInPercent SlsQtanToOrdProbltyInPercent 2
SoldToParty SoldToParty 2
StatisticalValueControl StatisticalValueControl 2
Subtotal1Amount Subtotal1Amount 2
Subtotal2Amount Subtotal2Amount 2
Subtotal3Amount Subtotal3Amount 2
Subtotal4Amount Subtotal4Amount 2
Subtotal5Amount Subtotal5Amount 2
Subtotal6Amount Subtotal6Amount 2
TaxAmount TaxAmount 2
TotalDeliveryStatus TotalDeliveryStatus 2
TotalSDDocReferenceStatus TotalSDDocReferenceStatus 2
TransactionCurrency ItemTransactionCurrency 2
WBSElement WBSElement 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SLSDOCITMBSCDATA (
    _BASEUNIT,
    _BILLINGBLOCKSTATUS,
    _CREATEDBYUSER,
    _DELIVERYBLOCKSTATUS,
    _DELIVERYCONFIRMATIONSTATUS,
    _DELIVERYSTATUS,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _ITEMBILLINGINCOMPLETIONSTATUS,
    _ITEMCATEGORY,
    _ITEMDELIVINCOMPLETIONSTS,
    _ITEMGENERALINCOMPLETIONSTATUS,
    _ITEMVOLUMEUNIT,
    _ITEMWEIGHTUNIT,
    _MATERIAL,
    _MATERIALGROUP,
    _NETPRICEQUANTITYUNIT,
    _ORDERRELATEDBILLINGSTATUS,
    _ORGANIZATIONDIVISION,
    _ORIGINALLYREQUESTEDMATERIAL,
    _OVERALLSDDOCREFERENCESTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _PRICINGINCOMPLETIONSTATUS,
    _PURCHASECONFIRMATIONSTATUS,
    _SALESDOCUMENTRJCNREASON,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SDDOCUMENTREASON,
    _SDPROCESSSTATUS,
    _SOLDTOPARTY,
    _STATISTICALVALUECONTROL,
    _TOTALDELIVERYSTATUS,
    _TOTALSDDOCREFERENCESTATUS,
    _TRANSACTIONCURRENCY,
    BASEUNIT,
    BILLINGBLOCKSTATUS,
    BILLTOPARTY,
    BINDINGPERIODVALIDITYENDDATE,
    BINDINGPERIODVALIDITYSTARTDATE,
    CNVRTDSALESQUOTATIONNETAMOUNT,
    CNVRTDSALESQUOTATIONQUANTITY,
    CONTROLLINGOBJECT,
    COSTAMOUNT,
    CREATEDBYUSER,
    CREATIONDATE,
    DELIVERYBLOCKSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYSTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    HIGHERLEVELITEM,
    INVENTORYSPECIALSTOCKTYPE,
    ITEMGROSSWEIGHT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    LASTCHANGEDATE,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NETPRICEQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORIGINALLYREQUESTEDMATERIAL,
    ORIGINSDDOCUMENT,
    ORIGINSDDOCUMENTITEM,
    OUTLINEAGREEMENTTARGETAMOUNT,
    PAYERPARTY,
    PROFITABILITYSEGMENT,
    PROFITCENTER,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    RESPONSIBLEEMPLOYEE,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTEXT,
    SALESDOCUMENTITEMTYPE,
    SALESDOCUMENTRJCNREASON,
    SALESDOCUMENTTYPE,
    SALESEMPLOYEE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SALESQUOTATIONNETAMOUNT,
    SALESQUOTATIONQUANTITY,
    SDDOCUMENTREASON,
    SHIPTOPARTY,
    SLSQTANTOORDPROBLTYINPERCENT,
    SOLDTOPARTY,
    STATISTICALVALUECONTROL,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    TAXAMOUNT,
    TOTALDELIVERYSTATUS,
    TOTALSDDOCREFERENCESTATUS,
    TRANSACTIONCURRENCY,
    WBSELEMENT
);