Fields (161)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CN_GoldenTaxCombinationID | CN_GoldenTaxCombinationID | 2 |
| KEY | CN_GoldenTaxDocument | CN_GoldenTaxDocument | 2 |
| KEY | CnsldtnPostingRuleLogUUID | CnsldtnPostingRuleLogUUID | 1 |
| KEY | EWMWarehouse | EWMWarehouse | 1 |
| KEY | HandlingUnitNumber | HandlingUnitNumber | 1 |
| KEY | MaterialDocument | MaterialDocument | 1 |
| KEY | MaterialDocumentYear | MaterialDocumentYear | 1 |
| KEY | ReferenceDocumentContext | ReferenceDocumentContext | 4 |
| KEY | ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | 4 |
| KEY | ReferenceDocumentType | ReferenceDocumentType | 8 |
| KEY | SalesOrder | SalesOrder | 1 |
| AbsoluteExchangeRate | AbsoluteExchangeRate | 3 | |
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | 1 | |
| AccountingDocument | AccountingDocument | 1 | |
| AccountingDocumentCategory | AccountingDocumentCategory | 3 | |
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | 4 | |
| AccountingDocumentType | AccountingDocumentType | 3 | |
| AlternativeReferenceDocument | AlternativeReferenceDocument | 3 | |
| blart | EarmarkedFundsDocumentType | 1 | |
| bltyp | EarmarkedFundsDocumentCategory | 1 | |
| budat | PostingDate | 1 | |
| bukrs | CompanyCode | 1 | |
| CAAuthorizationGroup | CAAuthorizationGroup | 1 | |
| CapacityLastChangeDateTime | CapacityLastChangeDateTime | 1 | |
| CAReversalDocumentNumber | CAReversalDocumentNumber | 1 | |
| CAStandardCompanyCode | CAStandardCompanyCode | 1 | |
| ChangeDocChangeType | ChangeDocChangeType | 3 | |
| ChangeDocLanguage | ChangeDocLanguage | 3 | |
| ChangeHistoryCount | ChangeHistoryCount | 1 | |
| ChangeTransactionCode | ChangeTransactionCode | 3 | |
| check_category | check_category | 1 | |
| CmmdtyExpnCallingApplication | CmmdtyExpnCallingApplication | 1 | |
| CombinedAcctStatusText | CombinedAcctStatusText | 1 | |
| CombinedAcctStsCritlty | CombinedAcctStsCritlty | 1 | |
| CombinedHdrStatusText | CombinedHdrStatusText | 1 | |
| CombinedHdrStsCritlty | CombinedHdrStsCritlty | 1 | |
| CombinedMktgStatusCritlty | CombinedMktgStatusCritlty | 1 | |
| CombinedMktgStatusText | CombinedMktgStatusText | 1 | |
| CombinedOwnrStatusText | CombinedOwnrStatusText | 1 | |
| CombinedOwnrStsCritlty | CombinedOwnrStsCritlty | 1 | |
| CombinedTaxStatusText | CombinedTaxStatusText | 1 | |
| CombinedTaxStsCritlty | CombinedTaxStsCritlty | 1 | |
| CompanyCode | CompanyCode,CompanyCodeForEdit | 12 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ConsolidationChartOfAccounts | ConsolidationChartOfAccounts | 1 | |
| ConsolidationGroup | ConsolidationGroup | 1 | |
| ConsolidationTask | ConsolidationTask | 1 | |
| ConsolidationTaskRunIsTest | ConsolidationTaskRunIsTest | 1 | |
| ConsolidationTaskType | ConsolidationTaskType | 1 | |
| ConsolidationVersion | ConsolidationVersion | 1 | |
| context_suplr_cat | RespyMgmtRespyCntxtSupplierCat | 1 | |
| contexttype | ResponsibilityContextType | 1 | |
| ControllingAreaForEdit | ControllingAreaForEdit | 1 | |
| CreatedByUser | CreatedByUser | 30 | |
| CreationDate | CreationDate | 24 | |
| CreationDateTime | CreationDateTime | 1 | |
| CreationTime | CreationTime | 6 | |
| Currency | Currency,TransactionCurrency | 4 | |
| CurrencyIsHidden | CurrencyIsHidden | 1 | |
| Customer | SoldToParty | 1 | |
| CustomsDeclarationDate | CustomsDeclarationDate,ForEditCustomsDeclarationDate | 1 | |
| DataController1 | DataController1 | 1 | |
| DataController10 | DataController10 | 1 | |
| DataController2 | DataController2 | 1 | |
| DataController3 | DataController3 | 1 | |
| DataController4 | DataController4 | 1 | |
| DataController5 | DataController5 | 1 | |
| DataController6 | DataController6 | 1 | |
| DataController7 | DataController7 | 1 | |
| DataController8 | DataController8 | 1 | |
| DataController9 | DataController9 | 1 | |
| DataControllerSet | DataControllerSet | 1 | |
| DeliveryNetworkName | DeliveryNetworkName | 5 | |
| DocumentDate | DocumentDate | 7 | |
| DocumentReferenceID | DocumentReferenceID | 3 | |
| ExchangeRateDate | ExchangeRateDate | 1 | |
| ExchangeRateType | ExchangeRateType | 2 | |
| fikrs | FinancialManagementArea | 1 | |
| FiscalPeriod | FiscalPeriod | 4 | |
| FiscalYear | FiscalYear | 1 | |
| FiscalYearForEdit | FiscalYearForEdit | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| GoodsMovementCode | GoodsMovementCode | 1 | |
| GrantCurrency | GrantCurrency | 3 | |
| GranteeMgmtApprovalDate | GranteeMgmtApprovalDate | 3 | |
| GranteeMgmtApprovalTime | GranteeMgmtApprovalTime | 3 | |
| GranteeMgmtBudgetingProcess | GranteeMgmtBudgetingProcess | 3 | |
| GranteeMgmtBudgetReason | GranteeMgmtBudgetReason | 3 | |
| GranteeMgmtBudgetStatus | GranteeMgmtBudgetStatus | 3 | |
| GranteeMgmtBudgetVersion | GranteeMgmtBudgetVersion | 3 | |
| GranteeMgmtBudgetVersionOrigin | GranteeMgmtBudgetVersionOrigin | 3 | |
| GranteeMgmtWorkflowStatus | GranteeMgmtWorkflowStatus | 3 | |
| GrantID | GrantID | 3 | |
| GteeMBdgtEntryDocRvslStatus | GteeMBdgtEntryDocRvslStatus | 3 | |
| GteeMBudgetEntryDocOrigin | GteeMBudgetEntryDocOrigin | 3 | |
| GteeMBudgetEntryDocStatus | GteeMBudgetEntryDocStatus | 3 | |
| GteeMBudgetEntryDocumentDesc | GteeMBudgetEntryDocumentDesc | 3 | |
| GteeMBudgetEntryDocumentType | GteeMBudgetEntryDocumentType | 3 | |
| GteeMRvslRefBudgetEntryDoc | GteeMRvslRefBudgetEntryDoc | 3 | |
| hwaer | CompanyCodeCurrency | 1 | |
| IncotermsVersion | IncotermsVersion | 2 | |
| InventoryTransactionType | InventoryTransactionType | 1 | |
| InvtryMgmtReferenceDocument | ReferenceDocument | 1 | |
| IsReversal | IsReversal | 3 | |
| IsReversed | IsReversed | 3 | |
| IsSettled | IsSettled | 1 | |
| kokrs | ControllingArea | 1 | |
| LedgerGroup | LedgerGroup | 3 | |
| LocalCurrency | LocalCurrency | 2 | |
| Lockbox | Lockbox | 1 | |
| LogicalSystem | LogicalSystem | 3 | |
| MasterProject | MasterProject | 1 | |
| MasterProjectIsConfidential | MasterProjectIsConfidential | 1 | |
| MasterProjectOrganization | MasterProjectOrganization | 1 | |
| MasterProjectType | MasterProjectType | 1 | |
| MaterialDocumentHeaderText | MaterialDocumentHeaderText | 1 | |
| mod_timestamp | HCMTimeEventModifDateTime | 1 | |
| name | piece_list_name | 1 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 5 | |
| PaymentTerms | PaymentTerms | 2 | |
| PayrollCurrency | PayrollCurrency | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 8 | |
| PRAAutoSuspensionLevel | PRAAutoSuspensionLevel | 2 | |
| ProductionPlant | ProductionPlant | 1 | |
| ProjectUUID | MasterProjectUUID | 1 | |
| PurchaseOrderDate | PurchaseOrderDate | 2 | |
| PurchaseOrderType | PurchaseOrderType | 2 | |
| PurchasingDocumentStatus | PurchasingDocumentStatus | 2 | |
| PurchasingGroup | PurchasingGroup | 2 | |
| PurchasingOrganization | PurchasingOrganization | 2 | |
| ReferenceDocument | ReferenceDocument | 3 | |
| ReverseDocument | ReverseDocument | 3 | |
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | 3 | |
| RU_CustomsDeclaration | RU_CustomsDeclaration,RU_CustomsDeclarationForEdit | 1 | |
| RU_CustomsDeclarationOrigin | RU_CustomsDeclarationOrigin,RU_CustomsDeclnOriginForEdit | 1 | |
| RU_CustomsDeclarationType | RU_CustomsDeclarationType,RU_CustomsDeclnTypeForEdit | 1 | |
| RU_EntryCustomsOffice | RU_EntryCustomsOffice,RU_EntryCustomsOfficeForEdit | 1 | |
| SenderAccountingDocument | SenderAccountingDocument | 3 | |
| SenderCompanyCode | SenderCompanyCode | 3 | |
| SenderFiscalYear | SenderFiscalYear | 3 | |
| SenderLogicalSystem | SenderLogicalSystem | 3 | |
| ServicePartsSelectionType | ServicePartsSelectionType | 1 | |
| status | HCMTimeEventStatus | 1 | |
| SuplrCoIsBusPrpsCmpltd | SuplrCoIsBusPrpsCmpltd | 1 | |
| Supplier | Supplier,SupplierForEdit | 3 | |
| SupplierAccountGroup | SupplierAccountGroup | 1 | |
| SupplierAuthznGrp | SupplierAuthznGrp | 1 | |
| SupplierCompanyAuthznGroup | SupplierCompanyAuthznGroup | 1 | |
| SupplierIsBusPrpsCmpltd | SupplierIsBusPrpsCmpltd | 1 | |
| TaxFulfillmentDate | TaxFulfillmentDate | 3 | |
| TaxReportingDate | TaxReportingDate | 4 | |
| TransactionCode | TransactionCode | 1 | |
| transactiontype | headerTransactionType | 2 | |
| UnitOfMeasure | UnitOfMeasure | 3 | |
| UnitOfMeasureIsHidden | UnitOfMeasureIsHidden | 1 | |
| version_no | HCMTimeRequestVersion | 1 | |
| waers | TransactionCurrency | 2 | |
| WorkCenter | WorkCenter | 2 | |
| WorkCenterCategoryCode | WorkCenterCategoryCode | 1 | |
| workitem_id | HCMTimeEventInstanceID | 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 _HEADER (
CN_GOLDENTAXCOMBINATIONID,
CN_GOLDENTAXDOCUMENT,
CNSLDTNPOSTINGRULELOGUUID,
EWMWAREHOUSE,
HANDLINGUNITNUMBER,
MATERIALDOCUMENT,
MATERIALDOCUMENTYEAR,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTLOGICALSYSTEM,
REFERENCEDOCUMENTTYPE,
SALESORDER,
ABSOLUTEEXCHANGERATE,
ACCOUNTINGDOCCREATEDBYUSER,
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTHEADERTEXT,
ACCOUNTINGDOCUMENTTYPE,
ALTERNATIVEREFERENCEDOCUMENT,
BLART,
BLTYP,
BUDAT,
BUKRS,
CAAUTHORIZATIONGROUP,
CAPACITYLASTCHANGEDATETIME,
CAREVERSALDOCUMENTNUMBER,
CASTANDARDCOMPANYCODE,
CHANGEDOCCHANGETYPE,
CHANGEDOCLANGUAGE,
CHANGEHISTORYCOUNT,
CHANGETRANSACTIONCODE,
CHECK_CATEGORY,
CMMDTYEXPNCALLINGAPPLICATION,
COMBINEDACCTSTATUSTEXT,
COMBINEDACCTSTSCRITLTY,
COMBINEDHDRSTATUSTEXT,
COMBINEDHDRSTSCRITLTY,
COMBINEDMKTGSTATUSCRITLTY,
COMBINEDMKTGSTATUSTEXT,
COMBINEDOWNRSTATUSTEXT,
COMBINEDOWNRSTSCRITLTY,
COMBINEDTAXSTATUSTEXT,
COMBINEDTAXSTSCRITLTY,
COMPANYCODE,
COMPANYCODECURRENCY,
CONSOLIDATIONCHARTOFACCOUNTS,
CONSOLIDATIONGROUP,
CONSOLIDATIONTASK,
CONSOLIDATIONTASKRUNISTEST,
CONSOLIDATIONTASKTYPE,
CONSOLIDATIONVERSION,
CONTEXT_SUPLR_CAT,
CONTEXTTYPE,
CONTROLLINGAREAFOREDIT,
CREATEDBYUSER,
CREATIONDATE,
CREATIONDATETIME,
CREATIONTIME,
CURRENCY,
CURRENCYISHIDDEN,
CUSTOMER,
CUSTOMSDECLARATIONDATE,
DATACONTROLLER1,
DATACONTROLLER10,
DATACONTROLLER2,
DATACONTROLLER3,
DATACONTROLLER4,
DATACONTROLLER5,
DATACONTROLLER6,
DATACONTROLLER7,
DATACONTROLLER8,
DATACONTROLLER9,
DATACONTROLLERSET,
DELIVERYNETWORKNAME,
DOCUMENTDATE,
DOCUMENTREFERENCEID,
EXCHANGERATEDATE,
EXCHANGERATETYPE,
FIKRS,
FISCALPERIOD,
FISCALYEAR,
FISCALYEARFOREDIT,
FISCALYEARPERIOD,
GOODSMOVEMENTCODE,
GRANTCURRENCY,
GRANTEEMGMTAPPROVALDATE,
GRANTEEMGMTAPPROVALTIME,
GRANTEEMGMTBUDGETINGPROCESS,
GRANTEEMGMTBUDGETREASON,
GRANTEEMGMTBUDGETSTATUS,
GRANTEEMGMTBUDGETVERSION,
GRANTEEMGMTBUDGETVERSIONORIGIN,
GRANTEEMGMTWORKFLOWSTATUS,
GRANTID,
GTEEMBDGTENTRYDOCRVSLSTATUS,
GTEEMBUDGETENTRYDOCORIGIN,
GTEEMBUDGETENTRYDOCSTATUS,
GTEEMBUDGETENTRYDOCUMENTDESC,
GTEEMBUDGETENTRYDOCUMENTTYPE,
GTEEMRVSLREFBUDGETENTRYDOC,
HWAER,
INCOTERMSVERSION,
INVENTORYTRANSACTIONTYPE,
INVTRYMGMTREFERENCEDOCUMENT,
ISREVERSAL,
ISREVERSED,
ISSETTLED,
KOKRS,
LEDGERGROUP,
LOCALCURRENCY,
LOCKBOX,
LOGICALSYSTEM,
MASTERPROJECT,
MASTERPROJECTISCONFIDENTIAL,
MASTERPROJECTORGANIZATION,
MASTERPROJECTTYPE,
MATERIALDOCUMENTHEADERTEXT,
MOD_TIMESTAMP,
NAME,
ORIGINALREFERENCEDOCUMENT,
PAYMENTTERMS,
PAYROLLCURRENCY,
PLANT,
POSTINGDATE,
PRAAUTOSUSPENSIONLEVEL,
PRODUCTIONPLANT,
PROJECTUUID,
PURCHASEORDERDATE,
PURCHASEORDERTYPE,
PURCHASINGDOCUMENTSTATUS,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
REFERENCEDOCUMENT,
REVERSEDOCUMENT,
REVERSEDOCUMENTFISCALYEAR,
RU_CUSTOMSDECLARATION,
RU_CUSTOMSDECLARATIONORIGIN,
RU_CUSTOMSDECLARATIONTYPE,
RU_ENTRYCUSTOMSOFFICE,
SENDERACCOUNTINGDOCUMENT,
SENDERCOMPANYCODE,
SENDERFISCALYEAR,
SENDERLOGICALSYSTEM,
SERVICEPARTSSELECTIONTYPE,
STATUS,
SUPLRCOISBUSPRPSCMPLTD,
SUPPLIER,
SUPPLIERACCOUNTGROUP,
SUPPLIERAUTHZNGRP,
SUPPLIERCOMPANYAUTHZNGROUP,
SUPPLIERISBUSPRPSCMPLTD,
TAXFULFILLMENTDATE,
TAXREPORTINGDATE,
TRANSACTIONCODE,
TRANSACTIONTYPE,
UNITOFMEASURE,
UNITOFMEASUREISHIDDEN,
VERSION_NO,
WAERS,
WORKCENTER,
WORKCENTERCATEGORYCODE,
WORKITEM_ID,
PRIMARY KEY (CN_GOLDENTAXCOMBINATIONID, CN_GOLDENTAXDOCUMENT, CNSLDTNPOSTINGRULELOGUUID, EWMWAREHOUSE, HANDLINGUNITNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTTYPE, SALESORDER)
);
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