P_SLSDOCITMBSCDATA
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SLSQTANPRDTVBSCDATA | view | from | COMPOSITE | |
| P_SlsQtanPrdtvTrngBscData | view | from | COMPOSITE |
Fields (104)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA