C

C is an SAP database table in S/4HANA. It contains 52 fields.

Fields (52)

KeyField CDS FieldsUsed 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)
);