Fields (52)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | bukrs | CompanyCode | 1 |
| KEY | locid | locid | 1 |
| KEY | OutputChannel | OutputChannel | 1 |
| KEY | PL_GoodsMovementTypeCategory | PL_GoodsMovementTypeCategory | 1 |
| KEY | SalesDocument | SalesOrder | 1 |
| KEY | schema_id | SchemaId | 1 |
| _Text | _Text | 1 | |
| AccountIsMarkedForDeletion | AccountIsMarkedForDeletion | 1 | |
| adapter_class | adapter_class | 1 | |
| AmountInBankAccountCurrency | BankAcctBalanceAmt | 1 | |
| appltab_name | AppltabName | 1 | |
| BankAccountCurrency | BankAccountCurrency | 1 | |
| BankReconciliationAccount | BankReconciliationAccount | 1 | |
| BatchUUID | BatchUUID | 1 | |
| bttype | bttype | 1 | |
| CommodityUnit | CommodityUnit | 1 | |
| CorporateGroupAccount | CorporateGroupAccount | 1 | |
| Customer | customernumber | 1 | |
| DisplayItem | CumItem | 1 | |
| fiscal_period_start_date | budat | 1 | |
| GLAccountExternal | GLAccountExternal | 1 | |
| GLAccountGroup | GLAccountGroup | 1 | |
| GLAccountSubtype | GLAccountSubtype | 1 | |
| GLAccountType | GLAccountType | 1 | |
| kw_link | kw_link | 1 | |
| Material | Material | 2 | |
| migr_object | migr_object | 1 | |
| migr_object_type | migr_object_type | 1 | |
| mstr_logtab_name | MstrLogtabName | 1 | |
| name1 | rcomp_unitName | 1 | |
| OrganizationBPName1 | customername | 1 | |
| param_variant_id | variant_id | 1 | |
| PaymentBatch | PaymentBatch | 1 | |
| PaymentBatchItemCurrentStatus | Status | 1 | |
| pegid | pegid | 2 | |
| pegtype | pegtype | 2 | |
| PlannedExpenseCost | PlannedExpenseCost | 1 | |
| PlannedExpenseRevenue | PlannedExpenseRevenue | 1 | |
| Plant | Plant | 2 | |
| ProfitLossAccountType | ProfitLossAccountType | 1 | |
| rcomp | rcomp | 1 | |
| RemainingDemandCostAmt | RemainingDemandCostAmt | 1 | |
| RemainingDemandEffortQty | RemainingDemandEffortQty | 1 | |
| RemainingDemandRevnAmt | RemainingDemandRevnAmt | 1 | |
| sortorder | sortorder | 1 | |
| SourceReplenishmentElement | SourceReplenishmentElement | 1 | |
| StorageLocation | StorageLocation | 2 | |
| SupplyCostAmt | SupplyCostAmt | 1 | |
| SupplyEffortQty | SupplyEffortQty | 1 | |
| SupplyRevnAmt | SupplyRevnAmt | 1 | |
| UserID | UserID | 3 | |
| validation_class | validation_class | 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 C (
BUKRS,
LOCID,
OUTPUTCHANNEL,
PL_GOODSMOVEMENTTYPECATEGORY,
SALESDOCUMENT,
SCHEMA_ID,
_TEXT,
ACCOUNTISMARKEDFORDELETION,
ADAPTER_CLASS,
AMOUNTINBANKACCOUNTCURRENCY,
APPLTAB_NAME,
BANKACCOUNTCURRENCY,
BANKRECONCILIATIONACCOUNT,
BATCHUUID,
BTTYPE,
COMMODITYUNIT,
CORPORATEGROUPACCOUNT,
CUSTOMER,
DISPLAYITEM,
FISCAL_PERIOD_START_DATE,
GLACCOUNTEXTERNAL,
GLACCOUNTGROUP,
GLACCOUNTSUBTYPE,
GLACCOUNTTYPE,
KW_LINK,
MATERIAL,
MIGR_OBJECT,
MIGR_OBJECT_TYPE,
MSTR_LOGTAB_NAME,
NAME1,
ORGANIZATIONBPNAME1,
PARAM_VARIANT_ID,
PAYMENTBATCH,
PAYMENTBATCHITEMCURRENTSTATUS,
PEGID,
PEGTYPE,
PLANNEDEXPENSECOST,
PLANNEDEXPENSEREVENUE,
PLANT,
PROFITLOSSACCOUNTTYPE,
RCOMP,
REMAININGDEMANDCOSTAMT,
REMAININGDEMANDEFFORTQTY,
REMAININGDEMANDREVNAMT,
SORTORDER,
SOURCEREPLENISHMENTELEMENT,
STORAGELOCATION,
SUPPLYCOSTAMT,
SUPPLYEFFORTQTY,
SUPPLYREVNAMT,
USERID,
VALIDATION_CLASS,
PRIMARY KEY (BUKRS, LOCID, OUTPUTCHANNEL, PL_GOODSMOVEMENTTYPECATEGORY, SALESDOCUMENT, SCHEMA_ID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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