NEW

48 Fields

NEW is an SAP database table in S/4HANA. It contains 48 fields.

Fields (48)

KeyField CDS FieldsUsed in Views
KEY ConditionType ConditionType 1
KEY PricingConditionTerm PricingConditionTerm 1
KEY SourceDocument SourceDocument 1
KEY SourceDocumentItem SourceDocumentItem 1
_DerivativeContrSpecification _DerivativeContrSpecification 1
AuthorizationGroup AuthorizationGroup 1
BusinessObjectType BusinessObjectType 1
BusinessPartner BusinessPartner 1
BusinessPartnerName BusinessPartnerName 1
CalcdPrcgCndnTermQuantityUnit CalcdPrcgCndnTermQuantityUnit 1
CalcdPrcgConditionTermQuantity CalcdPrcgConditionTermQuantity 1
CndnTermFixationOptionLimitQty CndnTermFixationOptionLimitQty 1
CndnTermFixationOptnLmtQtyUnit CndnTermFixationOptnLmtQtyUnit 1
CndnTrmFixationOptnNonFixedQty CndnTrmFixationOptnNonFixedQty 1
CompanyCode CompanyCode 1
ConditionApplication ConditionApplication 1
ConditionTermRateCurrency ConditionTermRateCurrency 1
ConditionTermRateQuantity ConditionTermRateQuantity 1
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit 1
CreatedByUser CreatedByUser 1
CurrencyConversionIsAllowed CurrencyConversionIsAllowed 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
DerivativeContrSpecification DerivativeContrSpecification 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentDate DocumentDate 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastChangeDateTime LastChangeDateTime 1
Material Material 1
Plant Plant 1
PrcgCndnTermCnvrsnSourceCrcy PrcgCndnTermCnvrsnSourceCrcy 1
PrcgCndnTermCnvrsnTargetCrcy PrcgCndnTermCnvrsnTargetCrcy 1
PrcgCndnTermFixationOptnStatus PrcgCndnTermFixationOptnStatus 1
PrcgConditionFormulaInputUUID PrcgConditionFormulaInputUUID 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
SalesOrganization SalesOrganization 1
TrmFixationOptnNonFixedQtyUnit TrmFixationOptnNonFixedQtyUnit 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 NEW (
    CONDITIONTYPE,
    PRICINGCONDITIONTERM,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTITEM,
    _DERIVATIVECONTRSPECIFICATION,
    AUTHORIZATIONGROUP,
    BUSINESSOBJECTTYPE,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    CALCDPRCGCNDNTERMQUANTITYUNIT,
    CALCDPRCGCONDITIONTERMQUANTITY,
    CNDNTERMFIXATIONOPTIONLIMITQTY,
    CNDNTERMFIXATIONOPTNLMTQTYUNIT,
    CNDNTRMFIXATIONOPTNNONFIXEDQTY,
    COMPANYCODE,
    CONDITIONAPPLICATION,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CREATEDBYUSER,
    CURRENCYCONVERSIONISALLOWED,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDATETIME,
    MATERIAL,
    PLANT,
    PRCGCNDNTERMCNVRSNSOURCECRCY,
    PRCGCNDNTERMCNVRSNTARGETCRCY,
    PRCGCNDNTERMFIXATIONOPTNSTATUS,
    PRCGCONDITIONFORMULAINPUTUUID,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    TRMFIXATIONOPTNNONFIXEDQTYUNIT,
    PRIMARY KEY (CONDITIONTYPE, PRICINGCONDITIONTERM, SOURCEDOCUMENT, SOURCEDOCUMENTITEM)
);

Learn More