SDOC

SDOC is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
AdditionalCustomerGroup1 AdditionalCustomerGroup1 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 1
AdditionalCustomerGroup3 AdditionalCustomerGroup3 1
AdditionalCustomerGroup4 AdditionalCustomerGroup4 1
AdditionalCustomerGroup5 AdditionalCustomerGroup5 1
AlternativeInvoicingParty AlternativeInvoicingParty 10
BillingCompanyCode BillingCompanyCode 1
BillToParty BillToParty 10
CndnContrProcessCategory CndnContrProcessCategory 10
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CustSettlmtCompanyCode CustSettlmtCompanyCode 10
DistributionChannel DistributionChannel 11
Division Division 10
DocumentDate DocumentDate 10
ExchangeRateType ExchangeRateType 1
HeaderBillingBlockReason HeaderBillingBlockReason 1
InvoicingParty InvoicingParty 10
OrganizationDivision OrganizationDivision 1
PayeeParty PayeeParty 10
PayerParty PayerParty 10
PostingDate PostingDate 10
PostingPartnerCat PostingPartnerCat 10
PurchasingGroup PurchasingGroup 10
PurchasingOrganization PurchasingOrganization 10
SalesDocumentDate SalesDocumentDate 1
SalesDocumentType SalesDocumentType 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 11
SDDocumentCategory SDDocumentCategory 1
SDDocumentReason SDDocumentReason 1
SettlmtDate SettlmtDate 10
SettlmtDocAuthznCat SettlmtDocAuthznCat 10
SettlmtDocCurrency SettlmtDocCurrency 10
SettlmtDocType SettlmtDocType 10
SettlmtMgmtAcctgTransfSts SettlmtMgmtAcctgTransfSts 10
SettlmtProcessType SettlmtProcessType 10
SoldToParty SoldToParty 1
StatisticsCurrency StatisticsCurrency 1
SuplrSettlmtCompanyCode SettlmtCompanyCode 10

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 SDOC (
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ALTERNATIVEINVOICINGPARTY,
    BILLINGCOMPANYCODE,
    BILLTOPARTY,
    CNDNCONTRPROCESSCATEGORY,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTSETTLMTCOMPANYCODE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    EXCHANGERATETYPE,
    HEADERBILLINGBLOCKREASON,
    INVOICINGPARTY,
    ORGANIZATIONDIVISION,
    PAYEEPARTY,
    PAYERPARTY,
    POSTINGDATE,
    POSTINGPARTNERCAT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESDOCUMENTDATE,
    SALESDOCUMENTTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREASON,
    SETTLMTDATE,
    SETTLMTDOCAUTHZNCAT,
    SETTLMTDOCCURRENCY,
    SETTLMTDOCTYPE,
    SETTLMTMGMTACCTGTRANSFSTS,
    SETTLMTPROCESSTYPE,
    SOLDTOPARTY,
    STATISTICSCURRENCY,
    SUPLRSETTLMTCOMPANYCODE
);