_PRELIMBILLINGDOCUMENT

_PRELIMBILLINGDOCUMENT is an SAP database table in S/4HANA. It contains 88 fields.

Fields (88)

KeyField CDS FieldsUsed in Views
_BillingDocumentCategory _BillingDocumentCategory 1
_BillingDocumentType _BillingDocumentType 1
_BillingIssueType _BillingIssueType 1
_CityCode _CityCode 1
_CompanyCode _CompanyCode 1
_Country _Country 1
_CreditControlArea _CreditControlArea 1
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup 1
_CustomerGroup _CustomerGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_CustomerPriceGroup _CustomerPriceGroup 1
_DistributionChannel _DistributionChannel 1
_DunningArea _DunningArea 1
_DunningBlockingReason _DunningBlockingReason 1
_DunningKey _DunningKey 1
_ExchangeRateType _ExchangeRateType 1
_IncotermsClassification _IncotermsClassification 1
_IncotermsVersion _IncotermsVersion 1
_OverallPricingIncompletionSts _OverallPricingIncompletionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 1
_PayerParty _PayerParty 1
_PaymentMethod _PaymentMethod 1
_PriceListType _PriceListType 1
_Region _Region 1
_SalesDistrict _SalesDistrict 1
_SalesOrganization _SalesOrganization 1
_SDDocumentCategory _SDDocumentCategory 1
_ShippingCondition _ShippingCondition 1
_SoldToParty _SoldToParty 1
_TaxDepartureCountry _TaxDepartureCountry 1
_VATRegistrationCountry _VATRegistrationCountry 1
_VATRegistrationOrigin _VATRegistrationOrigin 1
AdditionalValueDays AdditionalValueDays 1
BillingDocCombinationCriteria BillingDocCombinationCriteria 1
BillingDocumentCategory BillingDocumentCategory 1
BillingDocumentDate BillingDocumentDate 1
BillingDocumentType BillingDocumentType 3
CityCode CityCode 1
CompanyCode CompanyCode 1
ContractAccount ContractAccount 1
Country Country 1
County County 1
CreditControlArea CreditControlArea 1
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 1
CustomerGroup CustomerGroup 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPriceGroup CustomerPriceGroup 1
CustomerTaxClassification1 CustomerTaxClassification1 1
CustomerTaxClassification2 CustomerTaxClassification2 1
CustomerTaxClassification3 CustomerTaxClassification3 1
CustomerTaxClassification4 CustomerTaxClassification4 1
CustomerTaxClassification5 CustomerTaxClassification5 1
CustomerTaxClassification6 CustomerTaxClassification6 1
CustomerTaxClassification7 CustomerTaxClassification7 1
CustomerTaxClassification8 CustomerTaxClassification8 1
CustomerTaxClassification9 CustomerTaxClassification9 1
DistributionChannel DistributionChannel 1
DunningArea DunningArea 1
DunningBlockingReason DunningBlockingReason 1
DunningKey DunningKey 1
ExchangeRateType ExchangeRateType 1
FixedValueDate FixedValueDate 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
IsRelevantForAccrual IsRelevantForAccrual 3
LastChangeDate LastChangeDate 1
PartnerCompany PartnerCompany 1
PayerParty PayerParty 1
PaymentMethod PaymentMethod 1
PaymentReference PaymentReference 1
PBDIsInMyResponsibility PBDIsInMyResponsibility 5
PriceListType PriceListType 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
Region Region 1
SalesDistrict SalesDistrict 1
SalesOrganization SalesOrganization 3
SDDocumentCategory SDDocumentCategory 1
SDPricingProcedure SDPricingProcedure 1
ShippingCondition ShippingCondition 1
SoldToParty SoldToParty 1
TaxDepartureCountry TaxDepartureCountry 1
VATRegistration VATRegistration 1
VATRegistrationCountry VATRegistrationCountry 1
VATRegistrationOrigin VATRegistrationOrigin 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 _PRELIMBILLINGDOCUMENT (
    _BILLINGDOCUMENTCATEGORY,
    _BILLINGDOCUMENTTYPE,
    _BILLINGISSUETYPE,
    _CITYCODE,
    _COMPANYCODE,
    _COUNTRY,
    _CREDITCONTROLAREA,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DISTRIBUTIONCHANNEL,
    _DUNNINGAREA,
    _DUNNINGBLOCKINGREASON,
    _DUNNINGKEY,
    _EXCHANGERATETYPE,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _OVERALLPRICINGINCOMPLETIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _PAYERPARTY,
    _PAYMENTMETHOD,
    _PRICELISTTYPE,
    _REGION,
    _SALESDISTRICT,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SHIPPINGCONDITION,
    _SOLDTOPARTY,
    _TAXDEPARTURECOUNTRY,
    _VATREGISTRATIONCOUNTRY,
    _VATREGISTRATIONORIGIN,
    ADDITIONALVALUEDAYS,
    BILLINGDOCCOMBINATIONCRITERIA,
    BILLINGDOCUMENTCATEGORY,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTTYPE,
    CITYCODE,
    COMPANYCODE,
    CONTRACTACCOUNT,
    COUNTRY,
    COUNTY,
    CREDITCONTROLAREA,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DISTRIBUTIONCHANNEL,
    DUNNINGAREA,
    DUNNINGBLOCKINGREASON,
    DUNNINGKEY,
    EXCHANGERATETYPE,
    FIXEDVALUEDATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    ISRELEVANTFORACCRUAL,
    LASTCHANGEDATE,
    PARTNERCOMPANY,
    PAYERPARTY,
    PAYMENTMETHOD,
    PAYMENTREFERENCE,
    PBDISINMYRESPONSIBILITY,
    PRICELISTTYPE,
    PURCHASEORDERBYCUSTOMER,
    REGION,
    SALESDISTRICT,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDPRICINGPROCEDURE,
    SHIPPINGCONDITION,
    SOLDTOPARTY,
    TAXDEPARTURECOUNTRY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    VATREGISTRATIONORIGIN
);